
Microsoft Access Office VB VBA Help and Examples	Microsoft Access Help	Search	Privacy	Contact

Microsoft Access Modules (VBA)

There's lots we can do with access, and most things are accomplished using tables, queries, forms and reports. But to take access to the next level you need to use modules. Modules are reusable collections of code with which there is no end of possibilites to what can be done in your database. This section is dedicated to module examples.

Oh and if I catch any of you using Macros to do things it will be a severe slap on the wrist ;P


Calculating the Percentile of a Recordset		John Hawkins
	How to calculate the Percentile of a recordset

Top Five One Line Code Statements		John Hawkins
	This shows you my five favourite one line code statements

Useful Functions and Sub Procedures		Chris Shepherd
	This database has a load of usefull functions and subs written by Chris Shepherd. If we get enough response I may be able to get him to keep updating it

Create a search form to search a text type field		John Hawkins
	This shows how to create a search form that will enable users to enter a string of words and then return search results (including number of hits) to the user

Conversion Functions Explained		John Hawkins
	How to convert from various types to various other types

File Open Dialog Boxes Without Using Common Dialog Controls		Chris Shepherd
	How to create file open dialog boxes without using common dialog controls.

Object Exporter for Access 97		John Hawkins
	VBA . If you've replicated a database and don't have a copy of the original ,or have made significant changes, this bit of code will get the objects out of the database for you. Now includes all objects for export, including relationships. Can also be used to move large numbers of objects to another database. VB Program in VB section.

Count, Sum, Average and Lookup Fields or Records		John Hawkins
	A beginners guide to the Domain functions (Dcount, DSum, Davg and DLookUp).

Calculating the Median of a Recordset		John Hawkins
	A module which will calculate the median of a recordset field

Calculating the Difference Between Two Dates		John Hawkins
	Tells you all about the datediff function and how to calculate someone's age

Converting a number to its Spoken Word Value		John Hawkins
	An example database that contains a module with a function to convert numbers to words

Reading Outlook E-Mails from Access		John Hawkins
	A module to scan through your inbox and process certain emails

Re-linking tables in an Access Database		John Hawkins
	VBA A little bit of code to automatically re-link tables to a new database. All you have to do is tell the code where the new database is

Calculating the Weighted Median of a Recordset		John Hawkins
	A module which will calculate the weighted median of a recordset field

HOME SEARCH SITE PRIVACY POLICY CONTACT

The code and application content of this site is copyright of Smiley I.T. and as such reproduction in any form which is for commercial use requires the permission of the Webmaster. Any use of this code for non-commercial use only requires a link or comment back to the original page you took the code from.