Results 1 to 3 of 3
  1. #1
    ser01 is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Feb 2010
    Posts
    64

    Check if form is opened by other users


    Hi all!
    I have a database with multiple forms. I have some code that uses IsLoaded to check if certain forms are open and if it reurtns true than open other forms. It all works fine except for the fact that if a different users has the form opened than it does not work corectly. Is there a way to check if the form is opened by a different user without having to split the database into front/back end? I know this is the right thing to do, but just dont have the time right now
    Thank you in advance...
    Last edited by ser01; 05-03-2010 at 12:08 AM.

  2. #2
    Mclaren is offline Competent Performer
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Feb 2010
    Location
    Johannesburg
    Posts
    164
    Create a table that is updated when a form is open. (in the table ensure you have fields that track which PC or which User has opened the form).when a form closes delete the appropriate record. that way you should be able to tell, A: which PC has a form open and B which user on that PC has a form open.

  3. #3
    ser01 is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Feb 2010
    Posts
    64
    Quote Originally Posted by Mclaren View Post
    Create a table that is updated when a form is open. (in the table ensure you have fields that track which PC or which User has opened the form).when a form closes delete the appropriate record. that way you should be able to tell, A: which PC has a form open and B which user on that PC has a form open.
    Very clever, thank you...

Please reply to this thread with any new information or opinions.

Similar Threads

  1. To check or Un-Check all Boxes in a form
    By devcon in forum Forms
    Replies: 7
    Last Post: 05-01-2010, 12:03 AM
  2. Multiple users keying into one form......
    By softspoken in forum Forms
    Replies: 11
    Last Post: 04-13-2010, 02:18 PM
  3. How can I check if a sub form was expanded?
    By tazquebec in forum Programming
    Replies: 7
    Last Post: 02-08-2010, 05:15 PM
  4. Mail Merge document locked when opened from Access
    By retro in forum Import/Export Data
    Replies: 0
    Last Post: 08-14-2009, 03:12 AM
  5. Replies: 1
    Last Post: 01-04-2008, 11:40 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums