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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |