Archive for the MS Access Category


MS Access Incrementer/Counter

Below l show you how to create an incrementer/counter for your Access database. As you may or may not know, Access will reset your counter, every time the form is closed. (It’s like the SESSION variable for a browser). Anyway, to preserve the value of the counter when a database form is closed and reopened, […]

Read More...

File Open Shell VBA

This video is a response to a comment on another video at https://www.youtube.com/watch?v=98t1yLUwmEo&lc=z13oevyrxxiyjpjdd221jthigmnmghv3l “Hello, where can I add code to open a specific excel document?” There is a more useful option to the Shell function, because I don’t have to name the file to open, and it’s already built in to Microsoft Office. You can […]

Read More...

Create A Report Based On Items Selected In Access Combo Box

You can download the database here: Click here for the database and the code: Create-A-Report-Based-On-Items-Selected-In-Access-Combo-Box.accdb If you have a suggestion for a future video, contact me on my contact form, and I will seriously consider it.

Read More...

Access Parameters Using TempVars

Access TempVars are like using query parameters. TempVars seem to be like Session variables for your Access application. In the past I was using hidden forms to store parameters for my queries, but TempVars can be useful to do the same thing. I have seen this in use and wanted to share it with you. […]

Read More...

Access 2010 Ignoring Open Of ADP File

Hi everyone, today I was doing a client consultation and came across a strange issue. Access 2010 was ignoring my request to open an .adp file, or Access project file. Access was ignoring the request to open “adp” files. Normal Access files “accdb” opened fine. I found the solution to be adjusting the security settings […]

Read More...

How To Set Up Relational Database

I had a suggestion from a reader named “Dennis” after trying to gather information for a new database book. He responded: Erik, My suggestion is this: Make an easy tutorial to set up a database with tools on how to setup tables, link tables, how to set up keys on tables. Most tutorials tell users […]

Read More...

MS Access Beginner To Advance Propulsion

Hi, I received an interesting email that I wanted to pass on, because I think it may help some of you in the same situation. Hi Erik, After I go through your course, is there any chance you could provide additional training, such as a small project I could work on with your guidance that […]

Read More...

Resolution – VBA Error 49 – Bad DLL Calling Convention

So everything in this particular database was working for a client of mine, until just last night I get notified that he can’t open the database because of some error. I was able to view his screen using T.V. and after clicking on a command button, I would get the following error: “Error 49 – […]

Read More...

MS Access VBA – How To Add A Select All To A Combo Box

Normally with a combo box, you can select only 1 item in the drop down list. But what happens when you want to “Select All” the items in the list? I have done this 2 different ways, 1 way is to put a checkbox on the form, called “All”, and then have the combo box […]

Read More...

How to create SQL Statement from Combobox Selections

This video will show you how to use checkboxes to create a SQL statement and formulate a recordsource for a form. In the sample database, a certain product can be combined with other products to create a package. We want to select the products belonging to each package. In this video you will be shown […]

Read More...