473,396 Members | 2,003 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Access macro listing/catalog

Is there a way of producing a printout of an Access macro (or all macros in the database) using VBA, ideally one line per command for documentation purposes?

Many thanks for any help.
Apr 21 '09 #1
5 2119
NeoPa
32,556 Expert Mod 16PB
Have a look at the Documenter feature.

Tools / Analyse / Documenter

This should give you everything you need without needing to resort to programming anything.
Apr 21 '09 #2
Thanks, but when using that option, it produces a listing with approx. 4 entries per page, and not very readable at that.
Apr 21 '09 #3
NeoPa
32,556 Expert Mod 16PB
Can you attach an example. You can produce it in RTF for opening in Word, but either format will do to look at.

My recollection is that there are a whole bunch of options available. It may just be a case of choosing the right ones.
Apr 21 '09 #4
I've uploaded a .txt file, becauseof size restrictions here. I've also had to remove a lot of the spacing in between the entries. The entries represent one pageful which is produced - I only wanted the coding bits, i.e. commands, operands, parameters, etc.

I've found coding previously which allowed access to queries (QueryDef/qdf, etc.) so I'm hoping to find something similar for macros.
Attached Files
File Type: txt doc_rptObjects.txt (780 Bytes, 379 views)
Apr 24 '09 #5
NeoPa
32,556 Expert Mod 16PB
If the documenter is not good for you, then we should have a look at what's available in code.

CodeProject.AllMacros & CurrentProject.AllMacros both give access to the name and certain basic properties. Neither seems to have the attributes you would require (the design of the macro itself). If I find anything else I'll post.
Apr 24 '09 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Pete | last post by:
In Access 95/97 I used to be able to create pull down menus (File,Edit ...) from a macro. It seems there used to be some wizard for that. However in Access 2000 it seems you have to build your...
0
by: ImraneA | last post by:
Hi there Have a database, where front-end interface allows user to select a ms access database. From there, standard tables are linked. Routine, that creates a spreadsheet, for each table a...
12
by: Art | last post by:
Hi everyone I was hoping someone might be able to help me with this. I'm just starting to try to work with MS Access tables through VB.net. In Access I can take an existing table and add a new...
3
by: Charlie | last post by:
I am fairly new to VB.NET and was wondering if anyone knew where to find a complete listing of the namespaces in VB.NET and MSDN Library. I would really like to see a listing or a "catalog" of...
3
by: sammyloo | last post by:
Hi all, I'm experiencing a problem using ASP.NET web services to access a different server with SQL Server 2000 database. And I get the error of the following Exception Details:...
6
by: BrianDP | last post by:
I have a table that has always been in my back-end of this application. The table is getting quite large, and, on top of that, we lose records out of this table. They just dissappear! No rhyme or...
0
by: Laurence | last post by:
Hi folks, I used the following CLP commands to access DB2/400 in AIX 5L/DB2 EE, and it works. CATALOG TCPIP NODE AS400 REMOTE 192.168.10.51 SERVER 446 SYSTEM PROD400 OSTYPE OS400 CATALOG...
1
by: HannibalLecher | last post by:
I have created a catalog in Publisher 2K, and used the mail merge to access the fields in my existing access 2000 database. The merge works, but only accesses one record at a time. It will print the...
4
by: Jeffrey Davis | last post by:
I'm hoping that someone here can give me some assistance with a database I'm trying to set up. My skills in Access are fairly basic, and I'm trying to skill up, but some of the stuff is a little...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.