New to VB -- how to open an Access table?

Hi! Help!!

I'm new to VB, and although I understand all the theory I need to
program, I don't know the docmd commands. In particular, right now
I'm just trying to open a table in Access -- yes, that's all -- but
the darned thing doesn't give me any useful clues as to what I'm doing
wrong. Here are samples of commands that don't work:

DoCmd.OpenTable tblRequired_OC
DoCmd.OpenTable (tblRequired_OC)
DoCmd.OpenTable (tblRequired_OC,acViewNormal,acEdit)
DoCmd.OpenTable tblRequired_OC, acViewNormal, acEdit

I have no idea what I'm doing wrong, and all the books must think that
this is too easy to give help for this. Anyone? Thanks muchly...

"Sean Strauss" <sean_strauss@eed.state.ak.us> wrote in message
news:8a0f2ee0.0408031354.30bc4b09@posting.google.c om...[color=blue]
> Hi! Help!!
>
> I'm new to VB, and although I understand all the theory I need to
> program, I don't know the docmd commands. In particular, right now
> I'm just trying to open a table in Access -- yes, that's all -- but
> the darned thing doesn't give me any useful clues as to what I'm doing
> wrong. Here are samples of commands that don't work:
>
> DoCmd.OpenTable tblRequired_OC
> DoCmd.OpenTable (tblRequired_OC)
> DoCmd.OpenTable (tblRequired_OC,acViewNormal,acEdit)
> DoCmd.OpenTable tblRequired_OC, acViewNormal, acEdit
>
> I have no idea what I'm doing wrong, and all the books must think that
> this is too easy to give help for this. Anyone? Thanks muchly...[/color]

The name of the table argument takes a string ("put quotes around it").


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

On 3 Aug 2004 14:54:41 -0700, Sean Strauss wrote:
[color=blue]
> Hi! Help!!
>
> I'm new to VB, and although I understand all the theory I need to
> program, I don't know the docmd commands. In particular, right now
> I'm just trying to open a table in Access -- yes, that's all -- but
> the darned thing doesn't give me any useful clues as to what I'm doing
> wrong. Here are samples of commands that don't work:
>
> DoCmd.OpenTable tblRequired_OC
> DoCmd.OpenTable (tblRequired_OC)
> DoCmd.OpenTable (tblRequired_OC,acViewNormal,acEdit)
> DoCmd.OpenTable tblRequired_OC, acViewNormal, acEdit
>
> I have no idea what I'm doing wrong, and all the books must think that
> this is too easy to give help for this. Anyone? Thanks muchly...[/color]

DoCmd.OpenTable "TableNameinQuotes"
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.