Copy form and paste to notepad

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

Guest

Is there a way to copy an Access Form and then paste it into Notepad so that
I can see the Form as VBA code?

Thanks,

Bill Morgan
 
Is there a way to copy an Access Form and then paste it into Notepad so that
I can see the Form as VBA code?

Thanks,

Bill Morgan
Click to expand...

Since the Form does not consist of VBA code, you cannot. A Form is
stored in Access' systems tables in an undocumented binary blob
object.

You can use the undocumented VBA Application.SaveAsText method to
write the form out to a (very verbose) text file; this is NOT VBA
code, though it will contain any VBA code that is in the Form's
Module. In the Immediate window try

Application.SaveAsText(acForm, "MyFormName", "E:\somepath\Filename")



John W. Vinson[MVP]
 
John. I had a vague memory of copying Access objects into Notepad as code -
thanks for the clarification ...
 
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

Notepad status bar missing even after Registry entry 1
PLEASE HELP: automate process to import tables from notepad to acc 9
Excel And Notepad 3
Getting Excel Range Data and Saving as a String 1
vba powerpoint pasting named shape in selected named slides 0
Copy and Paste Issues 2
Copy & Paste on Excel 4
Download File, Copy Text To Clipboard 4

Back
Top