423,688 Members | 1,894 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,688 IT Pros & Developers. It's quick & easy.

display data and query side by side

P: n/a
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

Oct 10 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
<zw****@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
Oct 10 '06 #2

P: n/a
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 ***
Oct 10 '06 #3

P: n/a
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

Oct 10 '06 #4

P: n/a
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

Oct 10 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.