How do I open an Access 2003 query directly in SQL View?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Default is to open query in same view as last access. This happens to be
Design view in my case. I need to open directly into SQL view to make changes
before opening it in Design view.
 
Dear Rowewa:

It will sometimes open in the same view as previously, other times I think
I've seen it open in Design View after last being SQL View. As I do almost
all my work in SQL View, I agree it would be a good thing to be able to just
go to the SQL View. I don't know of any way that makes it happen all the
time.

Tom Ellison
 
If you are having problems, copy the sql to a text editor, then
replace it.

s = codedb.querydefs("myquery").sql
debug.print s
' or write the sql to a file or to a record
s = replace(s,"oldfield","newfield")
codedb.querydefs("myquery")sql = s

(david)
 
rowewa said:
Default is to open query in same view as last access. This happens to be
Design view in my case. I need to open directly into SQL view to make changes
before opening it in Design view.
Click to expand...

Opening the Query in Design Mode will revert to last (Design Mode) saved
state.
Always change to SQL view and "Save" before closing.
 
Back
Top