By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,505 Members | 1,511 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,505 IT Pros & Developers. It's quick & easy.

Table dose not exist

P: 5
Hi all,

Could someone please point me in the right direction!

I am in the process of creating an Ms Access db and as part of this use VBA in a form to create a table based on the input to the form.
The VBA is run as a result of clicking a button, creates the table and then opens a new form with a sub form based on the new table.

However this bit dose not work and you get the message "Table dose not exist"
The table dose not appear in the database window until you click on another tab and then back to Tables.

This leads me to think that I need some way to refresh the list of tables before opening the new form.

Any thoughts or comments most welcome
Jun 8 '07 #1
Share this Question
Share on Google+
2 Replies


puppydogbuddy
Expert 100+
P: 1,923
Hi all,

Could someone please point me in the right direction!

I am in the process of creating an Ms Access db and as part of this use VBA in a form to create a table based on the input to the form.
The VBA is run as a result of clicking a button, creates the table and then opens a new form with a sub form based on the new table.

However this bit dose not work and you get the message "Table dose not exist"
The table dose not appear in the database window until you click on another tab and then back to Tables.

This leads me to think that I need some way to refresh the list of tables before opening the new form.

Any thoughts or comments most welcome
Try adding this line of code after you've finished creating the tables and before creating the form:

db.TableDefs.Refresh 'replace db with the database object that you created
Jun 8 '07 #2

P: 5
Sorry for the delay getting back to you but my PC died!!!

Many thanks for the super quick reply.
I tried it but couldn’t get it to work however it did point me in the right direction and I used CurrentDB and that worked

Many thanks again
Jun 16 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.