This post was actually inspired by a question I received from this site’s chatbot.
In this post you will find how you can use Access VBA and the DoCmd.CopyObject method to copy
a blank table, and append the value of a combobox to it.
The database has just one blank table “tblFacilityBlank”, that we’ll copy and paste for each facility.
Here is the picture of the form that will be used as a “work horse” (it will do all the work)
“frmMakeTable”
Basically, all you do is select a facility from the drop down box, and the selected text will get appended to the blank table.
Then a blank table will be created for the selection made.
Here is the code:
Private Sub btnMakeTable_Click()
'loeblcomservices.com
Dim strNewName As String
'append the combo box selected value to the text
strNewName = "Facility_" & Me.cboFacility
DoCmd.CopyObject , strNewName, acTable, "tblFacilityBlank"
End Sub
That’s all, let me know if you have any questions.
Here is the working example:
How To Escape Apostrophe In SQL Update Query
If you are looping a table with thousands of records, you’ll probably run into at least one that has an apostrophe in the field name. Like “Mike’s” or “M’cormick”, or something else. Anyway, here is one way to escape the string when you are doing your update query. Option Compare Database Sub YDriveLoop() ‘4/23/24 erik@loeblcomservices.com […]
How To Make An Access Form Time Picker
Here is a relatively easy way to select times for your time entry text boxes. It’s a reusable form that allows you to pick a time from an Access form. There are probably different ways to do this but here is the way I would do it. On the form that has the time fields, […]
How To Parse A Flat File In Excel VBA
In another post I demonstrated how to access a file on your computer using the MS Office Library. Here it is if you don’t know what I’m talking about. In this post, I am going to show you how to access the file and load it into your spreadsheet. I will do the same thing […]
How to pick a file to load In VBA
Picking a file to load in your Microsoft App is a very important skill to know. In this blog post you will see how to do it. First you need to set a reference to the MS office object library From VBE editor –> select Tools > MS office object library (click check mark) Sub […]