By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,430 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 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?

thanks,
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?

thanks,
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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

for each frm in currentproject.allforms : debug.Print frm.name : 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 **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBR6t4QIechKqOuFEgEQJ4WwCdGzBOLT74M/OTYVBya1ZMCY3E6YUAoPM/
ZWMeWiO6kqRmzGE6bF9wiHn7
=Vh++
-----END PGP SIGNATURE-----
Feb 7 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.