Archive for the MS Access Forms Category


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...

How To Return A Dollar Value As A Text String

Hi, I received an interesting request, involving VBA and how to return a stock price dollar value in a text character string rather that actual numbers. Like (I=1,M=2,E=0) instead of showing cost price is 12.00 it shows IM.EE. Kind of like code returning a special code. Well, here is my rendition of it. It may […]

Read More...

Access Pagination

I have a client who has an underperforming continuous form so I start tinkering around with a model, and created an Access continuous form with pagination abilities. The database is attached. Hopefully it can help you. I will probably be modifying it as needed. 1 Click here for the database and the code: access_pagination.mdb

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...

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

Read More...

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

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...

How To Convert Macros To VBA

This video describes how to use an embedded macro to open a form, and then use the superior, VBA, code to do the same. video: There is more functionality when using VBA to do your actions. Personally, I don’t use macros, unless I need to. If you want to try and convert your macros to […]

Read More...

VBA Building Dynamic SQL

This video example is going to show you how to generate a SQL string from a form in VBA. 1 Click here for the database and the code: Building-Dynamic-SQL.mdb

Read More...