Recent content by robin123

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?