Recent content by knothed

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

Thanks Pat for you help but perhaps I didn't explain my problem very well. In our multiuser enviroment if any user has one of the many forms linked to this table open the query approach does not work because the table can not be locked. That's why I decided to do the temp table arrangment and I...

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 use a macro which consists of only two lines. Open Form Maximize Then I right click on it in the macro group and create a shortcut to my desktop

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