I keep getting this error whenever I run my ASP page Error Type: Microsoft JET Database Engine (0x80004005) Operation must use an updateable...

I received some generous help from the users of this group to get this far. This works great for me. UPDATE tblMain SET tblMain.PrizeAssigned = 1 WHERE...

Is there a way to run a query that returns data that is in one table to not another? For example, I have a table that gets imported that has client names. ...

I am trying to write a query that will show me duplicate information from one field across seven different tables. Example: The Claims Tracking Number field...

I am making a Pivot Chart from Crosstab Query, Can I preserve the formating? i.e. when ever I referesh chart or change the critaria the data lables get lost.

I am very new using access. I have put together a small inventory database. I have a items table, disbursement table and receiving table. I want to pull...

I have a field that contains last name but includes parenthesis, in which I would like to remove. Ex. (Keller). How can I remove the parenthesis on each...

Hi, I got a table with 10 elements (ie: 1,2,3,4,5,6,7,8,9,10) and another one with 20 k (ie: 1,20,3,50,11,1,2,10, ...) I would like to do an INNER JOIN between...

I am trying to devise a calculated field (Epires:) with a formula/function for the following account types. Type 1 expires 1 year from issue date (9/1/07...

I am having some issues with selecting the TOP value in an UPDATE query. I am not an expert and I am looking for advice on the best way to proceed. Here is a...

Folks, Hello. I am have just started looking at writing VBA but having my challenges, please excuse me. Here is my problem. I am running four queries...

I have datediff commands in two queries and I am storing the differences in tables. I am using datediff("d",,) in both queries. I am getting some squirelly...

This query show me forms i once had in my Access 2003 database. SELECT IIf(Left$(,1)="~",Mid$(GetPart(,"~",2),5),) AS Form, MSysObjects.Owner,...

During training we were told about Reverse Joins. I don't find this in Access 2007. Anyone know if it was taken out? I am trying to run a report with all...

Hello, everyone! I want to thank you all for your continuing support and sharing your knowledge with people like me. :) I am trying to do something so...

I'm getting a Syntax Error on this. Any Suggestions? Thanks DS Dim OUTSQL As String DoCmd.SetWarnings False OUTSQL = "UPDATE tblTimeLog SET...

I am trying to update the field which is in the table with strInputtext (this variable is a string) When it runs it does not seem to do anything at...

In my crosstab query design, I put number in standard with 0 decimal in the number field. When I export to excel and open it: 1. All the numbers are still 2...

I am just learning to use queries and the book I am learning from ask for an update query to increase the list price of all products for 'supplier A' by...

i have couple hundred thousands records in Access 2007; here is a sample: Account# Time of Call Reason for Calling 1 ...