By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,294 Members | 2,645 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,294 IT Pros & Developers. It's quick & easy.

How to get Access form names into an Excel file?

P: n/a
How can I get all of my MS Access form names into an Excel file?

Feb 7 '08 #1
Share this Question
Share on Google+
1 Reply

P: n/a
tomg wrote:
How can I get all of my MS Access form names into an Excel file?

Hash: SHA1

Use CurrentProject.Forms. E.g. in the debug window (Ctrl-G):

for each frm in currentproject.allforms : debug.Print : next

If you want this to run from Excel you'll have to open Access as an
Automated object. See GetObject and CreateObject in the Excel VBA help
file. Then add the Access object to the above references
(accObj.CurrentProject.Forms) and use the above code to insert the form
names in Excel cells.

The easiest way is to run the above code in Access debug window and cut
& paste the results into Excel.
MGFoster:::mgf00 <atearthlink <decimal-pointnet
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

Version: PGP for Personal Privacy 5.0
Charset: noconv

Feb 7 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.