Access VBA Code Examples and Downloads
We have developed VBA code driven applications since 1992, writing code in both Access and Excel VBA, developing simple applications to corporate financial forecasting suites.
Software excellence is the sum of the parts. The creative skills of the developer lie not merely in elegant Access VBA code but cover the spectrum of development: table and relationship design, query construction, user interface. Each requires expertise and experience and a vision of the whole.
These Access VBA code examples may be copied and freely used in any application, commercial or otherwise. Why not yourself. And if you're a webmaster, I'd appreciate a link to this page.
A selection of VBA code snippets, forms, modules and applications
Data Perception Consulting |
New. Shortly after I began contracting I built this little app to monitor JobServe's vacancies in the UK. I've updated it to accommodate the later (and simpler) CSV format. It allows you to locate, track and monitor vacancy details and subsequent dialogue. It also contains a table of contracting agencies (although it may be out of date). VBA code. Here is the JobServe IT section daily zip download. |
|
Data Perception Consulting |
New. Email harvester spiders traverse the Web looking for email signatures in web pages, for the (often sole) purpose of building databases to sell on as spam email address lists. This obfuscator converts email addresses to ISO, Hex or mixed output to thwart them. VBA code. Here is a live asp-based version. |
|
Data Perception Consulting |
Updated. A professional application must accommodate the odd slip during input. This function parses the input line, and returns proper names. It also parses exceptions like Mc, Mac, D', etc. Now fixes hyphenated names. VBA code. |
|
Data Perception Consulting |
'Mr' and other titles are frequently presented in a combo box based on a lookup table or form. Novice developers place an array of buttons on a form to access these then launch a form to edit the combo-box. If you want another lookup, you must redesign the form! Just design an admin form correctly. Here's how. VBA code. |
|
Data Perception Consulting |
Network bursting - large data transfer requests - is easily done, usually unnecessary and often unintended. It is far too easy to populate a combo box with a runaway query. Use a form-based parameter query. Here's how. VBA code. |
|
Data Perception Consulting |
Linked tables in Access are a prerequisite for network development. OK. So what happens when the logical server path changes? Your automatic relinking code comes into play. Here's how. VBA code. |
|
Data Perception Consulting |
End-of-period or general reporting may require a bunch of reports to be sent to the printer automatically. Group all such reports under a common form and spit 'em out as necessary. Here's how. VBA code. |
|
Data Perception Consulting |
Written one evening after my wife sat on her specs and couldn't check the syndicate's lottery lines. Funny thing is, she still prefers to check 'em manually. Ah, well... VBA code. |
|
Data Perception Consulting |
Part of the output suite of a search engine optimisation and site tracking system built to monitor this very site. VBA code. |