SQL

How To Find Which Table Is Causing Your Access Database To Be So Big

Some of you, like me, sometimes have the question of “what is causing my Access database to be so big!” As you may or may not know, the database’s tables are the only objects which store the data. It’s very frustrating not to know, and just to try and look smart by saying the generic […]

Continue Reading

How To Use A TempVar As A Parameter For Your Update Query

Have you ever wanted to use a parameter that is not stored on a form somewhere as a parameter for your update query? Well this example will show you how you can use an input box to enter a parameter and that you can use in your update query. The impetus for this idea was […]

Continue Reading

How To Have MS Access Increment A Number Without An Autonumber VBA

So I had an interesting question come my way today via the chatbox on this website. Basically it was to increment a value in a label based on the button that was clicked. Here is what part of the form looked like: The data was saved and read from this table: So if the green […]

Continue Reading

How To Connect Access To SQL Server On Amazon Virtual Machine

In this post I am going to show you how you can connect your Access database to a Microsoft SQL Server 19 running on an Amazon Virtual Machine. Something great about the current technology is that you can have a version of something that would cost you BIGGGGGGGG Money in the past! In this case […]

Continue Reading

Field Inspection App In MS Access

Today, we will consider how to track field inspections, by building a framework for a field inspection app in MS Access. This sample application is just a framework, and just shares some potential ideas. You can customize it and put your own “spice” on it. Here’s what it will look like when we’re done: First […]

Continue Reading

Access VBA Create Table (Simplified)

This post is an answer to someone else who wanted to create a table and field names based on form inputs. So I simplified a past post: http://vbahowto.com/how-to-create-a-table-in-access-using-sql-and-vba/ Here are the form inputs: …and when you click the button, the following code runs: Private Sub btnCreateTable_Click() CreateNewTable MsgBox “Table Created. (Press F5 on your keyboard […]

Continue Reading

How To Create A Table In Access Using SQL And VBA

This post will show you how to create an empty table in access using sql and vba This is a simplified version of my other post, “Access VBA Create Table” That post was the more elaborate way of table creation with VBA. This one will just show how to generate an empty table. In the […]

Continue Reading

How To Extract Data From Outlook To Access With VBA

In this post you are going to find out how you can extract data From Outlook to Access with VBA”. Someone at the place I’m working at was let go, and they wanted the information, primarily from the user’s Outlook inbox, to be extracted to an outside application so the particular information about various projects […]

Continue Reading