Nifty Gotcha’s

Nifty Gotcha's

Most of the time MS Access provide some Nifty features which help you develop your code. However sometimes MS Access can be too helpful; the additions alterations to your code that MS Access makes can really mess you up! I’ve started a list of them here:-

Access takes Liberties

MS Access takes Liberties

At the start of this video (VBA Beginner – VBA Queries – P2 – Nifty Access) – BELOW  I demonstrate cutting and pasting SQL Statements from Queries into MS Access VBA…

You can see that MS Access formats the Text for you. However, as you can see here, it’s NOT HELPFUL and could cause you a major headache if you’re unaware that ACCESS can do this “Unhelpful” modification!

SQL Insert Statement

Formatting SQL statements can be a pain. It is often a source of errors and difficult to discover where the error is. The solution is quite simple as with any coding, “divide and conquer” in this video I show you an easy way to format your SQL statements so that you removed any chance of errors creeping in!

Global Variables 1

Everyone will tell you you shouldn’t use global variables. There are good reasons for this but I won’t go into those. I will just show you in this video what you can do instead!

More Useful Stuff HERE:-

This website uses third-party software - WordPress Add-Ins to be exact. I don't know what any individual add-in does, but I'm sure that many of them collect information about you. So be aware, if you continue using this site, then you are likely to be sharing your information. I don't know how to disable this sharing for any, or all of the plugins for individual users. So I can't stop the sharing of information. If this worries you then please do not use this site... If you continue to use this site I will assume that you are happy with it.

Do you need a hand in the right direction?

You are in the right place.