Search results for query: *

Hi Pampers, I thought you were right at first, but then i discovered that if the db is on the local pc, you are right it is impossible, but if the db resides on a remote drive and you create a shortcut to open from another pc, it can be opened more than once.

I have a small peer-peer setup with a database on 1 pc, another 3 users access the database. Is there any way I can stop the same user from opening the database more than once ?

I have a small peer-peer setup with a database on 1 pc, another 3 users access the database. Is there any way I can stop the same user from opening the database more than once ?

because ive got cancel = true on the on_exit() of the text box its not allowing me to click the exit button. the cancel = true works well stopping null input and remaining on that control, but i need to only overrride if the close form command button is clicked.

Sorry it almost worked, allows me to now click the exit button, but allows the user to exit the text box for the input i.e. allows press enter to go to next control without entering anything, i think this is because its processes the text box on-exit()totally before it recognises the...

Thank you both - worked great

I have some code set at on exit() that stops the user entering Null as follows : If IsNull(Me.Search) Then Cancel = True works well where input is required, but i need to allow the form exit command button to be pressed, the command above doesn't allow this. Is there any additional code i can...