zw****@gmail.com wrote:
Is it possible to view access query (design view or sql view) and its
query results in the same window (for example, arrange them side by
side) as other DB software do?
It's not built in, and I remember other DB tools placing these windows top
and bottom, but you can put them both side by side in Access. Create your
query then go to SQL View. Create a new query and copy the SQL from the
first query to the second query. Minimize the other windows and go to Window
| Tile Vertically to get the queries side by side. Open the second query in
datasheet view. If you need to make changes, go back to SQL View and change
it, then copy the SQL to the first query. Open the second query in datasheet
view again.
You can write code that will automate this for you and then use a custom
button on a toolbar to run the code every time you want to run the query so
you can see the SQL and results side by side.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200610/1