VB to Open a Query in an Evcent Proceedure

Posted on 2005-03-31
Medium Priority
Last Modified: 2012-06-27
I need to open an query in table form from an event proceedure on a form.  The query needs to be in the table form as if opened by double clicking the query name in the db window.
Question by:SuperSnooper
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 41

Accepted Solution

shanesuebsahakarn earned 500 total points
ID: 13678381
DoCmd.OpenQuery "MyQueryName"
LVL 15

Expert Comment

by:Simon Ball
ID: 13678956
as shane says above.. but tere are lots of other options you can tie in at the end... the mode the table opens in, and the edit mode for the data....

you want the user to see a table but not edit its data?:

DoCmd.OpenQuery "myname", acViewNormal, acReadOnly

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question