Spell-check Entire Database 1

[darkmindx]

Hi,

Is it possible to spell-check the entire database using something along the lines of:

    If Len(Me!txtBookReview & "") > 0 Then
        DoCmd.RunCommand acCmdSpelling
            Else
        Exit Sub
    End If

Thanks

 

[philcon]

Hi there, please find below a q&d way of doing this (not for purists I know, but I'm not to clever with arrays et al.)

Create a form for the table you are spell checking, set up a for/next loop (number of records in table) use your code followed by a goto next record command.

let me know if this helps

Phil

 

[darkmindx]

Hi Phil,

I am currently using the following code:

Private Sub Command32_Click()
For qryQuery1 = 1 To 99
    If Len(Me!txtBookReview & "") > 0 Then
        DoCmd.RunCommand acCmdSpelling
            Else
        Exit Sub
    End If
Next qryQuery1
End Sub

And it is working great! However, I am not liking that I have to specify how many items are in that query. Is there a code or something that can do that automatically and input the numbers into the code by itself?


Thanks

 

[darkmindx]

When I run the above code, it works fine for a few items, but then I get an error that the program has encountered a problem and must close!

Why do you think I am getting this error?


Thanks

 

[darkmindx]

Does anyone know why I might be getting the error mentioned above?


Thanks

 

[Remou]

Hi
I put this in a form:

Private Sub Command32_Click()
    DoCmd.RunCommand acCmdSpelling
End Sub

and all my records were spell checked, with no errors. Any use?

 

[Blorf]

Hi. Can you place a break point and see what is in the record that makes it bomb out before it actually bombs out? Maybe you will see something that way.

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

http://mysite.verizon.net/res0n4sv/