Using An Access Data Entry Form With Some VBA

Using An Access Data Entry Form – Querying A Database With Some VBA

It’s during day three of an Access training course teaching keen ‘developer’ students the art to using an Access data entry form and immediately they realise creating such a form is simple enough to do but realising the inflexibility for the everyday use when end-users get to test and use this in anger.

What I’m talking about here is where we have a typical scenario of entering in new records (say order transactions) by first having to select either an existing customer or having to create a new customer.

How will the data entry form handle both situations without the need to split the two into separate forms mimicking each other?

access data entry form

Think of a layout to a form containing a sub-form which has a relationship between the customer and existing transactions. Normally, users Continue reading “Using An Access Data Entry Form With Some VBA”

Using DropBox: Storing Your Microsoft Access Database Online

Using DropBox: Storing Your Microsoft Access Database Online

Ever contemplated using DropBox? I use this great free online service to store, transport and share large Microsoft Access database files – Yep, it can be shared and even keep track of different versions synchronising between multiple users and their requirements.

DropBox is a secure file syncing product service too that moves the latest version of your Access file to the Internet as soon as it is saved from your hard disk. It does this when the file is saved updating the DropBox database.

using dropboxYou will need to have or register an account at DropBox should you Continue reading “Using DropBox: Storing Your Microsoft Access Database Online”

Access 2013 – 4 Ways to Create an Access App

Access 2013 – 4 Ways to Create an Access App

Here’s a quick video tutorial (only two and half minutes) that shows the new pending Access 2013 application and the 4 ways to create and MS Access app (or database)

httpvh://www.youtube.com/watch?v=nN1y1j3kE9I

Four individuals demonstrating the 4 ways to create an Access database with the main feature being the new enhanced and advancement bringing it into 21st century namely a web version.

Access 2013 – 4 Ways to Create an Access App

Even though previous versions of Access use the web services, this version is even more simplified and slicker to use.

access 2013To be honest, I haven’t spent too much time with the new version and it’s not yet released to the public just yet and my clients therefore do not need to know anything about this yet but as we now use more and more web based applications and our smart-phones are becoming more sophisticated, Microsoft have finally recognised the need to be in the game and market share and this is certainly the first steps to a ‘mobile’ device version.

I wrote a quick summary of Access 2013 and their new features a few months ago and it appears it’s pretty going to be this look and feel too – so not too many things have changed since then.

I will be moving to Access 2013 very soon though I still do look after clients who use Access 2000 over the web too!

Anyone else thinking of upgrading? Let me know your thoughts in the comment box below.

Access Security Warning: Decide Whether To Trust Your Access Database

Access Security Warning: Decide Whether To Trust Your Access Database

The Access security warning system was changed and further enhanced with the release of Access 2007 and improved again with version 2010 making this even simpler to use as you now decide if you want to ‘Trust‘ your database making all other security elements automatically trusted for you.

The encryption technology within Microsoft Access 2010 is certainly the most sophisticated yet and covers the wider range of the MS Office suite too and for the first time Microsoft also provides you with the option to implement a third party encryption tool giving you the greater freedom and further choice in how you protect your databases.

access security warning

If you had used the security features in the earlier versions of Access (pre 2007), you had to make Continue reading “Access Security Warning: Decide Whether To Trust Your Access Database”