Printing code 1

[Dilettant]

I am using VBA under Access and trying to print code to file by checking "Print To File" checkbox. It seems to work but I can't open the file. What file type is it and what program can open it?

Thanks

 

[belovedcej]

Printing to file will create something that can only be opened by DOS or something like that. I just print it out hardcopy. If you have something like the Adobe PDF Distiller, you can print to pdf, then select text and copy it into Word. Convoluted, but it works.

 

[ZmrAbdulla]

Why not "Export File" ? You can then choose "All Files" from the Dialog and change the extension to "txt". You will be able to open with notepad.

Here is a routine to dump your objects as txt file

http://www.utteraccess.com/forums/showflat.php?Cat=&Number=776803&Main=776452

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[Dilettant]

Thank you for an elegant solution to an unnecessary problem. I used the routine to dump all code successfully.

I find it hard to believe that a company like Microsoft with sophisticated and complex products like Access, containing a print utility with a "print to file" option prints to a totally useless file. Even printing hard copy you can't set margins and it practically prints off the page. It would have been so simple to make it a .txt or .doc file. Does the Vista version of Access have this problem? Does anyone at Microsoft read these posts?

Once again, thank you

 

[ZmrAbdulla]

I think the print to file is for "Microsoft Document Printer". Not sure though..

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.