Search results

I have a command button on a form that opens another form based on a query and prompts the user for a serial number. It works fine until the user types in a serial number that has not yet been produced. Then an access error occurs and the user has to click ok in the message box and then on Halt...

I run a macro that copies a table and runs a query and opens a report both on this temporary table. In the on close event of the report I would like to delete this temporary table but access tells me it can not lock the table because it is in use by someone else. I am currently the only user of...

I have a combo box on my form that searches for a serial number. If that number has not yet been produced the from goes to the first record in the table. I need code that will bring up a message box saying the unit has not been produced and have the form remain on the present record. Thanks in...

I have a control on my form which references a mileage figure in my table. I have another control that figures freight based on that mileage figure ie =miles*freight rate. But a different rule applies if the mileage figure is under 100 miles. I need to write an IIF statement to make this control...