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

Tables invisible per VBA - howto?

P: n/a
Hello,

in an Access2003-DB are some tables that should be set to invisible. These
tables were updated and generated automatically by an query each evening and
after the generation the tables are still visible.
Now I´ve some VBA-Code, but it doesn´t work:

DoCmd.SelectObject acTable, "00_AllgInfo", True
DoCmd.RunCommand acCmdHideTable

It produces the following error-message: The comand "TabelleAusblenden"
can´t be used at the moment.

A manual solution is not usable, because of the automatic generation of the
tables at night. After the generation the table must not be visible in
DB-window.

Thanks in advance for any idea.
Andreas
Oct 10 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi, Andreas
Thanks in advance for any idea.
Read the answers you have received in dcdma ;-)

Regards
Jens
Oct 10 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.