Search results

Whenever I run that an error message comes up which says - 'Operation must use an updateable query' Any ideas?

I have two tables - Table1(ItemID, Quantity) Table2(ItemID, Quantity) I want to run a query so that if i enter a value for quantity in table 2 that is less than the value in table 1 that it will take the value from table 2 and replace the value in table 1 with this value. How do I do this...

Ignore this post!

Thanks so much. It does exactly what I want!

I Have been trying for a while to get photographs to work in a form. At the minute I can select the file I want to add to the form but when I move to the next record the same picture is still displayed and I cannot understand why this is happening. I have adapted the code form the sample...

Krava Thanks so much for the help. The report now works perfectly.

Thanks for the help again. Is it possible to setup a form to enter information into, but only have it hold the information temporarily so that a table does not have to be created and saved each time? (ie. The table would be deleted after the report had been generated?) Thanks

Thanks Krava tha worked a treat! I have got it so that I can add one date onto the letter. If I wanted to add, say six seperate dates would I just add 6 columns to the query and then have 6 pop up boxes opening when I open the report or is there a better way to do it than this? Hope this makes...

I have a report setup in the format of a letter which is sent out to perople periodically. It takes the name and other information from a table. Each time the letter is sent out, it is to inform people of meetings on different dates. Is it possible to have a prompt that when the report is run...

This will seem breally stupid but Am I creating a new module to enter the code in? As you can obviously not attach the VB code to an object in the database.

I need to add a photograph to each record that I have in a form. This photograph will then be used along with the data entered in the form to create a report. I have used the search function to try to do this but my Access skills are not the best and I am having trouble in trying to understand...

I am creating a database for someone which includes a mail merged document with some data from the database. Is it possible to allow the user to open the document by clicking on a button that will be on the Switchboard in the database, so that they do not have manually open the document? Hope...

I would like to create a seperate field for each record in my query which would number the results of the query in ascending order, say from 1 to 100. Is it possible to do this in a query?

Bob - Thank you so much that does exactly as I wanted. It is very much appreciated.

I think that could be the problem, but how do I relate it back to a record in the Athletes table?

Oh. If it helps the SQL for the query to calculate age from date of birth is - SELECT DateDiff("yyyy",[DOB],Now())+Int(Format(Now(),"mmdd")<Format([DOB],"mmdd")) AS Age FROM Athletes;

Okay. The SQL is - UPDATE Athletes, qryAge SET Athletes.[Age Group] = IIf(qryAge!Age>"18","Under 18",(IIf(qryAge!Age>"17" And [qryAge!Age]<"35","Under 35",(IIf(qryAge!Age>"34" And qryAge!Age<"45","Under 45",(IIf(qryAge!Age>"44" And [qryAge!Age]<"55","Under 55",(IIf(qryAge!Age<"44","Over...

Yeh, the IIF statement is in the update to cell. The [qryAge!Age] query returns four results as there are currently only four records in the table. There are no joins in the statement. Is there any other easier way of doing this?

Okay I have fixed the first mistake!! Whenever I run it it says it is going to update 16 rows, yet I only have four records in the database (just to test if it is working). Then when I go into the table all the age groups in the four records have been set to 'Under 18'.

I hope that this will be simple for you - I have a table which includes the fields Date of Birth and Age Group. Age Group is based on the persons age so I created a query (qryAge) to calculate age using the statement: DateDiff("yyyy",[DOB],Now())+Int(Format(Now(),"mmdd")<Format([DOB],"mmdd"))...