Access Lunchtime – Making and Using Access Add-Ins

Come join us Tuesday August 25th @ 12 noon CDT.  Maria Barnes will be your host and we will cover lots of interesting topics related to Microsoft Access.  This is a free webinar for 1 hour, we look forward to meeting you!

=== MEETING DETAILS ===

Crystal (strive4peace) will discuss add-ins that can be downloaded freely with source code, and show you how to make your own add-in.

Data Dictionary

This free tool makes it quick and easy to get a Data Dictionary for any table in whatever database you have open. Optionally, export the data dictionary information to a text file so you can look at it somewhere else, like NotePad or Excel. A bonus is being able to filter the tables listed lots of different ways.

Document SQL, RecordSource, RowSource for Queries, Forms, and Reports

Document SQL, RecordSource, and RowSource statements in Queries, Forms, and Reports to Microsoft Word. Test every statement. Mark Bad! statements so you can fix them, or verify they’re okay. Count records when opened successfully. Show the SQL formatted with key words at the beginning of a line and line break + tab before commas. Write reports to Microsoft Word.

Save and Restore Table Size and Position

Save and restore the position and size of open tables. This is like Excel’s Save Workspace feature.

Color VBA Code

Quickly insert tags for coloring VBA that is posted on web pages and in forums. Color Comments GREEN and Keywords BLUE for VBA.

Download Add-ins on MsAccessGurus.com here

http://msaccessgurus.com/tools.htm#Addins

=== bio ===
Crystal (aka strive4peace), a long-time Access MVP, has been teaching and building applications with Access for more than 25 years. She freely shares code and tools on MsAccessGurus.com and AccessMVP.com,  makes videos for YouTube, and writes articles about Access for a monthly magazine. Her business is connecting to others and helping build applications while teaching how to do it.

We meet every last Tuesday of the month at 12 noon CDT.

To join our meeting, please use the following link and phone number or use your computer’s speakers with audio:

Join Webex Meeting