Query sys tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I query system tables to get a list of which forms and reports in a
certain db contain a specific column/field name? Thanks.
 
You can't query the system tables for this information. In the system table
MSysObjects, you can find the names of all the forms and reports, but not
what fields are used. To do this, you'll have to use code.

Tell me, why do you want to do this? If it's just to find out which forms
and reports are affected by field changes, you should look into a product
called "Find and Replace" by Rick Fisher
(http://www.rickworld.com/download.html). It's shareware, but you get extra
features for the ridiculously low registration fee.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sys table Query to Obtain List of Queries used in Reports 8
Special characters 3
How to create a report based on used selected query 4
Data Mismatch in Excel 2010 4
Growable Text Box in Report 2
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Macro Results, How to filter? 1
system tables 4

Back
Top