By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,994 Members | 2,036 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,994 IT Pros & Developers. It's quick & easy.

Resizing Access query result window

P: n/a
I have created a form that contains several different queries. The
queries are simply linked to a command buttons, so all the user has to
do is click on the desired query and the result set window appears.

My problem is that I would like all the query windows to popup in the
same size / shape as each other. Is there a way I can resize these
windows? Right now, they come up, but some are partly off the screen
so the user has to maximize, etc.

Thanks,
Eric

Oct 26 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a

"ec*****@hotmail.com" <Ac*************@gmail.comschreef in bericht news:11*********************@i42g2000cwa.googlegro ups.com...
>I have created a form that contains several different queries. The
queries are simply linked to a command buttons, so all the user has to
do is click on the desired query and the result set window appears.

My problem is that I would like all the query windows to popup in the
same size / shape as each other. Is there a way I can resize these
windows? Right now, they come up, but some are partly off the screen
so the user has to maximize, etc.

Thanks,
Eric
I guess your form does not 'contain' the query's but 'calls' the query's right ?
If you have Acc2k or later then you *can* have a form that contains the query's.

With Access 2000 and above one can use tables and queries just like that as the SourceObject in a Subform control .
It works great. Set columnwidth to -2 and all columns 'magically' will adjust themselves.
All query's are displayed the same 'size' e.g. in the subform control.

Arno R
Oct 26 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.