Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Apr 2001
    Posts
    122
    Thanks
    7
    Thanked 0 Times in 0 Posts

    Run Time Access, Spell Checker (A2K, SP1)

    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?

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Run Time Access, Spell Checker (A2K, SP1)

    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.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Run Time Access, Spell Checker (A2K, SP1)

    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:

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

    <font color=448800>'run the spellcheck</font color=448800>
    DoCmd.RunCommand acCmdSpelling
    End Function <font color=448800> 'SpellCheck(Optional blnAll As Boolean)</font color=448800></pre>

    Charlotte

  4. #4
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Run Time Access, Spell Checker (A2K, SP1)

    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
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Run Time Access, Spell Checker (A2K, SP1)

    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.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •