Create Access Readme File

Question

I've created a program using the built in functions and events (no macros). How do I convert it all to VBA and pull it to save as a readme file? I know how to get to the editor but it's split up by forms and reports. I'm really hoping for a magic button that lists it all nicely so I can just copy and paste. Is this a thing?

Answer 1

This worked - sort of! It kept freezing on the same table and the program would time out. I'll keep trying! Thank you!

Answer 2

You can use the built in Database Documenter from the Analyze area of the Database Tools ribbon to output the code for all standard and custom class modules, and for all forms' and reports' class modules.

For standard and custom class modules, in the modules tab of the documenter dialogue Select All, and then select Options, and in the next dialogue select Code only from the available options.

For forms and reports in the forms and reports tabs Select All and then select Options, and in the next dialogue select only the Code option in the top part of the dialogue, and select Nothing in the lower part.

The documenter will output the code as a report in print preview.  Select Text File from the Data area of the Print Preview ribbon to output the results to a text file from which you can copy and paste any of the text in the usual way.  Note that the documenter will show some lines which are normally hidden when the code is viewed in the VBA editor.

Answer 3

Sorry, but what you want is unclear. You say you have no macros. But say you are using built in events. Events usually use VBA code.

What do you mean by a "readme" file? Generally a readme file is a separate file included with a program that has startup instructions. What do you want to list?

Please provide more details so we can help.