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 / Forms / July 2007

Tip: Looking for answers? Try searching our database.

Lost Focus of Form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jehmsit - 27 Jul 2007 14:24 GMT
I've inherited someone elses work and I'm new at this.   Most recently in an
attempt to consolodate things, I've combined 9 different (small) pop-up forms
into one using a single Tab form (dragged and dropped forms into each tab).  
8 forms input into their respective tables (7 work fine) (1 complains about
"Index or primary key cannot contain a null value) but I'll try to figure
that one out.

The 9th form or shall I say sub-forms now returns an employee record
(selected by name and social) from the archive.  When I click the [Return to
Active] button, I get a prompt box titled "Enter Parameter Value" for
Forms.Archive.track.
Can anyone help?  The On Click even procedure code is as follows:

Private Sub Return_to_Active_Click()
On Error GoTo Err_Return_to_Active_Click

   Dim stDocName As String

   stDocName = "Employee Data Table Archive Retrieval Query"
   DoCmd.OpenQuery stDocName, acNormal, acEdit

   stDocName = "Polygraph Data Archive Retrieval Query"
   DoCmd.OpenQuery stDocName, acNormal, acEdit
   
   stDocName = "Poly Archive Delete Query"
   DoCmd.OpenQuery stDocName, acNormal, acEdit

   DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
   DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70

Exit_Return_to_Active_Click:
   Exit Sub

Err_Return_to_Active_Click:
   MsgBox Err.Description
   Resume Exit_Return_to_Active_Click
End Sub

Any assistance would be appreciated.
jehmsit - 27 Jul 2007 18:32 GMT
I've figured out and resolved my problem.  Moving the from into a new form
and onto a tab object changed the location of something ref in one of the
columns in the Criteria field of the query.  I used the builder to locate and
reestablish this ref.

> I've inherited someone elses work and I'm new at this.   Most recently in an
> attempt to consolodate things, I've combined 9 different (small) pop-up forms
[quoted text clipped - 35 lines]
>
> Any assistance would be appreciated.
 
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.