I had a quick question:
When I click on the design mode of a query object, generally MS Access defaults to the GUI design view... but in this one application, the design view is pulling up queries in SQL mode first...
If I want to set it to the GUI design mode, I have to either hit design again or run the query then hit design to have it pull up in the regular design mode.
Is there a setting or something I am missing? Seems that it only does this when the SQL code is reltively involved (i.e. the simpler queries pull up in the normal design view.
Thanks,
-G
When I click on the design mode of a query object, generally MS Access defaults to the GUI design view... but in this one application, the design view is pulling up queries in SQL mode first...
If I want to set it to the GUI design mode, I have to either hit design again or run the query then hit design to have it pull up in the regular design mode.
Is there a setting or something I am missing? Seems that it only does this when the SQL code is reltively involved (i.e. the simpler queries pull up in the normal design view.
Thanks,
-G