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
|
|||
|
|||
Access 2007, Query's prompts parameter twice
For some reason my query's ask for a parameter twice when run. I then copy
the code into a new query, delete the old query and rename the new query to the old name and everything works. It seems regularly this will happen and I have to redo all that are affected? This access 2007 install has the latest patch from MS. Am I doing something wrong here or is this documented somewhere so I can fix |
#2
|
|||
|
|||
Access 2007, Query's prompts parameter twice
Usually this happens when you have applied (and saved) a sort while in
datasheet view of the query. Try this ==Open the query in datasheet view ==Click on Remove Filter/Sort (Could be on the right-click menu) ==Close the query and when prompted to save the changes to the query design respond yes. John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County codeSlave wrote: For some reason my query's ask for a parameter twice when run. I then copy the code into a new query, delete the old query and rename the new query to the old name and everything works. It seems regularly this will happen and I have to redo all that are affected? This access 2007 install has the latest patch from MS. Am I doing something wrong here or is this documented somewhere so I can fix |
#3
|
|||
|
|||
Access 2007, Query's prompts parameter twice
John, thanks again, did not realize this.
"John Spencer" wrote: Usually this happens when you have applied (and saved) a sort while in datasheet view of the query. Try this ==Open the query in datasheet view ==Click on Remove Filter/Sort (Could be on the right-click menu) ==Close the query and when prompted to save the changes to the query design respond yes. John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County codeSlave wrote: For some reason my query's ask for a parameter twice when run. I then copy the code into a new query, delete the old query and rename the new query to the old name and everything works. It seems regularly this will happen and I have to redo all that are affected? This access 2007 install has the latest patch from MS. Am I doing something wrong here or is this documented somewhere so I can fix . |
Thread Tools | |
Display Modes | |
|
|