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

Looping through every oject for Application.SaveAsText

P: n/a
Wondering if anyone has already written a snippet that will loop
through every form, report, module in an ADP application and do
application.SaveAsText on each item.

Nov 13 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
Arvin Meyer has a snippet at http://www.datastrat.com/Code/DocDatabase.txt

I can't guarantee it'll work on an ADP, though, as I've never tried it.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"lauren quantrell" <la*************@hotmail.com> wrote in message
news:11*********************@g14g2000cwa.googlegro ups.com...
Wondering if anyone has already written a snippet that will loop
through every form, report, module in an ADP application and do
application.SaveAsText on each item.

Nov 13 '05 #2

P: n/a
Yes.

Nov 13 '05 #3

P: n/a

"lylefair" <ly******@yahoo.ca> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
Yes.


A much better answer than Arvin's Web site--and no plagiarism!
Nov 13 '05 #4

P: n/a
That link doesn't seem to work.
lq

Nov 13 '05 #5

P: n/a
lauren quantrell wrote in message
<11**********************@g43g2000cwa.googlegroups .com> :
That link doesn't seem to work.
lq


The contents of the link didn't work, or the link?

For the content, I'm not sure it'll work in an ADP. I don't think
CurrentDB is
a member of the Application object of an ADP. You could perhaps loop
the
following collections of the currentproject object instead

AllForms, AllReports, AllMacros, AllModules

Air code

for each vObj in currentproject.allforms
application.saveastext acform, vObj.name, "D:\Document\" &
vObj.name & ".txt"
next vObj

I believe views/SPs are stored on the server, so you probably won't be
able to
get at them

--
Roy-Vidar

Nov 13 '05 #6

P: n/a
There is some code in
http://www.ffdba.com/downloads/downloads.zip
that !!!!may!!!!
do what you describe,
(together with other things).

Nov 13 '05 #7

P: n/a
Thanks for the code. I'll try it. The link that was posted is down.

Nov 13 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.