Recent content by CustomCode

use me.refresh Make sure me.refresh occurs before you run the query You are getting the write conflict because the record is locked. While the record is locked you are now trying to make another change the record with a query. The query is treated by access like it is a different user. Hope...

Different units have different spreads between the service dates. Some units will get an Oil change every 30 days because they idle alot, where other will be 60 days etc. I also have to save them because I received request for the last date on the specific services. If I had a sample how to put...

When the user check the service. The form calculates the service due and stores it in the NextSerType. In some cases the unit may be due for a Wet, CVI, Diff Oil Change, Trans Oil change, Hydraulic Oil Change, Reefer Service, Tire Rotation or Warranty Inspection. A unit may be due for many of...

Hi I have a query that takes current kilometers and compares it with the next dry service and wet service kilometers. The query is set so the vehicle does not show on the report till it is due for a service. The query works the same way by date. If the current date is equal or greater then the...

The safe method would be to place the backend of the database on a network drive and set the permissions. Link the front - end, and DONOT specify the mapped drive letter path of the network drive. If you do... individuals who have specified a different drive letter will not access the database...

The following fix worked everytime for me The Fix: 1. Check the residing folder of the database for a db1.mdb. If it has one, to avoid conflicts, put it in a temp folder while you work. After all the steps are completed, you may want to determine what it is. I would not recommend using it...