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
|
|||
|
|||
Query keeps looking for Query1 field
Okay... so I have this bad habit of saving queries as Query1, Query2, etc if
I have not completed them and I get interrupted. It helps me get back to the incomplete work faster/easier. I have a DB that began as an Access 2007 DB (.accdb) and was converted down to an Access 2003 DB (.mdb). Since then, these queries that began their life as Query1, Query2... keep asking for fields from their old query name. I have looked in the SQL, the Parameters, etc but can find no reference to the old query name. One solution is to copy and paste the SQL into an empty query and save it with the new name (again). What is causing this problem? Where is this phantom Query1 information being stored? Is it because of the backwards conversion? Thank you, |
#2
|
|||
|
|||
Query keeps looking for Query1 field
Make sure there's nothing in the query's Filter or OrderBy properties.
Also check that Name AutoCorrect is turned off. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Cathy" wrote in message ... Okay... so I have this bad habit of saving queries as Query1, Query2, etc if I have not completed them and I get interrupted. It helps me get back to the incomplete work faster/easier. I have a DB that began as an Access 2007 DB (.accdb) and was converted down to an Access 2003 DB (.mdb). Since then, these queries that began their life as Query1, Query2... keep asking for fields from their old query name. I have looked in the SQL, the Parameters, etc but can find no reference to the old query name. One solution is to copy and paste the SQL into an empty query and save it with the new name (again). What is causing this problem? Where is this phantom Query1 information being stored? Is it because of the backwards conversion? Thank you, |
#3
|
|||
|
|||
Query keeps looking for Query1 field
Whenever you delete an object in Access, it actually stays in the database
until you do a compact/repair. You have provided your own solution. Recreate the queries in a fresh query, delete the originals and then do compact/repair. If this does not eliminate the problem, create a brand new empty dayabase and import all your desired objects into it. -- Dorian. "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". "Cathy" wrote: Okay... so I have this bad habit of saving queries as Query1, Query2, etc if I have not completed them and I get interrupted. It helps me get back to the incomplete work faster/easier. I have a DB that began as an Access 2007 DB (.accdb) and was converted down to an Access 2003 DB (.mdb). Since then, these queries that began their life as Query1, Query2... keep asking for fields from their old query name. I have looked in the SQL, the Parameters, etc but can find no reference to the old query name. One solution is to copy and paste the SQL into an empty query and save it with the new name (again). What is causing this problem? Where is this phantom Query1 information being stored? Is it because of the backwards conversion? Thank you, |
#4
|
|||
|
|||
Query keeps looking for Query1 field
The autocorrect was the issue. Thank you!
"Allen Browne" wrote: Make sure there's nothing in the query's Filter or OrderBy properties. Also check that Name AutoCorrect is turned off. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Cathy" wrote in message ... Okay... so I have this bad habit of saving queries as Query1, Query2, etc if I have not completed them and I get interrupted. It helps me get back to the incomplete work faster/easier. I have a DB that began as an Access 2007 DB (.accdb) and was converted down to an Access 2003 DB (.mdb). Since then, these queries that began their life as Query1, Query2... keep asking for fields from their old query name. I have looked in the SQL, the Parameters, etc but can find no reference to the old query name. One solution is to copy and paste the SQL into an empty query and save it with the new name (again). What is causing this problem? Where is this phantom Query1 information being stored? Is it because of the backwards conversion? Thank you, . |
Thread Tools | |
Display Modes | |
|
|