Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Query using Mysysqueries and/or Mysysobjects

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Query using Mysysqueries and/or Mysysobjects

Resolved · Medium Priority · Version 2003

Reply Fri 14 Oct 2011, 16:58Delegate Jamie said...

Jamie has attended:
Access Intermediate course
Access Advanced course
Access VBA course

Query using Mysysqueries and/or Mysysobjects

What query statement using Mysysqueries and/or Mysysobjects could be used to list all action queries in a database together with their type ('append', 'update', etc.) and the main table(s) on which the action is carried out?
- Thanks

For upcoming training course dates see: Pricing & availability

Reply Tue 18 Oct 2011, 07:17Trainer Anthony said...

RE: Query using Mysysqueries and/or Mysysobjects

Hi Jamie, thanks for your query. Some information about using the MSysObjects table can be found here:

http://www.perfectparadigm.com/tip001.html

...but personally I would write a quick subroutine to loop through the querydefs, pull out the required info and then write to a table or text file. It all depends on the situation, however!

Hope this helps,

Anthony

Mon 24 Oct 2011: Automatically marked as resolved.

Access articles

· Material covered on a Microsoft Access Course
· What Is The Database Documenter And How Is It Used?
· So You Want To Create Forms In Access 2007?
· Find Out About The Join Property In An Access Query
· How To Sort And Filter A Table In Access 2010

Please browse our web site to find out more about
access courses and other Microsoft training courses.

Access tip:

Open A Combo Box Automatically

This is helpful if users need to enter large amounts of data. There are two ways to open ComboBoxes when they get the focus by using the tab keys.

When the ComboBox gets focus:

Press Alt + Down Arrow on the keyboard

For it to happen automatically, needs a bit of coding:

1. Add a combo box and a text box control to the form
2. Set the combo box's On Got Focus property to the following event procedure:

Private Sub ComboBoxName _GotFocus()

Me!ComboBoxName.Dropdown

End Sub

3. Open your form in Form View and use the TAB key to make sure it works.

View all Access hints and tips