Access 2007 Help Files

[Jack Cannon]

I recently upgraded to Access 2007. I tried using HELP to search on a
specific statement and was unable to locate anything useful. Almost
everything I tried stated "No Information Available". What I really need is
the VBA Language Reference for 2007. Can anyone offer any suggestions?

Jack Cannon

 

[Arvin Meyer [MVP]]

I've had the same difficulty. I use 2 sources, first Access 97 help, which
has an excellent, albeit for Access 2007 incomplete help file. And the
second source is Access 2007 VBA Programmer's Reference by Access MVPs
Teresa Hennig, Armen Stein, et. al.:

http://www.amazon.com/Access-2007-P...=sr_1_1?ie=UTF8&s=books&qid=1272171007&sr=8-1

 

[Jack Cannon]

Thanks Arvin.

Has anyone got any idea what is going on? In Access 2002 I could just
highlight a command in the VBA code then hit F1 and it would go directly to
the command and I could immediately clarify any questions that I had on the
syntax.

Thankfully I still have Access 2002 installed on a different machine. So
when I have a question using 2007 I go to a different room and check the Help
files on Access 2002.

Frankly I am considering removing 2007 and reinstalling 2002. If this is
Microsoft's idea of providing incentives to upgrade then someone in the
marketing department has the IQ of a moron.

Jack Cannon

 

[Jeanette Cunningham]

I rarely get the 'no information available', although I do seem to remember
some frustration with that a while ago.
There was a thread a few weeks ago where Ben Clothier pointed out that if
you set the help to search only on your computer instead of office online,
the results were much better.
To turn off online search, there is a small icon at bottom right corner of
the help screen. Right click it and choose the appropriate option.

Jeanette Cunningham

 

[Paul Shapiro]

Access 2007 help works for me too. If I open the VBA editor and click the
Help command on the toolbar, I get the standard VBA reference material. I do
have online help disabled as Jeanette suggested. You can also get to that
setting from the Access Options, Trust Center, Privacy Options. I cleared
the box next to "Search Microsoft Office Online for Help content".

Office service packs fixed some issues with Access. I don't remember if Help
was one of them, but if you haven't installed the latest updates that might
be worth trying too.

 

[David W. Fenton]

I recently upgraded to Access 2007. I tried using HELP to search
on a specific statement and was unable to locate anything useful.
Almost everything I tried stated "No Information Available". What
I really need is the VBA Language Reference for 2007. Can anyone
offer any suggestions?

Are you searching from the Access window or from the VBE? For VBA,
you need to use help in the VBE. I find this annoying, but it is at
least explicable and predictable.

 

[Arvin Meyer [MVP]]

That should still work. The property sheet also works using F1. I often
double-click on the function I am trying to get help for then right-click
and choose definition which opens the Object Browser. Turn off the online
help unless you need something from it, as it usually has significant
amounts of off-topic materials which isn't worth wading through. If you do
want to search online, use bing or google. The results will be much better
than the local product. For instance, to search for DSUM() use:

MS-Access DSUM function

and you'll get very relevant answers from multiple sources.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access

 

[Jack Cannon]

It was the online help issue that caused my problem which only returned
irrelevant garbage or "No Information Available". Although I started years
ago with Access 97, this was my first attempt at using 2007 and I never saw
anything like this in earlier versions. It was very frustrating at being
unable to check syntax on a statement. I was unaware of the online help icon
but once I turned it off as several suggested, Help appears to work exactly
as expected.

Thanks Everyone,
Jack Cannon

 

[David W. Fenton]

Are you searching from the Access window or from the VBE? For VBA,
you need to use help in the VBE. I find this annoying, but it is
at least explicable and predictable.

Also, if you're doing that already, you might find this
StackOverflow.com posting illuminating:

http://tinyurl.com/35t6nka =>
http://stackoverflow.com/questions/2448752/associate-a-help-file-with
-a-library-in-the-vba-object-brower

(I remembered that discussion just after I posted)