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

DoCmd.OpenTable help.

P: n/a
I am having problems with my OpenTable code. (Sorry, I'm new at this)

DoCmd.OpenTable Potential_Products_Presented

The debugger says I need a table name.

This code is in the Dbl Click event of a form field. Thanks.

Aug 6 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Mon, 06 Aug 2007 08:47:52 -0700, magmike wrote:
I am having problems with my OpenTable code. (Sorry, I'm new at this)

DoCmd.OpenTable Potential_Products_Presented

The debugger says I need a table name.

This code is in the Dbl Click event of a form field. Thanks.
The name must be a string value, so enclose the name within quotes.

DoCmd.OpenTable "Potential_Products_Presented"

By the way, tables are for storing data, and should not normally be
viewed. It's best to use a form to view your data.

Because forms have events, you can manipulate your records, enter new
records or edit existing ones, and still have some means of assuring
the data is properly entered.

Create a form based upon your existing table.
Then:
DoCmd.OpenForm "Potential_Products_Presented", acFormDS
will open your form in datasheet view.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Aug 6 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.