select case

How To Use The Value Of A Hidden Combo Box Column

So I had a question come my way regarding some form operations. It will probably help someone else, so I am going to let you know how I did it. Basically it had to do with setting 2 other form controls based on the first. Here is a picture: The table data is a simple […]

Continue Reading

How To Do An Access Export To Excel In VBA

In this post, we are going to do an Access export to Excel, and you’ll see the VBA we’ll work with. This Excel automation will create a worksheet for each of our data points, and then enter the row items for that data point. We are going to let Access do most of the querying […]

Continue Reading