ms access

MS Access Hiding Text Boxes Based On User Selection VBA

I received an email from a guy to the effect of wanting to hide some textboxes based on a value entered into a single textbox. In my answer, I came up with a way to do this, and decided to share it with you… This example will show you how to hide the textboxes on […]

Continue Reading

How To Write A Recordset To File With VBA

In this video you’ll find out how to write a recordset to a file with VBA using the Microsoft Scripting Object. You’ll find out how to take your table data, and export it to a csv formatted file so you can share it with other applications. Use this method to get your data out of […]

Continue Reading

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. […]

Continue Reading

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 […]

Continue Reading

MS Access Running Counter In Query

This video is part of a solution to an interesting question that I know most developers have faced or are facing… “How can I number my rows in an Access query?” tblRunningSum: Lists numbers starting with 8, and shows how qryIncrement can start at 1 and increment this count from 1 to 10. tblNumbers: Gives […]

Continue Reading

VBA Calculate – Multiply

In this video you will find out how to load a table into a recordset object, loop through the records, and vba calculate 2 fields. Also you’ll find out how to make a user defined function and call it from a query. Need to know how to insert into a table? See this video – […]

Continue Reading


Call Erik Now