Create Table

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