Sorry Folks, I have worked out what I did. In my main switchboard form I establish links to my tables on opening the form and before exiting the system I delete these same links. I have done this to prevent "fiddlers" getting into the data. And in doing so I "shot myself in the foot" so to speak. I discovered the object dependencies facility and without backing up my applications database first I went ahead and ran it. It told me it was closing all objects in the database and I went ahead with this not realising the implications. For the objects whose sources are tables, ofcourse I got errors and in queries the field names became preceded with Expr1:, Expr2: etc. Need I say more !!!!! I am feeling very stupid, but I hope others can learn from this and backup. I am usually a stickler for backing up. Never mind. Thank you everybody for all the great work you do, Ilona Adelaide, Australia
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Ilona Wright Sent: Wednesday, 13 September 2006 1:53 PM To: [email protected] Subject: RE: [ms_access] Re: Expr?s appearing in Queries Hi Guys, I am suddenly finding that my query fields have all turned into Expressions. I am using ACCESS 2003. I turned on all the options under Name Auto Correct so that I could use the marvelous "Dependencies" information. Is this what has caused my problem? Is there any way I can automatically get rid of all these expressions? I am in panic mode. Please help Ilona Adelaide, Australia [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/ms_access/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
