Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / May 2008

Tip: Looking for answers? Try searching our database.

Error 2467 Help!

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Eka1618 - 29 May 2008 16:27 GMT
Hello,

I am receiving Error 2467 "object closed or doesn't exist"

I am trying to open a certain page in 2 tab controls (I have 14 total
pages). Every single page in my main form is causing this error to occur. To
be honest, a lot of objects in the main form cause this error when I try to
reference them.

For testing purposes’, I currently have the actual tab buttons showing. If I
click on the one that should be showing, It seems to go to the right IF
condition in my Load event.  

I have a lot going on inside of the main form, there are around 20 sub forms
that are all doing different things when the Main Form loads, and I think it
may be why I am getting the error.

I turned off the Auto correct options as some other posts have suggested,
but I cannot seem to get past the error. Here are samples of code that I have
tried:

1.)
Private Sub Form_Load()

DoCmd.Close acForm, "frmQueueID", acSaveNo

   If CurrentDb.Properties("TestType") = "IMPACT" Then
   
  'THE LINES BELOW CAUSE THE ERROR
   
     Me.pgImpact.Visible = True
     
     Me.pgHandle.Visible = False
     Me.pgOffset.Visible = False
     Me.pgProof.Visible = False
     Me.pgSecurity.Visible = False
     Me.pgStatic.Visible = False
     Me.pgTorque.Visible = False
     
         
     Me.pgIResults.Visible = True
     
     Me.pgHResults.Visible = False
     Me.pgOResults.Visible = False
     Me.pgPResults.Visible = False
     Me.pgSecResults.Visible = False
     Me.pgStResults.Visible = False
     Me.pgTResults.Visible = False

   End If

2.)
Private Sub Form_Load()

DoCmd.Close acForm, "frmQueueID", acSaveNo

Me.txtType.SetFocus 'THIS CAUSES THE ERROR

   If Me.txtType.Text = "IMPACT" Then
   
     Me.pgImpact.Visible = True

     Me.pgHandle.Visible = False
     Me.pgOffset.Visible = False
     Me.pgProof.Visible = False
     Me.pgSecurity.Visible = False
     Me.pgStatic.Visible = False
     Me.pgTorque.Visible = False
     
         
     Me.pgIResults.Visible = True
     
     Me.pgHResults.Visible = False
     Me.pgOResults.Visible = False
     Me.pgPResults.Visible = False
     Me.pgSecResults.Visible = False
     Me.pgStResults.Visible = False
     Me.pgTResults.Visible = False

   End If

I am just totally lost here. Any help would be appreciated!

Thank You!
~Erica~
Joao - 30 May 2008 17:41 GMT
Hello Eka, i am no guru but
In 1.) those objects are in frmQueueID? And at 2.) that form is where
txtType is located?
It seems you're closing the forms and trying to apply a setfocus... you
can't do that.

> Hello,
>
[quoted text clipped - 81 lines]
> Thank You!
> ~Erica~
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.