Results 1 to 7 of 7
  1. #1
    joshynaresh is offline Competent Performer
    Windows 7 32bit Access 2007
    Join Date
    Aug 2013
    Posts
    131

    closing form

    hi,



    I have 3 form i.e. login , switchboard, datechange.

    When user id and password matches switchboard open(if defined date <> today then datechange open(note: this code has placed in onload event of swithchboard))

    i want login should be closed after switchboard(switchboard take userid value to user fild of switchboard from login page whice is defined on load event of swithboard) open
    Attached Files Attached Files
    Last edited by joshynaresh; 02-03-2014 at 11:14 PM. Reason: attaching sampledb

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Do you really want people to help when you have the code password protected?

  3. #3
    joshynaresh is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2013
    Posts
    131

    closing form

    I'm really sorry. I have attached wrong db. now I have attached other db.
    newsample.zip

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Why not close the Login form from the Switchboard form instead of in the Login form?

  5. #5
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Something like: DoCmd.Close acForm, "Login Page", acSaveNo should do it and then the DoCmd.Close acForm, "Login Page" in the Login Page form is not needed.

  6. #6
    joshynaresh is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2013
    Posts
    131
    Thanks Buddy. It is working.

    Thank You once again

  7. #7
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You're welcome. Glad we could help.

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

Similar Threads

  1. Form closing unexpectedly
    By michaelwh1 in forum Access
    Replies: 4
    Last Post: 03-22-2013, 04:12 PM
  2. Don't save when closing form
    By thefairman in forum Forms
    Replies: 4
    Last Post: 02-21-2012, 09:00 PM
  3. Closing 1 form and opening another
    By mulefeathers in forum Forms
    Replies: 13
    Last Post: 12-08-2011, 04:04 PM
  4. Closing a form through VBA
    By ghostmachine in forum Forms
    Replies: 4
    Last Post: 12-13-2010, 01:57 PM
  5. Prevent a form from closing
    By ksmithson in forum Forms
    Replies: 0
    Last Post: 07-15-2010, 12:49 PM

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