Run Time Access, Spell Checker (A2K, SP1)

Topic

New Reply

I am creating an Access application that I will want to secure and distribute to many inhouse users. Are there any alternatives to the MS Application Developer package to create a version of the databases that can be run without Access loaded on the user PC?

What options are there for providing spell checker functionality for the many text fields the users have to fill in?

Reply | Quote

Replies

You have to have the Developer Edition to legally provide a copy of the runtime to others. You don’t have to use the Setup Wizard included with the D.E., however. There are some 3rd party Installation programs available.

Access will use whatever spell checker has been identified to Windows. I would use it sparingly, though, as it can be a real annoyance to users and is not particularly useful in many circumstances, especially name and address fields.

Reply | Quote

I usually give the users a button or buttons to activate spellcheck rather than forcing it on them. Here’s a code routine that will cause a spellcheck:

Public Function SpellCheck(Optional blnAll As Boolean)
  'created by Charlotte Foust 2/10/2000 
  On Error Resume Next
  'Select the current record or all records
   If Not blnAll Then
    DoCmd.RunCommand acCmdSelectRecord
  Else
    DoCmd.RunCommand acCmdSelectAllRecords
  End If 'Not blnAll 

  'run the spellcheck
  DoCmd.RunCommand acCmdSpelling
End Function  'SpellCheck(Optional blnAll As Boolean)

Reply | Quote

Even as you typed it Charlotte I imagine a frightening thought running through your head “That idiot is going to try this isn’t he?).

I assume, hopefully correctly, that this code would go in the ‘OnClick’ event procedure?

If so, I have done this and faithfully reproduced word for word what you have written, I have checked it about 5 times and even come back here and copied and pasted it into the event procedure. But sadly when I click my button, nothing.

I have read here many times that you should use the Debug and Compile feature so I have done that and get a Compile Error “Member already exists in an object Module from which this object Module derives”.

Sorry to try your patience but please tell me what this Country Bumpkin has done wrong, thanks.

Steve

Reply | Quote

I posted it so you could try it out, but you didn’t say whether you were trying to spellcheck a single field, a record, or a whole recordset, so I gave you the routine for one or more records.

Paste the routine into your form’s module. Then call it by putting the following in the OnClick event procedure of your button:

SpellCheck False

… unless, of course, you wanted to spell check the entire recordset, then you’d use SpellCheck True.

If that doesn’t work, then something else is wrong, because it works in my forms.

Reply | Quote