Microsoft Access Tips

Suppose you have an Access Database containing the names and addresses of your customers.  Every now and again you may want or need to send...

Last week I explained how to create an Access VBA Custom Function in a global module .  This was something of a departure from what I cove...

VBA Custom Functions work in a similar way to any inbuilt MS Access Function.  Both types can be called within VBA sub-procedures, and then...

I have been writing the MS Access Tips blog around three years, and it is now being read by hundreds of people each day. I am very intereste...

Information stored in a database is likely to change over time.  When details change, data may be overwritten, and once this happens it is ...

Last year I wrote a post on Linking to an External Data Source .  This is where we split an Access database  into a Back End (which stores...

Once you have created an Access Database Application to be used by other people, it may well be important for you to prevent users from gai...

If you read my blog last week you may have seen the sample Lending Library Database that I created to demonstrate a working example of the ...

Last week I wrote a post on How to Access Data with VBA Code .  Instrumental in this was the use of the DAO Recordset Object.  Through usi...

This post is all about how we can use VBA code to access the data stored in our database.  By access, I mean, being able to add , find , ed...