How to not open if someone else does

[Bonnie]

Hi there. Using A02 on XP. Have a deposit ticket test form
that about 6 folks take turns using to verify/print their
portion of the deposit items for balancing (a button click
clears the tape as you begin). Rather than create 6 tables
and forms I would prefer to just have a message tell
them 'someone else already has the form open, return
later' and exit the sub. Tried if me.dirty, etc. Not sure
where it is best to accomplish this.

Would really appreciate any help or advice. Thanks in
advance for your time and expertise.

 

[Rick B]

Why not just give everyone a copy of the database? Does the data get saved
( you say a button "clears the tape")?

Or, why not add a "userid" field to the table and forms so multiple users
can enter data, but the form will only pull data for the particular signed
on user?

Would need to know much more about your data structure to give you more
details.

Rick B

 

[Rick B]

Oops. Also meant to say...

If you are sure you want to stick to your original plan, then check out...

Tools/Open/Advanced/Default Open Mode.


Rick B

 

[Bonnie]

Hi there, thanks for the reply. I am in the process of
getting approval from my systems folks to implement an
Auto Front End Updater from Tony Granite's website as I
have nearly 70 users on about 10-15 FE MDB's.

My post here was for a temp table test ticket that folks
just needed to open and print a calculator tape of their
deposit items. Others would open their work in progress
and clear the tape to use it themselves, not knowing they
had cleared someone's work in progress. So I have ended up
adding a 'clear table' query to the close button and put
code in the form's onopen if recordset>0 msgbox "cant use,
try another" cancel, exit sub.