Results 1 to 3 of 3
  1. #1
    matey56 is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Jul 2020
    Posts
    136

    Weird error message

    Hi all,
    I have a pretty large Access DB that I all of sudden started getting this error message when I open it. I didn't make any changes recently so I'm not sure what's going on. Can anyone assist? What is this error telling me?

    Click image for larger version. 

Name:	Capture.JPG 
Views:	19 
Size:	29.1 KB 
ID:	48774




    Here is the code I use for the On Load event to hide the ribbon and toolbar. Again, I didn't change anything in a long time.

    Private Sub Command185_Click()
    DoCmd.ShowToolbar "Ribbon", acToolbarYes
    End Sub


    Private Sub Command186_Click()
    DoCmd.ShowToolbar "Ribbon", acToolbarNo
    End Sub


    Private Sub Form_Load()
    DoCmd.ShowToolbar "Ribbon", acToolbarNo
    End Sub



  2. #2
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Have you tried to compile it? Also check for any missing references.

    EDIT: Also check the form's module for any orphan code (in the VBE window look under the Declarations on the top right and see if there is anything referencing a control that no longer exists) and remove it if yes.
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  3. #3
    matey56 is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Jul 2020
    Posts
    136
    Quote Originally Posted by Gicu View Post
    Have you tried to compile it? Also check for any missing references.

    EDIT: Also check the form's module for any orphan code (in the VBE window look under the Declarations on the top right and see if there is anything referencing a control that no longer exists) and remove it if yes.
    So weird. I just removed the On Load code "Private Sub Form_Load() DoCmd.ShowToolbar "Ribbon", acToolbarNo End Sub" closed the DB, re-opened it and added back in and I no longer get the error.

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

Similar Threads

  1. Weird Error, Not Sure, Disguised as Error 3075
    By CoffeeFunnel in forum Programming
    Replies: 4
    Last Post: 09-11-2017, 02:33 PM
  2. Weird Query error
    By RayMilhon in forum Queries
    Replies: 2
    Last Post: 11-15-2016, 02:33 PM
  3. Replies: 7
    Last Post: 03-17-2016, 05:53 PM
  4. Weird Error on opening a form
    By RayMilhon in forum Forms
    Replies: 1
    Last Post: 01-10-2012, 05:44 PM
  5. Weird Error
    By KevinMCB in forum Access
    Replies: 1
    Last Post: 02-16-2011, 02:23 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