I put this post under Forms but decided to put it here also since I am looking for code.
puforee (TechnicalUser)
(OP)
25 Apr 17 23:23
In MS Access 2013 a form can automatically be created by clicking on a table name and then using the Create ribbon and Form button to automatically create a form. This is a very basic form but servers its purpose well for my project. Formatting is not an issue.
Now the question. I use code to import spreadsheet data to MS Access. This import will create a new table. The created table takes the name of the Excel Tab name. So, the code knows the table name. I want to add code to automatically create a form based on that table. Just like if I did it manually by selecting the table name and using the create ribbon Form button as described above.
Does anyone have any idea on how to do this with VBA?
puforee (TechnicalUser)
(OP)
25 Apr 17 23:23
In MS Access 2013 a form can automatically be created by clicking on a table name and then using the Create ribbon and Form button to automatically create a form. This is a very basic form but servers its purpose well for my project. Formatting is not an issue.
Now the question. I use code to import spreadsheet data to MS Access. This import will create a new table. The created table takes the name of the Excel Tab name. So, the code knows the table name. I want to add code to automatically create a form based on that table. Just like if I did it manually by selecting the table name and using the create ribbon Form button as described above.
Does anyone have any idea on how to do this with VBA?
