Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » VBA

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

VBA

Resolved · Low Priority · Version 2003

Reply Fri 8 May 2009, 15:52Delegate Kate said...

Kate has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Access VBA course

VBA

is there an easy way of indexing the procedures

For upcoming training course dates see: Pricing & availability

Reply Mon 11 May 2009, 11:40Trainer Stephen said...

RE: VBA

Hi Kate

Thank you for your question.

Could you clarify are you looking for an effective naming convention for your procedures so you can easily locate them, or are you looking for a tool that will automatically list all the procedures in a project

Thanks

Stephen

Reply Mon 11 May 2009, 11:43Delegate Kate said...

RE: VBA

Hi Stephen,

A tool that will automatically list all of the procedures.

I managed to get the DB from the email that I sent so there is no need to keep the version that you copied - thanks.

With kind regards,
Kate

Reply Mon 18 May 2009, 14:31Trainer Stephen said...

RE: VBA

HI Kate

Thank you for your question and clarification

First, I apologise for the delay in getting back to you. I have been out of the office and your question took some research.

I have been unable to find any third party software that would index the procedures and functions in your database.

Access does however have a database documenter tool that will list all the [procedures together with their code.

To use, click on tools - Analyze - Documenter. In the resulting wizrd select the modules tab and tick all the modules and click OK.

Hope this helps

Regards

Stephen

Tue 26 May 2009: Automatically marked as resolved.

Access articles

· Making Figures Talk For Themselves Thanks To Access
· When Is Microsoft Access Not The Best Choice For Your Business?
· Learn about Subqueries in Access Courses
· Access Corruption Avoidance Tip #3: Stay Connected
· Microsoft Access Flaws and Ways to Overcome Them

Please browse our web site to find out more about
access courses in london and other Microsoft training courses.

Access tip:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

View all Access hints and tips