Page 2 of 2 FirstFirst 12
Results 16 to 21 of 21
  1. #16
    augcorv@gmail.com is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Feb 2014
    Posts
    20
    I meant the login screen disappears once you enter the login credentials and select OK. My Bad. I tried replacing the word close with hide with no success.
    Private Sub Form_Timer()
    On Error GoTo Err_Form_Timer
    Dim dbs As DAO.Database
    Dim rst As DAO.Recordset

    Set dbs = currentdb
    Set rst = dbs.OpenRecordset("ztblUserLog", dbOpenDynaset)

    With rst
    .AddNew
    ![SecurityID] = User.SecurityID
    .Update
    End With

    Dim stDocName As String
    Dim stLinkCriteria As String
    stDocName = "fmnuMainMenu"
    DoCmd.OpenForm stDocName, , , stLinkCriteria

    DoCmd.Close acForm, "frmUserLogon"
    DoCmd.Close acForm, "frmStartup"
    DoCmd.Close acForm, "frmUserLogonNew"



    Exit_Form_Timer:
    Exit Sub
    Err_Form_Timer:
    MsgBox Err.Description
    Resume Exit_Form_Timer
    End Sub

  2. #17
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Replace

    DoCmd.Close acForm, "frmUserLogon"

    with

    Forms!frmUserLogon.Visible = False
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #18
    augcorv@gmail.com is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Feb 2014
    Posts
    20
    Great that worked - thank you so much. The only issue now is that when i try to close the event it states must enter a value in the Events. UserID field. im still playing around with it.

  4. #19
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    No problem, post back if you're still stuck.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #20
    augcorv@gmail.com is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Feb 2014
    Posts
    20
    Got it working, WOW... Thank you very much pbaldy for your assistance!!! Very impressed and inspiring!!! ill be working on some more for sure!!!

  6. #21
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Happy to help!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Making daily backup of database
    By JeroenMioch in forum Access
    Replies: 5
    Last Post: 10-30-2013, 04:50 PM
  2. Daily Log Database??
    By brittle in forum Access
    Replies: 2
    Last Post: 08-26-2013, 12:53 PM
  3. Replies: 1
    Last Post: 11-28-2012, 01:09 AM
  4. Help with Table Design for Employee Task Database
    By shelbsassy in forum Database Design
    Replies: 6
    Last Post: 04-08-2011, 05:14 PM
  5. Help starting up a daily entry database
    By sparx in forum Database Design
    Replies: 1
    Last Post: 01-12-2011, 10:56 AM

Tags for this Thread

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