Query prompts for Query1.field name? 1

[Lost500]

I will create a query and it runs fine, but when I save the query and close it and try to run it at a later time it prompts me for Query1.(any field name in my query) kinda like when i built the query before i saved it, it's name was technically query1 and when i save it with a real name the query remembers that is was originally called query1 so it asks for those fields??? do i need to save the query with it's name before i start building it? any help would be great!

 

[dhookom]

Consider looking at the SQL view as well as the query properties. You might have a saved sort order or something.

If you can't find the issue, you can copy the SQL view to the clipboard then create a new, blank query and paste the SQL. Use the new query in place of your old one.

Duane
Hook'D on Access
MS Access MVP

 

[Lost500]

Thanks dhookom I've tried copying the code to a blank query before and it works for a while until the same problem starts again so i think its something in the default properties or something so that whenever i create a query it automatically does this.

 

[dhookom]

Do you have any Nameautocorrect boxes checked in your Tools->Options dialog?

You don't use lookup fields do you?

Duane
Hook'D on Access
MS Access MVP

 

[Lost500]

Thanks dhookom I found that in the query properties the 'order by' property was referencing field names as query1.fieldname! does anyone know why its doing this? If I can fix this it would be great thanks in advance!

 

[dhookom]

I don't care for the feature that allows you to save sorting and filter information on queries. If it isn't part of the SQL statement, I don't want it saved.

Can't you just delete the property value and save the query? Or, right-click and choose "remove filter/sort".

Duane
Hook'D on Access
MS Access MVP