Software

Ask something
Discussion Locked

Form Modification

0 helpful
7 replies

by djpinson

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I've created a form in Access 97 and would like the users to click on a button to run a query.

How can I allow my users to go directly to the Access Query screen (Tab)?

7 replies

by sankulpune

Hello,

1) If you close the database while you are on the query tab, the next time you open the database you will be in the query tab. I don't think this is what you want because it can not be programmatically ensured.
2) You probably can not, asfar as I understand, run a predefined query using a button. (Tables and queries are not VBA objects). You may, however, create a 'querydef' object using VBA & SQL in the click event of a button and run it.

Your feedback will be highly appreciated.

With regards,

SanganakSakha,
Simple And Effective Solutions To Small Problems, No QuickFixes.

by shmaltz

I dont know what you want, but from what you describe I understand that you want them just to switch the focus to the query tab and the answer I gave you works.
If you want a query to get the focus then enter the query name in the queryname argument if you dont want a query name just the tab then dont give any name and it will work.
If I did not understand your question correctly then give more info and reason why you are rejecting my answer.

This discussion is closed to new replies.