Who is connect to this form?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I would know if another user has just opened one form, before then I open
same form.
I appreciate any ideas and, if possible, relative code.
Many thanks for help.
 
You will have to create a table that has the form name and user name as
fields. If you don't care who has the form open, you don't need the user
name, you could use a boolean (Yes/No) field.Then, you can use the form's
Load event to check the table to see if the form is open, and if it is,
present a message box and close. If it is not open, update the table to show
it open.
 
Realistically, you shouldn't care.

Your application should be split into a front-end (containing the queries,
forms, reports, macros and modules), linked to a back-end (containing the
tables and relationships). Only the back-end should be on the server: each
user should have his/her own copy of the front-end, ideally on his/her hard
drive.
 
thanks Douglas, my application will be like you write; actually is in
progress, thus front-end is yet on the server. I am thinking about any
possibility of errors or similar.
This discussion groups helped me several time.
Good things.
--
Giangi El-Dotor
free lance - Italy -


Douglas J. Steele said:
Realistically, you shouldn't care.

Your application should be split into a front-end (containing the queries,
forms, reports, macros and modules), linked to a back-end (containing the
tables and relationships). Only the back-end should be on the server: each
user should have his/her own copy of the front-end, ideally on his/her hard
drive.
Click to expand...
 
Back
Top