Help with MS Function

  • Thread starter Thread starter Dan Bair
  • Start date Start date
D

Dan Bair

Hi;

I'm still trying to run some code that opens my help file
from a module. I'm getting the following message:

"Microsoft Access can't find the
name '<<strHelpFileName>>' you entered in the expression.

The code in the module was given to me by Dave and looks
like this:
--------------------------------------------------------
Option Compare Database
Public Const HELP_CONTEXT = &H1
Declare Sub WinHelp Lib "user32" _
Alias "WinHelpA" ( _
ByVal hWnd As Long, _
ByVal lpHelpFile As String, _
ByVal wCommand As Long, _
ByVal dwData As Any)

Function OpenHelpWithContextID(ByVal strHelpFileName As _
String, lngContextID As Long)

WinHelp Application.hWndAccessApp, ByVal
strHelpFileName, _
HELP_CONTEXT, ByVal lngContextID

End Function
-------------------------------------------------------

I am executing this code from a macro. I would like to
have 'strHelpFileName' contain "Project.hlp" and
lngContextID = 1000, but I'm not sure where to assign
these values in the code.

Help,
Dan
 
Hi,
Just call it like this:

OpenHelpWithContextID "C:\Documents and Settings\artusod\Desktop\outlook help\VBAOUTL.HLP",1000

You have to include the full path to your help file.
Of course I get, 'Topic doesn't exist' but presumably 1000 means something to your
help file.
 
Thanks for responding so quickly Dan, hope you're still
out there.

Does this code go in a module that is called by a macro?
If so, is the function name
called "OpenHelpWithContextID"?

I'm trying to execute this from a custom toolbar. The
toolbar allows me to execute a macro. The macro requires
a function. I don't know squat about functions, but when
I try to execute something like:

Funtion OpenHelpWithContextID "C:\.......Project.hlp",1000

I get a compile error. How's it supposed to look?

Thanks again,
Dan
-----Original Message-----
Hi,
Just call it like this:

OpenHelpWithContextID "C:\Documents and
Click to expand...
Settings\artusod\Desktop\outlook help\VBAOUTL.HLP",1000
You have to include the full path to your help file.
Of course I get, 'Topic doesn't exist' but presumably 1000 means something to your
help file.

--
HTH
Dan Artuso, Access MVP


"Dan Bair" <[email protected]> wrote
Click to expand...
in message news:[email protected]...
 
Hi,
If you're running it from a macro, just enter it in the Function Name text box:
OpenHelpWithContextID("C:\Documents and Settings\artusod.LISE\Desktop\outlook help\VBAOUTL.HLP",1000)
 
Thanks again Dan.

What are my other options... other than a macro. I still
want to run it from the toolbar. Could I put the code in
a form and make the form invisible. Can you somehow just
run code from the toolbar?
-----Original Message-----
Hi,
If you're running it from a macro, just enter it in the Function Name text box:
OpenHelpWithContextID("C:\Documents and Settings\artusod.LISE\Desktop\outlook
help\VBAOUTL.HLP",1000)

--
HTH
Dan Artuso, Access MVP


"Dan Bair" <[email protected]> wrote
Click to expand...
in message news:[email protected]...
 
Hi,
Nothing wrong with using a macro, in fact I couldn't get it to work by calling
the function directly from the button click.
 
Back
Top