I am looking to be able to have a pop up box on a form, so that when another user goes into the same job number they know its allready open by someone else.

Currently I have a table called tblSession this inputs the UserName, JobNumber and DateTime everytime a user goes into any job number, once they come out of that job their details are deleted from the table. How do I write some code so that it tell the user via pop up box that User X is already in this job?

I know that in excel I would do a lookup to the reference table, but just not sure in access.

Thanks,
Jez

Control all access to the data in question so that it is through from's you have written.
Create a public counting variable in a module.
Any time the form opens, increment the variable.
If before the increment it is > 0, or after the increment it is > 1, display your message.
In the close/unload event of the form, decrement the variable.

Thanks for the reply, but dont really understand what you mean, could you explain a bit more please.
Jez

Take the job number from the form, then look it up in the table. If it is there, then close the job form and pop up a message.

How are they opening the job form? This is the same process that puts the job number in the session table. Do they select a job number and click a button? If so, this is easy.

Please post more details.

mmcdonal

To solve your problem you can try this approach

1) Create a columns called "STATUS" in the table where you insert your job details

2) When a user open a particular jobno, set the status to "OPEN"

3) When a user try to open a particular job, check the status of the job. If its "OPEN" display a message that the job is open.

__________________
Vikash Kumar Singh

Would there be record locking issues with this solution? One user has it open and locked and another is trying to take information from it? Or would that only be a write issue? I like this solution. Just add a WHERE clause to your open statement to prevent the form opening. And add an event On Open to check for records and pop up a message and go back to the originating form.


mmcdonal

There will be no Locking issue.

It depends what you want to do, when one user has open the record(JOB), what the application want, to display a message or let him read only access to the record.

__________________
Vikash Kumar Singh