1

Topic: Question on creation of reference system to program Access

Presence of contextually dependent reference system to the program raises attractiveness and convenience of operation.
The program at me more or less , came it is time to write reference system. Once I already was engaged in it. Wrote helps under Access 97, 2000 and 2003. I wrote helps in format HLP. Now I work with Access 2010. Format HLP does not support for a long time already Microsoft. And even removed the compiler from the site. Wrote help in format CHM. Also anchored to the program.
The program at me is developed in format MDB and made so that worked under any version Access since 2000, and in any digit capacity (32 and 64). There are users at whom till now cost Windows XP and Office 2003 (license). But here an ill luck. In Access 2007 (well in 2010 it is exact) reference system CHM works, and more low versions CHM do not want to connect and demand to itself HLP. And how here to be? Programs do not swear, is simple on F1 deduce help Access, instead of programs.
-------------------------------------------------------------
And you enclosed already the blood rouble in Bill Gates's 50 milliard state?

2

Re: Question on creation of reference system to program Access

Joss;
How much I can judge - even if to make the "most ideal", "most interactive" help - all the same there will be very big percent of users which will not read it. We even with the program spread video of operation on some moments. And to sense? And will be will ask the banal questions which lie "on the first pages of help". Therefore, after some meditations and experiments I do not see sense especially to be perverted. Therefore as help is written, how it appeared, for itself: what not to forget, where that in the program lies and as works, plus possibility  the client in this or that reference topic. And that small percent of "reading" users understand in with any format of help.
At present helps I do in WinCHM, I spread in the Web help format. Problems any. Unless at pair clients browsers not , but it is a separate subject.

3

Re: Question on creation of reference system to program Access

I too created CHM help. Also connected it to the program. Offline, without the Internet. These are requirements. But here In an Access 2000 it does not work. It can be opened and viewed, but here it ceased to be contextually dependent. And on F1 it is not caused.
However there were some ideas.  after, now operation pulled hard.

4

Re: Question on creation of reference system to program Access

Joss;
What, and old tricks ceased to work?
the Error of a call helps (rice)

5

Re: Question on creation of reference system to program Access

Tarasios wrote:

How much I can judge - even if to make the "most ideal", "most interactive" help - all the same there will be very big percent of users which will not read it.

+++++
Absolutely waste of time as very small percent of people is capable to write sensible engineering specifications, and those who is then capable to read and understand it in 100 times less...
It is much more productive to do learning video (on the form the button - pushed looked about this form), but it still  talent, at first video a lesson you rewrite time on 10, then still you arrange from different pieces.
Now came to a conclusion that it is better to show in the form of the menu at a point choice at once short sensible , and lessons of the link to show on a site

6

Re: Question on creation of reference system to program Access

13th quarter, is not present there any old tricks. There that, as I described. CHM help works in 2010 and does not work in 2003. Benedict's example.
My idea peeped somewhere in i-not that, to intercept key press F1 and depending on the version on a miscellaneous .
For 2007 and above

SendKeys "{F1}"

for 2003 and more low

Shell "C:\Windows\hh.exe" "Here the full title reference .chm::/ a file .htm#_" "", 3

Somewhere so. But I yet did not check the second part.

7

Re: Question on creation of reference system to program Access

vmag,

wrote:

Absolutely waste of time...

Well I so do not consider. At first wrote the short instruction in Word (it I about itself). And then loaded it in the program of creation  of help (I use program DrExplain, it is possible to use and is free, but in this case on all pictures will go a program title.). 1-2 days and at you quite good CHM help. To super reference system it does not hold out, but a hole can stop up. At me it turns out both the instruction in Word and help in CHM.
I cannot use OnLine help and learning rollers. Such is a reality. Only OffLine.

8

Re: Question on creation of reference system to program Access

Joss;
It is possible here so:
http://www.sql.ru/forum/1182758/pomogit … ?hl=??????

9

Re: Question on creation of reference system to program Access

At you it is described how to replace the help file with something another. I should not replace, it is necessary to me  Access 2003 with CHM help. At me perfectly help forms and supported. And I do not want anything to change towards creation of special forms, reports and units.

10

Re: Question on creation of reference system to program Access

Joss wrote:

13th quarter, is not present there any old tricks. There that, as I described. CHM help works in 2010 and does not work in 2003. Benedict's example.

It worked then in WinXP+Access 2002, it works now in WinXP+Access 2003 and Win7+Access 2007. With singularities, but works. Search for the reason (presence, registration hhctrl.ocx; broad gull Dependency Walker at pushing F1 and etc.).

Joss wrote:

My idea peeped somewhere in i-not that, to intercept key press F1 and depending on the version on a miscellaneous .
For 2007 and above

SendKeys "{F1}"

for 2003 and more low

Shell "C:\Windows\hh.exe" "Here the full title reference .chm::/ a file .htm#_" "", 3

Somewhere so. But I yet did not check the second part.

SendKeys "{F1}" is naive implementation. IMHO, it is better HtmlHelp most to pull. For example, something like .

11

Re: Question on creation of reference system to program Access

Win 7 32 bit and Access 2003 Help CHM is not caused in me. The general help Access is caused.
Win 7 32 bit and Access 2010 32 bit. Help CHM is caused.

12

Re: Question on creation of reference system to program Access

Joss;
All can stupidly in  tire out and to its user in the browser to show?

13

Re: Question on creation of reference system to program Access

vmag wrote:

it is passed...
+++++
Absolutely waste of time as very small percent of people is capable to write sensible engineering specifications, and those who is then capable to read and understand it in 100 times less...
It is much more productive to do learning video (on the form the button - pushed looked about this form), but it still  talent, at first video a lesson you rewrite time on 10, then still you arrange from different pieces.
Now came to a conclusion that it is better to show in the form of the menu at a point choice at once short sensible , and lessons of the link to show on a site

Video - a good thing. But to hang up a call of video or text help on the button of the working form - not always it is useful, sometimes even it can be harmful. For example, the cashier in shop in , queue it is necessary a head, all run is necessary to all - and here unintentionally pushes the help button - and begins on all screen (well all right, a screen part)  help, or the it is more - video smile And the cashier at this time pushed other buttons. Also it is necessary to close now help, to look that had time to push, and where pushings "left in milk", and at connected fiscal is all is fraught...
In general, it is thought to me that it is necessary to learn help TO or After immediate "an output in the field". An example - the pilot of the liner at height of 10 km releases control and starts to study "Control of Aerbusom for teapots" smile
From here - even harmfully to hammer in the screen form (a workplace of the user) buttons of a call of help.
From here - it is thought to me that respected Joss went in cycles on "" a help call directly in the form of the user a little. The best is the enemy of the good...
Clear business that it concerns only to a part of applications, but nevertheless...

14

Re: Question on creation of reference system to program Access

Tarasios wrote:

But to hang up a call of video or text help on the button of the working form - not always it is useful, sometimes even it can be harmful.

It I am figurative, actually at me in the menu two buttons nearby a mode/lesson, either that or that, into a mode entered - all... Work, too by the way retail.

Tarasios wrote:

From here - it is thought to me that respected Joss went in cycles on "" a help call directly in the form of the user a little. The best is the enemy of the good...

So very often happens at hard-working and responsible people, go in cycles, start to grind ready instead of undertaking the new project, old projects already anywhere do not get to, their useful capacity needs to be supported only

15

Re: Question on creation of reference system to program Access

vmag wrote:

it is passed...
It I am figurative, actually at me in the menu two buttons nearby a mode/lesson, either that or that, into a mode entered - all... Work, too by the way retail.
it is passed...
So very often happens at hard-working and responsible people, go in cycles, start to grind ready instead of undertaking the new project, old projects already anywhere do not get to, their useful capacity needs to be supported only

Situations and requirements, , different happen. But at the same time, I think, it is necessary to remember the price of a difference between good and very good, and it is reached by what blood. Whether there is it of that?
About a choice of a mode Operation/training - it is curious, it is necessary to consider.

16

Re: Question on creation of reference system to program Access

That made.
At me not too it is a lot of forms, only 30. From them the cores - 8. Allocated on everyone the button " Info " - analog F1 /
On pushing placed such code

Private Sub btnHelp_Click ()
' version Access> = 2007 is checked
If fnAccessVersion ()> = 12 Then
' if> = 2007
SendKeys "{F1}"
Else
' if <2007
Dim an As String, b As String, c As String
' we define folder path Windows
a = fnBuildPath (fnGetWindowsFolder (), "hh.exe")
' we define a folder path with the help file (a folder with the program)
b = fnBuildPath (CurrentProject. Path, "ONS.CHM")
' we collect a line and we connect a reference topic choice
c = an AND """" AND b AND "::/zadanie_familij_i_dolzhnostej_otvetstvennykh_ispolnitelej.htm#" _
& "IDH_TOPIC_ZADANIE_FAMILIJ_I_DOLZHNOSTEJ_OTVETSTVENNYKH_ISPOLNITELEJ" AND """"
' we open help on the selected section
Shell c
End If
End Sub

Auxiliary routines

Public Function fnAccessVersion () As Single
Dim strversion As String
strversion = SysCmd (acSysCmdAccessVer)
fnAccessVersion = CSng (Val (strversion))
End Function
'---------------------------------------------------------------------------------------
' Procedure: fnBuildPath
' DateTime: 6/13/2006 14:24
' Author: DSonnyh
' Purpose: Creation of a line by merge of arguments and adding in between \(if it is not present)
'---------------------------------------------------------------------------------------
'
Public Function fnBuildPath (strPath As String, strName As String) As String
' strPath - a line, making sense the full or relative directory
' strName - a line, making sense the relative directory name or a file
On Error GoTo fnBuildPath_Error
Dim objFSO As Object
Set objFSO = CreateObject ("Scripting. FileSystemObject")
fnBuildPath = objFSO.BuildPath (strPath, strName)
Set objFSO = Nothing
On Error GoTo 0
Exit Function
fnBuildPath_Error:
MsgBox "Error" AND Err. Number AND "("AND Err. Description AND") in procedure fnBuildPath of Module objFSO"
Set objFSO = Nothing
End Function
'---------------------------------------------------------------------------------------
' Procedure: fnGetWindowsFolder
' DateTime: 10/22/2015 15:43
' Author: DSonnyh
' Purpose: Obtaining of object reference Folder, connected by folder Windows.
'---------------------------------------------------------------------------------------
'
' Assignment. Obtaining of object reference Folder, connected by folder Windows.
' Returns the Objective object reference of type Folder.
' objFSO - the link to created object FileSystemObject
Public Function fnGetWindowsFolder () As String
Dim sResult As String
On Error GoTo fnGetWindowsFolder_Error
Dim objFSO As Object
Set objFSO = CreateObject ("Scripting. FileSystemObject")
sResult = objFSO.GetSpecialFolder (0)
Set objFSO = Nothing
fnGetWindowsFolder = sResult
Exit_fnGetWindowsFolder:
On Error GoTo 0
Exit Function
fnGetWindowsFolder_Error:
MsgBox "Error" AND Err. Number AND "("AND Err. Description AND") in procedure fnGetWindowsFolder of Module mdl_FSO"
Resume Exit_fnGetWindowsFolder
End Function

the Main remark - the way to the help file should be concluded in double quotes, differently - ...

17

Re: Question on creation of reference system to program Access

Yes, to a line of a call of help it is possible to add following parameters
vbNormalFocus - 1 - I recommend
vbHide - 0
vbMaximizedFocus - 3
vbMinimizedFocus - 2
vbMinimizedNoFocus - 6
vbNormalNoFocus - 4
Example:

' we open help on the selected section
Shell c, vbNormalFocus

or

' we open help on the selected section
Shell c, 1