How do you print an embeded macro?

[chuckcoleman]

I have a form that has a command button which executes a rather lengthy embeded macro. Does anyone know how to write a report so I can keep a printed copy of the macro? I DO NOT want to use the built-in Database Documentor; the report isn't formatted the way I want? I would be happy to modify the Database Documentor report if I can find a way.

Thanks!

Chuck

 

[boblarson]

Which version of Access are you using?

 

[chuckcoleman]

Access 2010

 

[boblarson]

Access 2010

Don't know if this will help but you can export Access 2010 macros to XML.

 

[chuckcoleman]

Do you know how to modify the "canned" Database Tools reports?

Chuck

 

[boblarson]

Do you know how to modify the "canned" Database Tools reports?

Chuck

There is no way of which I am aware.

 

[chuckcoleman]

How do third-party companies write Access documentation programs? What information/tables do they access?

 

[boblarson]

How do third-party companies write Access documentation programs? What information/tables do they access?

It's all done with a LOT of code.

You can get a feel for what it takes by looking at my Database Merge Analysis Tool (located at the bottom of this page:
http://www.btabdevelopment.com/ts/freetools

And I didn't even get the macros part working yet.

 

[chuckcoleman]

Thanks Bob, I'll take a look at it. If anyone else has any ideas, I would appreciate your thoughts.

Chuck

 

[chuckcoleman]

Pat, thank you very much. I'll take a hard look at this to see if I can modify it. When you said it "loops through the fields collection of the tabledefs collection", I'm not familiar with what is stored in tabledefs. It looks like it's looks in a control on a form called frmPrintDoc. I have a form that has a command button on it and in the On Click event, it runs an embeded macro. Will your code be able to pick out the key elements of the macro and then stick them into a new table? If so, I could then write a report to extract the information I'm looking for. Does this make sense?

 

[AtLarge]

Don't know if this will help but you can export Access 2010 macros to XML.

Can you put together a brief process for this? I'd like to be able to print some of my lengthy macros too. I would settle for an .xml version depending on what it looks like. I don't see a way to do this? :banghead:

 

[boblarson]

Can you put together a brief process for this? I'd like to be able to print some of my lengthy macros too. I would settle for an .xml version depending on what it looks like. I don't see a way to do this? :banghead:

I do know how to do it manually (I had to double check it at home though) and that is to open them in design view and then use Ctrl+A to select it all and then Ctrl+C to copy and then you can paste it into Notepad, Word, whatever.