Basic help needed - Newbie to Access VBA

[fire_rob]

Hello:

I've spent much time searching and can't find an answer to my somewhat
embarrassing question.

I am new to using Access and VB in Access but I have some experience in
Excel, though it has been several years. I am trying to start up a project
and cannot seem to add any forms to my project to be used in the Visual BASIC
editor.

Specifically, I can add a form in the Access interface using the Database
window. When I go to the Visual BASIC editor it does not show up as part of
my project.

I have copied another project and can see the Main switchboard form that it
has in the project window and can access it with code, etc. Also if I copy
this form that I can see to a new form in the Database window of Access
(using right-click copy/paste routine) I can see the new form in the VB
project display. What am I missing here?

Also, how do I "see" tables that I have created as well in the VB editor?

Thanks for the help, I hope I have explained it well enough for someone to
answer.

 

[Dirk Goldgar]

Hello:

I've spent much time searching and can't find an answer to my somewhat
embarrassing question.

I am new to using Access and VB in Access but I have some experience in
Excel, though it has been several years. I am trying to start up a
project
and cannot seem to add any forms to my project to be used in the Visual
BASIC
editor.

Specifically, I can add a form in the Access interface using the Database
window. When I go to the Visual BASIC editor it does not show up as part
of
my project.

I have copied another project and can see the Main switchboard form that
it
has in the project window and can access it with code, etc. Also if I
copy
this form that I can see to a new form in the Database window of Access
(using right-click copy/paste routine) I can see the new form in the VB
project display. What am I missing here?

Also, how do I "see" tables that I have created as well in the VB editor?

Thanks for the help, I hope I have explained it well enough for someone to
answer.

Not all Access forms have a VBA module attached to them. If a form has no
code, it doesn't show up in the VB Editor, because it isn't part of the VB
project. If you took that code and added some code to it -- for example, by
adding an event procedure to one of the events of the form or its
controls -- then it woud show up in the VB Editor, listed in the Porject
pane under "Microsoft Office Access Class Objects", or some variation of
that term depending on the version of Access you're using.

 

[fire_rob]

Thank you!

Not all Access forms have a VBA module attached to them. If a form has no
code, it doesn't show up in the VB Editor, because it isn't part of the VB
project. If you took that code and added some code to it -- for example, by
adding an event procedure to one of the events of the form or its
controls -- then it woud show up in the VB Editor, listed in the Porject
pane under "Microsoft Office Access Class Objects", or some variation of
that term depending on the version of Access you're using.


--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)