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:

…and a table is produced… Let me know if you have […]

Continue Reading


Call Erik Now