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 / Queries / July 2006

Tip: Looking for answers? Try searching our database.

'Enter Parameter Value'

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Olu Solaru - 27 Jul 2006 17:17 GMT
Does anybody have a permanent fix for the 'enter parameter value" dialog box
that pops up after closing my query dialog form.
I have gone back and looked at my query, the record source of my combo box.  
I even used some code that will set the recordsource value of the combo box
to null, just before the DCmd.Close command.  I just can't get this thing to
stop.
I also tried the suggestions on microsoft's website.  Been working on this
for a week, and it's starting to become a pain to solve.

Scenario - Select a report from my reports menu, Custom Query Dialog form
appears: {combo box, two command buttons( Open/Close)
Problem happens when I click on the close button.

Record source of combo box. - SELECT tblSopNumbers.ControlNumber FROM
tblSopNumbers;

SQL Code for query that report is based on -

SELECT tblTraining.EmployeeID, tblSopNumbers.ControlNumber,
tblTraining.Training_Validation, tblTraining.TrainingDate
FROM tblTraining INNER JOIN tblSopNumbers ON tblTraining.ControlNumber =
tblSopNumbers.ControlNumber
WHERE (((tblSopNumbers.ControlNumber)=[Forms]![frmTraining Summary By
SOP]![cboSop]) AND ((tblTraining.Training_Validation)='Yes'));
Jeff Boyce - 27 Jul 2006 18:26 GMT
I ran into a similar (?the same) problem in an earlier version of Access.
The prompt was a bug somehow related to having Maximized the form when it
opened.  By adding a DoCmd.Restore into the  OnClose event procedure, it
bypassed the bug.

Regards (and Good Luck!)

Jeff Boyce
Microsoft Office/Access MVP

> Does anybody have a permanent fix for the 'enter parameter value" dialog
> box
[quoted text clipped - 24 lines]
> WHERE (((tblSopNumbers.ControlNumber)=[Forms]![frmTraining Summary By
> SOP]![cboSop]) AND ((tblTraining.Training_Validation)='Yes'));
John Spencer - 27 Jul 2006 18:41 GMT
You can't close the form until you close the report.  You can set the form's
visible property to No.  And in the close event of the report, close the
form.

The query the report is based on uses the values of the controls on the
form.  When you close the form, the controls are no longer available.

> Does anybody have a permanent fix for the 'enter parameter value" dialog
> box
[quoted text clipped - 24 lines]
> WHERE (((tblSopNumbers.ControlNumber)=[Forms]![frmTraining Summary By
> SOP]![cboSop]) AND ((tblTraining.Training_Validation)='Yes'));
Olu Solaru - 27 Jul 2006 19:23 GMT
Where do I set the form's visible property to No - Is it in the Report's
close event ?

> You can't close the form until you close the report.  You can set the form's
> visible property to No.  And in the close event of the report, close the
[quoted text clipped - 31 lines]
> > WHERE (((tblSopNumbers.ControlNumber)=[Forms]![frmTraining Summary By
> > SOP]![cboSop]) AND ((tblTraining.Training_Validation)='Yes'));
John Spencer - 28 Jul 2006 12:44 GMT
No, in the report's close event is where you would close the form.
What event are you currently using to close the form?  Instead of closing
the form in that event, set the form's visible property to false.

Do you have a button on the form to close the form?  If so, change the code
in the button so it doesn't close the form, but sets the form's visible
property to false.

Forms!YourFormName.Visible = False

> Where do I set the form's visible property to No - Is it in the Report's
> close event ?
[quoted text clipped - 40 lines]
>> > WHERE (((tblSopNumbers.ControlNumber)=[Forms]![frmTraining Summary By
>> > SOP]![cboSop]) AND ((tblTraining.Training_Validation)='Yes'));
 
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.