| ||||||||||||
|
|
|
| Use the right-side links to see full text of Visual Basic tutorial examples |
Access 2007 Visual Basic Tutorial List |
| VBA Age Calculation | One would think that calculating a person's age would be straight forward but with leap years and current days in the month it is more involved than we suspected. This VBA tutorial demonstrates two methods for determining a person's age. |
| Change Case VBA Code | Sending out marketing letters? Often you'll get a database the contains messy data in terms of upper and lower case letters. Here is the VBA tutorial code to convert the names and address to proper case. All Visual Basic beginners should know these techniques. |
| Concatenate Records | In this example we take a normalized table of data and change it to non-normalized - more like we would see in a spreadsheet. A Visual Basic advanced programming example. |
| CreateQueryDef | Create stored queries at runtime or create temporary queries to save database space and to make your database less complicated for future maintenance. |
| Current Database Path | Want to know on what drive and directory your database is currently running from. See our VBA tutorial for determining current database path and name. |
| Detail-Master Updates | Retrieving master records based on the characteristics of the detail record. |
| VBA Field Validation | Ever hear of garbage in garbage out. Here are some VBA techniques to keep the garbage out. |
| Field Value New-Old | One method to make a form remember an old value after it is changed. Good for making audit trails. |
| VBA FindFirst Method | You can use the find first command to search through records quickly and manually coordinate two forms. |
| Get Access Version Number | Trying to figure out if your user's Access version is up to date? The VBA tutorial code shows how to determine the Access version number. |
| VB Global Variables | Storing values for the life of a program instance using global variables. A powerful VBA tutorial example. |
| Global Parameters | Use global variables here, there and everywhere - including passing parameters to queries and forms. This is one of our most popular VBA tutorials. |
| Form Label Link | Make your programs come alive and more user friendly by making field labels intelligent links. |
| Combo Box Files List | See the VBA Dir$ function create a drop down list of folders for you users to select from. |
| Visual Basic Mail Merge | Similar to regular mail merge but all controlled in Access so you don't have to jump to MS Word. |
| OutputTo Crosstab Bug with Aggregate Functions | Microsoft Access bug with global variables & OutputTo using the crosstab query Docmd VBA tutorial code. |
| Read Outlook Email | Communicate with Microsoft Outlook from Visual Basic. Read email messages by using the Outlook API. |
| Sort VB Recordset Using Binary Sort | All programmers need to know how to sort a list quickly. See this VB recordset example to learn one of the most efficient and easiest VB sort routines: The recursive visual basic sort routine. |
| Recordset Filters VBA Code | Learn how to filter VB recordset using 3 VBA methods. |
| Reference Nested Forms and Fields |
Take a short cut - reference your forms using the direct access approach. In this example we reference a deeply nested sub form control. |
| RTF Report Email Attachment | Send an RTF formatted to someone via VBA and your email system. |
| Access Select Case Statement | Stop using complexly nested if statements and replace them with a Select Case statement. Select case makes coding and code maintenance a breeze. |
| Send Email with Access VB | In a previous tutorial we learned how to read Outlook emails. Here we teach the VBA tutorial code to send emails and attachments. |
| Transaction Processing | Want to make sure your data gets saved or updated. Use transaction processing methods to guarantee that no data gets left behind. |
| Visual Basic functions from A to Z VBA Tutorial. |
|
|