Create Table

How To Use Access VBA To Copy A Table With DoCmd.CopyObject

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

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