Replies

Just a quick FYI. The Microsoft Common Controls Reference can cause a problem with Format(), Mid(), Left(), Right(), and other functions, even if it is not marked as MISSING. If you can’t figure it out, I would try unchecking it, close the dialog, reopen the References dialog, then BROWSE to the Windows/System folder where you can select Comctl32.ocx and then close the dialog, SAVE and try again.

It’s worked for me in the past and I usually look for that one first if I have problems with certain functions.

BL
hth

You might try HelpScribble. You can download a fully functioning demo version at http://www.helpscribble.com/ and the registered version is only $99. It is really cool, I hated trying to wade through the directions for creating a help file using Microsoft tools and when I got this I looked through the documentation and then created a help file on my own within minutes!

The program will create regular compiled help AND HTML help files as well.

Hope that helps!

Bob Larson

I am using Help Scribble and I think it is one of the easiest things to use to create help files! It will automatically assign context id numbers, entering the data is easy with no need to
worry about .rtf files or creating footnotes, etc. The best thing to do is to read the HelpScribble help file (created in HelpScribble itself) and learn how to use the program. It only took
me a few minutes to read through enough to create a simple help file for an Access database I was working on. I even like the SHG editor that makes adding hotspots to graphics
very easy.

You just have to have a help compiler somewhere on your computer. HelpScribble will then do the work of compiling (easier than the HTML Help Workshop or trying to manually do
help files). Also, as to where to put the file, you can put the compiled .hlp file anywhere you want, although the same folder as the .mdb file is probably best. Then, say you want to
access your help file from a form, you just place the directory path in the “HELP FILE” property for a form, and then for each form or object on a form you put the context id number that
you want to come up in the “HELP CONTEXT ID” property of the form or object.

Works great! I was blown away at how quickly and easily I can make help files. Our company is going to be purchasing a license for it so I can use it for all of our databases.

If you need more help in using the program, feel free to email me directly and I will do my best (with the little free time I have) to help.

Bob Larson
mailto:accessbob@hotmail.com

This may not be the best way, but you could use If Then Else statements like this:

If IsNull(txtFrom) Then
txtFrom.Value = #01/01/1901#
End If

If IsNull(txtTo) Then
txtTo.Value = Date
End If

You can set the From date to whatever would be the earliest possible date or just use the 1901 date and then Date would give all up until today.

Bob Larson