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

R

rowewa

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.
 
T

Tom Ellison

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
 
G

Guest

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)
 
C

ChriRobe

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.
 
Top