Microsoft Access Office VB VBA Help and Examples  Microsoft Access Help      Search      Privacy      Contact    
 HOME     MS ACCESS     MS OUTLOOK     MS EXCEL     VB and VBA     FREE PROGRAMS     iPAQ     PERSONAL 
 ACCESS     GENERAL     QUERIES     FORMS     REPORTS     MODULES     RANTS     TUTORIALS 

Microsoft Access Other Stuff

Lots of random articles which don't fit in the other categories.

Create an outlook appointment from accessJohn Hawkins
Simple bit of code to allow you to create appointments in your outlook calendar directly from access code.
Bypass startup macrosJohn Hawkins
Locked your database down and removed startup options???
Borrow Spell Check facility from WordJohn Hawkins
Want to word correct what a user just typed in. This example borrows Microsoft Words spell check facility to check a string.
Dates and Times. How to calculate with dates.John Hawkins
Dates and Times. How to calculate with dates.
Dialing with a modem or Data and the Comm portsJohn Hawkins
All the code you need to dial from access straight to the modem. Very simple but can be axpanded if you know what you are doing.
Finding All Those Data Entry TyposJohn Hawkins
Fully built form that will help you find common typo errors in fields where 1 character is wrong.
A Genealogy Example DatabaseJohn Hawkins
A Genealogy Example Database
Importing messages from Outlook to your DatabaseJohn Hawkins
Nice bit of code to run through your inbox and import emails into Access tables
Lookup Tables (LUT)John Hawkins
What is a lookup table and why do I need to use one?. Find out here
Many to Many RelationshipsJohn Hawkins
Another tough topic to get your head round explained in very easy terms.
Normalizing Data and Flat FilesJohn Hawkins
One of the most important aspects of access is normalization. All explained here for the beginner. Learn this before even thinking about building your tables.
ODBC Add-in from ChrisChris Shepherd
ODBC add-in that makes ODBC connections just a little easier to managed from the database
Parsing FormMail CGI Emails into Access TablesJohn Hawkins
FormMail CGI script is a common script use to send emails from a web server. This little solution shows how to scrip those emails into the database automatically.
(Recordset flattening) getting relational data back into a flat formatChris Shepherd
A great example by Chris for turning data back into flat files for presentation purposes.
Outlook ReferencesJohn Hawkins
Change the outlook reference based on what the user has installed
Relation Database Design ExampleJohn Hawkins
Written for beginners this example explains the most important function of databases and that is relational data.
Splash Screen at StartupJohn Hawkins
How to display your own logo when Microsoft Access starts up
Quick ODBC InstallJohn Hawkins
How to install ODBC settings quickly and easily from within the database
Normalizing Data and Flat Files - How ToJohn Hawkins
So you understand normalization, have decided on the tables but have no idea how to convert the 20000 row excel spreadsheet youve been given
 
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.