MS Access and VBA

How to use VBA to minimize the Office 2007 Ribbon

support@extramiledata.com — Fri, 27 Nov 2009 20:27:00 GMT

If you've ever wished you could keep the Office Ribbon, but automatically minimize it to conserve space, this VBA function is for you. The same technique works for Microsoft Access, Microsoft Word, etc.

More...

Use VBA to get the maximum lengths of values in a MS Access table

support@extramiledata.com — Fri, 27 Nov 2009 17:40:00 GMT

If you've ever imported a text file or a Microsoft Excel worksheet into Microsoft Access, you have seen how Access defaults the text field lengths to 255 characters. This VBA function will display the maximum length of the values currently in each field of a table so that you can decide how to correctly set the field lengths. It also shows the data type of each field.

More...

Put your MS Access database on autopilot

support@extramiledata.com — Tue, 06 Oct 2009 17:48:00 GMT

This example shows how to use a command line switch and a scheduled task to start a Microsoft Access application unattended and run some logic automatically.

More...

Remove replication from a MS Access database

support@extramiledata.com — Tue, 04 Aug 2009 21:04:00 GMT

This VBA function copies or imports all the objects and database startup properties from a Microsoft Access replicated database into an un-replicated database. It removes tablename_Conflict tables and removes replication-related fields like s_GUID, etc.

More...

Use VBA to copy MS Access PivotTable values to the clipboard

support@extramiledata.com — Tue, 07 Jul 2009 17:21:00 GMT

This function uses a combination of Microsoft Access, VBA, and Microsoft Excel to transfer the values from an Access form in PivotTable view to the clipboard. It is a good example of automation using late binding.

More...

Find duplicates in a VBA array

support@extramiledata.com — Wed, 17 Jun 2009 22:04:00 GMT

This VBA function looks for duplicate values in an array. If it finds some, it produces a list of the duplicated values. It is a good example of how to loop through an array.

More...

Use a VBA function to open/get a Microsoft Word document and Find a string

support@extramiledata.com — Fri, 12 Jun 2009 21:07:00 GMT

This VBA function opens/gets a MS Word document and finds the next occurrence of a specific string. The function provides a good example of using late binding automation and the AppActivate() function.

More...

Using VBA to fill and manage a Microsoft Access list box

support@extramiledata.com — Wed, 03 Jun 2009 14:46:00 GMT

This set of VBA functions and MS Access example show how to use code to fill a list box, clear a list box, and retrieve selected items from a list box.

More...

Get an age in weeks using VBA

support@extramiledata.com — Mon, 18 May 2009 14:38:00 GMT

This VBA function returns the number of weeks that one date is away from another, in whole weeks. For example, any date in the third week from the starting date will return a value of 3.

More...

Generate a random set of characters using VBA function Rnd()

support@extramiledata.com — Fri, 15 May 2009 14:12:00 GMT

This VBA function uses the Randomize() and Rnd() functions to generate a random string of characters with a specific length. The included Microsoft Access example applies the function to a simple form that can be used to create a password.

More...