no prompt for object members in code

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Greg J - 04 Aug 2006 01:33 GMT

Just opened an access db (Access 2003) that I have been working on for
some time. when I am in a code window and declaring objects, for
instance Dim db as DAO.Database, it no longer prompts me for the member
that follows the full stop. Previously, if I entered DAO., a list
appeared to show me what objects belonged to DAO. Its not doing that
any more.

Im sure its a quick fix option somewhere but have not been able to
locate it. any information would be appreciated

Reply to this Message

Greg J - 04 Aug 2006 01:46 GMT

Also,

All references are still in tact. Code runs properly, even the new
code that I now must write long hand. I am just not getting the prompt
to cofirm the object members.

Reply to this Message

Graham Mandeno - 04 Aug 2006 05:36 GMT

Hi Greg

Go to Tools>Options and make sure that "Auto List Members" is selected.

Signature

Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

> Just opened an access db (Access 2003) that I have been working on for
> some time. when I am in a code window and declaring objects, for
[quoted text clipped - 5 lines]
> Im sure its a quick fix option somewhere but have not been able to
> locate it. any information would be appreciated

Reply to this Message

Greg J - 04 Aug 2006 06:01 GMT

aha!

That was it, thanks.

Reply to this Message