Is there a way to default Query Design to SQL View?

blackduck603

Registered User.
Local time
Today, 14:24
Joined
Dec 27, 2007
Messages
16
I am running Access 2000.
I was wondering if anyone knows if there is a way to open querys in SQL View when the Design button is clicked. I edit my querys in SQL View 90% of the time and find it cumbersome to have to change views from the UI designer to SQL every time.

Thanks
 
I am running Access 2000.
I was wondering if anyone knows if there is a way to open querys in SQL View when the Design button is clicked. I edit my querys in SQL View 90% of the time and find it cumbersome to have to change views from the UI designer to SQL every time.

Thanks

Not sure about Access 2000, but in Access 2003, the Design appears to default to the last one that I saved it as. I usually use SQL view as well, but I never considered it difficult to switch when necessary
 

Users who are viewing this thread

Back
Top Bottom