a Query that collected parameters from a form just stopped working

W

WebDude

My parameter query was working perfectly.. it collected values from a row of
text boxes on a form...but now its acting as if it doesnt see the
form/parameters by asking me for the paramaters over and over again? What
happaned?

Cheers,
WebDude

ps: Ms Access 2000
 
W

WebDude

Hi John,
Thanks for taking the time to reply!


:)


The form (with the text boxes that the query retreives its parameters from)
is a dialog window infact... and it never closes.. i actually run the query
with the form/dialog window open. Also, i checked to make sure the query
parameters have the proper path/name to the forms textboxes and those seem
fine....


-------------------------------------------
Form Name:
"VolunteerSearchForm"

Query Name:
"Volunteers_SearchQuery"

Query Parameters:
[Forms]![VolunteerSearchForm]![IDTextBox]
[Forms]![VolunteerSearchForm]![FirstNameTextBox]
[Forms]![VolunteerSearchForm]![EMailTextBox]
[Forms]![VolunteerSearchForm]![TelephoneTextBox]
-----------------------------------------------



Coincidentally, I recently added a button to the form ("VolunteerSearchForm")
which should hide the form..




----------------CODE-------------------
Private Sub HideButton_Click()
Me.Visible = False
End Sub
------------------------------------------



....but when i click the button, the following error pops up;




-------------------------ERROR-----------------------------------
The expression On Click you entered as the event property
setting produced the following error: A problem occurred
while Microsoft Access was communicating with the OLE
server or ActiveX Control.

*The Expression may not result in the name of a macro,
the name of a user-defined function, or [Event procedure]

*there may have been an error evaluating the function,
event or macro.
----------------------------------------------------------------------





So im guessing the original problem i had with the parameter query is just a
symptom of a bigger problem which is also effecting the button i just added
to the form. However, every other form works perfectly, including the other
parameter/form based queries i created weeks earlier.

Any ideas whats going on??


Cheers!
WebDude :)
 
W

WebDude

Well, after reading thru the newsgroups, i thought that maybe my database was
corrupt.. so i created a new database then imported everything from the
corrupted one. This new one seems to work fine now.

:)

WebDude Out!


WebDude said:
Hi John,
Thanks for taking the time to reply!


:)


The form (with the text boxes that the query retreives its parameters from)
is a dialog window infact... and it never closes.. i actually run the query
with the form/dialog window open. Also, i checked to make sure the query
parameters have the proper path/name to the forms textboxes and those seem
fine....


-------------------------------------------
Form Name:
"VolunteerSearchForm"

Query Name:
"Volunteers_SearchQuery"

Query Parameters:
[Forms]![VolunteerSearchForm]![IDTextBox]
[Forms]![VolunteerSearchForm]![FirstNameTextBox]
[Forms]![VolunteerSearchForm]![EMailTextBox]
[Forms]![VolunteerSearchForm]![TelephoneTextBox]
-----------------------------------------------



Coincidentally, I recently added a button to the form ("VolunteerSearchForm")
which should hide the form..




----------------CODE-------------------
Private Sub HideButton_Click()
Me.Visible = False
End Sub
------------------------------------------



...but when i click the button, the following error pops up;




-------------------------ERROR-----------------------------------
The expression On Click you entered as the event property
setting produced the following error: A problem occurred
while Microsoft Access was communicating with the OLE
server or ActiveX Control.

*The Expression may not result in the name of a macro,
the name of a user-defined function, or [Event procedure]

*there may have been an error evaluating the function,
event or macro.
----------------------------------------------------------------------





So im guessing the original problem i had with the parameter query is just a
symptom of a bigger problem which is also effecting the button i just added
to the form. However, every other form works perfectly, including the other
parameter/form based queries i created weeks earlier.

Any ideas whats going on??


Cheers!
WebDude :)









JohnFol said:
either the form is not open, or the form name has changed . . .
Click to expand...
Click to expand...
 
Top