I'm using Access 2007. I have several forms that are not listed in the
"Microsoft Office Access Class Object" list. I've searched on-line help to
no avail.

How can I add it?

Your help will be greatly appreciated!

I'm usually a pretty good mind reader but you seem to be out of range.

Do you think you could provide us with your code that isn't working for you,
a brief explanation of what you need it to do and then we will be able to
help.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.



"laavista" wrote:

> I'm using Access 2007. I have several forms that are not listed in the
> "Microsoft Office Access Class Object" list. I've searched on-line help to
> no avail.
>
> How can I add it?
>
> Your help will be greatly appreciated!

[Laavista]

I have no code at this point. I've created 5 forms. 3 of the forms are listed in the "Microsoft Office Access Class Object" list which will allow me to add code. 2 of the forms are not listed. I did rename one of the unlisted, but I did check the "form name" in properties, and it had the correct name.

Thanks in advance for any help you can provide.

I have no code at this point. I've created 5 forms. 3 of the forms are listed
in the "Microsoft Office Access Class Object" list which will allow me to add
code. 2 of the forms are not listed. I did rename one of the unlisted, but I
did check the "form name" in properties, and it had the correct name.

Thanks in advance for any help you can provide.

"laavista" <(E-Mail Removed)> wrote in message
news151EE5F-682A-4B72-B12D-(E-Mail Removed)...
> I'm using Access 2007. I have several forms that are not listed in the
> "Microsoft Office Access Class Object" list. I've searched on-line help
> to
> no avail.
>
> How can I add it?
>
> Your help will be greatly appreciated!

Forms and reports only appear in the VBE's class object list if they have an
attached module. Not sure how to ensure this in A2007 because I don't have
that version, but in A2003 at least you would click on the 'View' menu and
select 'Code'. IOW as soon as you add some code to a form's module it will
appear in the list.

Thanks for taking the time to help with this!

"Stuart McCall" wrote:

> "laavista" <(E-Mail Removed)> wrote in message
> news151EE5F-682A-4B72-B12D-(E-Mail Removed)...
> > I'm using Access 2007. I have several forms that are not listed in the
> > "Microsoft Office Access Class Object" list. I've searched on-line help
> > to
> > no avail.
> >
> > How can I add it?
> >
> > Your help will be greatly appreciated!
>
> Forms and reports only appear in the VBE's class object list if they have an
> attached module. Not sure how to ensure this in A2007 because I don't have
> that version, but in A2003 at least you would click on the 'View' menu and
> select 'Code'. IOW as soon as you add some code to a form's module it will
> appear in the list.
>
>
> .
>