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?

Thanks,

Wei

<zwasdl@gmail.comwrote

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 is certainly possible if you create a Form, and use a Subform Control to
contain another Form showing the results. You can't rearrange the Query
Builder window as you describe.

I don't recall seeing a side-by-side arrangement in "other DB software." If
you are trying to embarrass someone here into an answer, that is not a good
technique. If you want to describe something you are trying to duplicate,
you should say _what_ other DB software is involved.

Larry Linson
Microsoft Access MVP

The only way to do that in Access is to create to separate queries with
the same sql. Run one query and view the sql from the other query.

Rich

*** Sent via Developersdex http://www.developersdex.com ***

Larry,
As for the side-by-side arrangement (as in SQL editor in
SQL/Navigator or TOAD), I mean the query window in MS Access itself
without creating any forms or reports.
I wasn't trying to embarrass anyone. just asking for some potential
options in access which I don't know of.

Wei

zwasdl@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