"fire_rob" <(E-Mail Removed)> wrote in message
news:9B8CF8E5-09B5-48D4-92B7-(E-Mail Removed)...
> 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.
--
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)
Similar Threads
