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

Prompt user to provide name for new copied table

P: 25
Every month, a new set of record would be entered into the computer. So there is a requirement for a table template where all the fields are there.

I have already made that template and what i intend to use is to copy the template and rename it according to the month and year.

I used the copyobject function to do this but i do not know how to allow the system to prompt the user for the desired table name.

DoCmd.CopyObject,"'", acTable, "Template"
~This would give a type mismatch error

how should i do this?!?!
Please and thank you ppl!
Sep 4 '07 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 12,392
Invoke an InputBox and save the result to a variable. Use that as the name.
Sep 4 '07 #2

Post your reply

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