Replies

When I run the report, the form comes up, but it doesn’t include the list of values from the Employee Name field of the Employee Record table. I hit OK just to move on, and then an Enter Parameter Value dialog box appears with the criteria that I entered in the report query for this value (Forms!Employee Name!Employee).

Also, with the other part of my question, when I try to create a chart report with a parameter query, the wizard walks through each step with no apparent problems, but when I run the report, the chart comes up blank.

Thanks,
Bob

When I run the report, the form comes up, but it doesn’t include the list of values from the Employee Name field of the Employee Record table. I hit OK just to move on, and then an Enter Parameter Value dialog box appears with the criteria that I entered in the report query for this value (Forms!Employee Name!Employee).

Also, with the other part of my question, when I try to create a chart report with a parameter query, the wizard walks through each step with no apparent problems, but when I run the report, the chart comes up blank.

Thanks,
Bob

Also, I ended up searching for a paragraph marker in a certain style. I then replaced it with the added text and a new paragraph marker.

Bob

Also, I ended up searching for a paragraph marker in a certain style. I then replaced it with the added text and a new paragraph marker.

Bob

The Selection.Tables(1) code helped.

Thanks,
Bob

The Selection.Tables(1) code helped.

Thanks,
Bob

The If Selection.Find.Found logic helped get what I wanted.

Thanks,
Bob

The If Selection.Find.Found logic helped get what I wanted.

Thanks,
Bob

That resize text feature that you mention sounds like the problem I have. I ended up resolving things by rebuilding the slide from another slide. Your advice is similar to advice I saw elsewhere–I checked my settings (in P2000, it’s Tools > Options > Edit tab) and the Autoformat as you type option was checked. That might have been the problem.

Thanks,
Bob

That resize text feature that you mention sounds like the problem I have. I ended up resolving things by rebuilding the slide from another slide. Your advice is similar to advice I saw elsewhere–I checked my settings (in P2000, it’s Tools > Options > Edit tab) and the Autoformat as you type option was checked. That might have been the problem.

Thanks,
Bob

Kim,

Setting up a module really helped. Also, I was able to get F1 field help using this new module and the Don Lammers article on HTML/Visual Basic in the Shadow Mountain web site that you recommended. Interestingly, RoboHelp recommended the class module that originally had the public declaration.

That was the main obstacle to setting up a demo of the system–now I don’t have to think about this 24 hours a day. Thanks for taking such a strong interest in my project.

Bob

Kim,

Setting up a module really helped. Also, I was able to get F1 field help using this new module and the Don Lammers article on HTML/Visual Basic in the Shadow Mountain web site that you recommended. Interestingly, RoboHelp recommended the class module that originally had the public declaration.

That was the main obstacle to setting up a demo of the system–now I don’t have to think about this 24 hours a day. Thanks for taking such a strong interest in my project.

Bob

Hi,

I’ve attached my Visual Basic project, along with a RoboHelp add-in class module (RoboHelp_Csh.cls), the map file generated by RoboHelp (BSSCDefault.h), and the compiled RoboHelp file (MHC_Online_Help_Prototype.chm). There seem to be three open issues:

— How should the Declarations be set up? It looks like the RoboHelp_Csh.cls file is taking care of this, but I’m not sure.

— How is connection made between VB fields and RH topics? In the HelpContextID property of text boxes, I’ve entered the same number as the number that RH assigned to the corresponding topic in the map file. It seems like there should also be some kind of call between RH and VB.

— How are help topics called from fields? In the Click event of the Notification field, I entered a call to help, based on syntax provided by RH Help. I got run-time error 424 (Object required).

The RH add-ins were the RoboHelp_Csh.cls file and a reference to Microsoft Internet Controls (Project > References).

Thanks for the reference to the Paul O’Rear site–it helped simplify the problem. Most of my VB experience is with Word macros, so any help is really appreciated.

Bob

Hi,

I’ve attached my Visual Basic project, along with a RoboHelp add-in class module (RoboHelp_Csh.cls), the map file generated by RoboHelp (BSSCDefault.h), and the compiled RoboHelp file (MHC_Online_Help_Prototype.chm). There seem to be three open issues:

— How should the Declarations be set up? It looks like the RoboHelp_Csh.cls file is taking care of this, but I’m not sure.

— How is connection made between VB fields and RH topics? In the HelpContextID property of text boxes, I’ve entered the same number as the number that RH assigned to the corresponding topic in the map file. It seems like there should also be some kind of call between RH and VB.

— How are help topics called from fields? In the Click event of the Notification field, I entered a call to help, based on syntax provided by RH Help. I got run-time error 424 (Object required).

The RH add-ins were the RoboHelp_Csh.cls file and a reference to Microsoft Internet Controls (Project > References).

Thanks for the reference to the Paul O’Rear site–it helped simplify the problem. Most of my VB experience is with Word macros, so any help is really appreciated.

Bob

Kim,

Thanks for your procedure–it gave me some more insight into my own project. Since my first post, I’ve installed the standalone VB6. Also, I’m using HTML help. You say that doesn’t work with VBA; I’m wondering if I’ll have better luck with standalone VB6.

I have the include file that you mention–it’s the map file that RoboHelp generated. Where in the VB project should I include it?

Also, here is the code that RoboHelp says will connect VB and RH (some RH add-ins to VB also are involved):

Public cshObject as new RoboHelp_CSH ‘Should be global object

cshObject.RH_ShowHelp me.HWMD, strPathAndWindow (points to *.chm file), cshObject.HH_HELP_CONTEXT, topic number

I’ve tried the variable declaration and the object.method in several places, but the best I can do is bring up the VB form–not the RH file–which confuses me. Would you have any idea what I can do here?

Thanks,
Bob