Microsoft Access Help

[LeoDee]

If it weren't for this site I would have probably slit my throat sometime back if I had to depend on the help system in Access (XP Professional). Lots of message in this forum say to check Access Help. So, maybe, I'm thinking its not the Help system, it might be me.

Here an example of the frustration I have. If it weren't for this forum, I'd never know that DCOUNT existed. So after looking at a reference here, I tried to use DCOUNT but was having problems. So I checked out the Access Help and typed in DCOUNT. No reference!! Also, while coding I put my cursor on DCOUNT and hit F1....again no help. I finally got it working after coming back to this site.

Luckily, I tripped over EXPRESSIONS which has helped me in other areas. But it all seems hit or miss.

Am i missing an easy, better way to use the Help System in Access?

Thanks....

 

[Jack Cowley]

In its great wisdom Microsoft decided to put Help in two places rather than in just one. If you have a question about 'code' things like functions, domain aggregate functions, etc. you have to have a code page open and then click on Help. If you have a question about forms or other stuff not related to 'code' then you do not need to open a code page but 'regular' Help may have the answer....but then again....

hth,
Jack

 

[ghudson]

Are you searching with the "Contents and Index" option of Access for help?

Click the menu bar option Help, click Contents and Index and use the Index tab to search for a key work.

As an example, if you were to type in "DLookup" (without the quotes) in the first field of the Index tab you would have seen the DLookup function and clicking the Display button would give you more info than you would ever need about the syntax of DLookup and some examples to play with.

HTH