• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 235
  • Last Modified:

Access Reformatting Queries

Is there a way to prevent Access from reformatting a query?  I manually build queries in Access 2002 but when I go back to review the queries, Access has reformatted them.  I've tried to find a way to prevent Access from doing this, but haven't found a way yet.
0
BKaporch
Asked:
BKaporch
  • 2
1 Solution
 
jadedataMS Access Systems CreatorCommented:
Hey BKaporch!

  Keep the query in SQL view.  Each time you switch to Designer View the SQL is rewritten to Access's liking.
  As to how to keep Access from reformatting the Designer window,... give it up.  That window is a Wizard windows and it works the way it works.  

regards
Jack
0
 
ornicarCommented:
----------------------------------------------------------------------------------------
This question has been abandoned and needs to be finalized.
 You can accept an answer, split the points, or get a refund (information at http:/help.jsp#hs5)
  If you need a moderator to help you, post a question at Community Support (http:/Community_Support/)

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

ornicar
Cleanup Volunteer

---------------------------------------------------------------------------------------------
0
 
jadedataMS Access Systems CreatorCommented:
The questioner asked for a way to have Access NOT reformat his sql,  I gave him the answer.
0
 
stevbeCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

Accept: jadedata {http:#9765607}

Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

stevbe
EE Cleanup Volunteer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now