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

queries opening on top of call form

P: 5
As a user of access 2003 for many years I am testing out access 2013. In access 2003 , when opening a query from a forms command button the query appears on top of the form for easy reading. In Access 2013 the query opens under the calling form and to read it I have to minimise the form and then restore. My users would find that too difficult. I would prefer not to have to create a form or report as there are many queries in my current database. As said earlier it worked fine in Access 2003 so what different ? and is there a way round it?
Jan 29 '15 #1
Share this Question
Share on Google+
4 Replies


twinnyfo
Expert Mod 2.5K+
P: 3,482
Is your form in Modal/Pop-up mode? this would place it on top of the resulting query.

I know there are all sorts of preferences out there for display of information, but I have always been one who is hesitant to display a raw query, as it can open the door to people intentionally or inadvertently making changes to those queries. However, some prefer to allow that view, which is neither right nor wrong, just different.

:-)
Jan 29 '15 #2

P: 5
Twinnyfo Thank you for replying to my question, yes the call form is a popup but not modal. I made it a non-popup and you are correct the query was placed on top. These queries are management non updatable queries. So thanks again for your input it gives me and option, I do like the Popup as the form looks good as appose to filling the whole screen. .
Jan 30 '15 #3

jforbes
Expert 100+
P: 1,107
Being new to Access 2013, you may want to look at the Tabbed Documents verses Overlapping Windows option. It's an option that is available to you now that sounds like you will probably not use, but it seems worth mentioning.

It's located at File|Options|Current Database| Document Window Options
Jan 30 '15 #4

P: 5
jforbes Thank you. It solved my worry about forms looking good.
I don,t know the pro and cons of using the Tabbed Document verses Overlapping windows which was the default. I now will now to try and understand' "My Access 2013 the missing manual" arrives tomorrow.

Regards Ypma
Jan 30 '15 #5

Post your reply

Sign in to post your reply or Sign up for a free account.