A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

a Query that collected parameters from a form just stopped working



 
 
Thread Tools Display Modes
  #1  
Old September 13th, 2005, 08:45 AM
WebDude
external usenet poster
 
Posts: n/a
Default a Query that collected parameters from a form just stopped working

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


  #2  
Old September 13th, 2005, 09:54 AM
JohnFol
external usenet poster
 
Posts: n/a
Default

either the form is not open, or the form name has changed . . .

"WebDude" wrote in message
...
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




  #3  
Old September 13th, 2005, 10:31 PM
WebDude
external usenet poster
 
Posts: n/a
Default

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" wrote:

either the form is not open, or the form name has changed . . .

"WebDude" wrote in message
...
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


  #4  
Old September 14th, 2005, 06:37 AM
WebDude
external usenet poster
 
Posts: n/a
Default

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" wrote:

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" wrote:

either the form is not open, or the form name has changed . . .

"WebDude" wrote in message
...
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


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Query with parameters from a form Dimitris Nikolakakis General Discussion 5 May 12th, 2005 10:29 AM
Passing parameters from a form built on a crosstab query ihrigt General Discussion 0 April 25th, 2005 04:13 AM
Requerying a pop up form to display in the main form Jennifer P Using Forms 13 April 5th, 2005 06:59 PM
update queries and forms Mary Pode Database Design 16 February 2nd, 2005 05:25 PM
How to get a field on a form to reflect a certain record of a query? General Discussion 0 December 11th, 2004 12:56 AM


All times are GMT +1. The time now is 02:17 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.