Search results

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...

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...

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...

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?

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"))...