Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

access keeps changing query field names?!

Status
Not open for further replies.

danwand

Programmer
Jun 8, 2003
100
GB
Hi all,
I don't know what is causing this specific problem, perhaps someone could help.
To explain in as simple way as possible, i have a number of queries that use other predefined query fields. I use a versioning system as a means of DB developement, i.e. each time i make a number of significant changes to the DB i then export all objects into a new DB, however each time i do this some of the query field names are changed by access from their original name (so orig referenced query field would be 'Topic', when i import and then look at the query design this would be changed to 'Expr1: Topic') thus the field names on my reports or datasheets will have these ambigious headings: expr1:, expr2:

Does anyone know why this is happening?

Thanks Dan
 
Sounds like maybe you're getting bit by Name AutoCorrect. Go to Tool->Options->General tab and turn off the Name AutoCorrect stuff; see if that helps at all.

Ken S.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top