Search results

Yes it has been split. I have the front end on the desktop while the backend is on a shared drive with read and write access.

Hi James, I maybe wrong but when the user opens the form the only code which runs is the Dlookup for the username which hangs up the whole form. If the user tries to enter any number in the search field then it doesn't enter the number and comes up with an error 3218. I would think if it would...

Hi James, Thanks for your reply. I tried it for 2 users and it was working fine but the more number of users come in it starts giving the error. The other strange thing is that it would work without any errors for 2 hours (even with 7 people) and suddenly start giving errors.

Hi James, The code which is causing the error is this Private Sub Form_Load() CsrName = DLookup("Name", "T Number Fields", "TNumber= '" & Forms![In Life Trigger Tracker]!Username & "'") End Sub Yes the back end is an access database - The error just comes up when i guess the form is idle for...

Hi, I have a form 3 tables. Table 1 contains records Table 2 Contains an empty table which is a replica of Table 1 but has a few more fields to update. Now when the user opens the form the Employee id(thro the system login) comes up thro a module which works fine. I have run a dlookup on the...