98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Query using Mysysqueries and/or Mysysobjects | Access forum
Query using Mysysqueries and/or Mysysobjects | Access forum
Resolved · Medium Priority · Version 2003
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
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.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Hiding Multiple Table columnsIf you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide. |
