Spell Checker Problem
Feb 7, 2008
Hi firstly I want to say I am not a programmer or anything like that, I know enough about Access to get me by with simple things but after that i get a little stuck so please dont baffle me with loads of technical coding terms :D
Ok..I have a database with a form where the users enter a subject and description. I have a spell checker running on these 2 fields which works fine up to a certain point. If the users goes in, adds a new record, tabs off the field, the spell checker runs, etc then it works fine. If the user then creates a new record and it picks up a spelling mistake in the new record it jumps back to the previous record that was created and spell checks that again.
If you close the form and open it again before creating the second record it is fine. Could anyone possible shed any light on the situation? Below is the code that I am using (found it on the internet somewhere)
Private Sub Description_AfterUpdate()
'If the textbox contains data run the
'Spell Checker after data is entered.
If Len(Me!Description & "") > 0 Then
DoCmd.RunCommand acCmdSpelling
Else
Exit Sub
End If
End Sub
Private Sub Description_BeforeUpdate(Cancel As Integer)
End Sub
Private Sub Subject_AfterUpdate()
'If the textbox contains data run the
'Spell Checker after data is entered.
If Len(Me!Subject & "") > 0 Then
DoCmd.RunCommand acCmdSpelling
Else
Exit Sub
End If
End Sub
View Replies
ADVERTISEMENT
Apr 25, 2005
Hi
I have sendkey "{f7}" on loss focus.
this works great as a spell check but then I get the mesage box that spell check is complete.
How do I stop this box from occuring?
View 2 Replies
View Related
Jan 24, 2006
Hi Guys
Just like to say that I am almost ashamed at how little I know about access, so I guess over the months I will be taking out alot more than I will be putting in! Anyway, I have the following project to do.
Basically it will be necessary to download from an ODBC database on a daily basis, and there will be around 300 products. Each product will be made up of 12 individual fields. What I would like to do is manually key in against these fields from a paper reciept and it will be only shown if the manual input matches what has been downloaded ie Say one of the fields is "Colour", and from the download it says 'Red', therefore if I manually type in any other colour an error message will come up. The basic reasoning behind this is I want access to act as a kind of manual checker from our downloads, with an audit trail of what is being checked. Any typos would be negated as the field would be highlighted, and therefore the inputter can double check any incorrect fields. The current process is done by sight and obviously this means that errors get made as well as no audit on what has been checked.
Anyways thats the theory behind it, can anyone offer me any tips to help me off as I have no idea where to begin! Indeed, is Access suitable for the job? I am presuming that every field will have to have a Vlookup when text is manually keyed in against the download?
Any help is appreciated. Literally any as I am in way over my head!
Regards
Mike
Sorry for the typo in the heading!
View 3 Replies
View Related
Mar 19, 2006
Hi All,
I have a database which contains all historical draws from our Tattslotto system here in Australia.
I want to get some comments on the best way to tackle checking two tables as listed below.
tblDrawn_No 'This is the table with drawn tattslotto numbers so only one row per draw
fldDraw_No
fldDrawn_No_1
fldDrawn_No_2
fldDrawn_No_3
fldDrawn_No_4
fldDrawn_No_5
fldDrawn_No_6
fldDrawn_No_7 'Supplementary number 1
fldDrawn_No_8 'Supplementary number 2
tblTicketNumbers 'This is a table with 24 rows and 6 coloumns, consisting of 6 numbers selected from 1 - 45 for 24 games.
fldRow ' field to describe each row "A - X" on ticket
fldTicketNumber1
fldTicketNumber2
fldTicketNumber3
fldTicketNumber4
fldTicketNumber5
fldTicketNumber6
So I suppose I want to compare the last row of tblDrawn_No, being the current draw with each fldTicketNumber(1-6) game on the ticket of tblTicketNumbers. Sample attached.
I was hoping to display the output on a form somehow?:confused:
Any help would be appreciated.
Robert88
View 4 Replies
View Related
Jun 25, 2007
i'm trying to make a report to print checks
how do i make a query that outputs numbers spelled out??
please help
View 9 Replies
View Related
Aug 25, 2006
We need to enter the string INCL as a data value in one of our tables. When we try to exit the field, Access keeps changing it to INCLUDE. This occurs whether the value is entered via a form or directly in the table. I assume it is doing some type of autocorrect based on th spelling. There is no VBA code associated with this field.
Is there some way to turn this off?
View 2 Replies
View Related
Aug 2, 2005
When I try to do a spell check in a Form by pressing F7 I receive this error:
Can't start the spelling checker because it isn't installed.
How do I get it installed?
Thanks!
View 1 Replies
View Related
Aug 11, 2005
How do you make the spell checker not cycle through all your records when you run it? As it is right now, when a user tries to spell check their entry into the summary block of my form it automatically starts with the first record in the database and goes from there.
This is in Access2003 BTW.
View 2 Replies
View Related
Nov 4, 2005
I have 15 fields beginning with the word Comment. (i.e. comment, comment1, comment2 etc)
What Im trying to do is create a spellcheck command button that will only check these fields and only on the current record.
I've managed to find this piece of code to do the actual check:
With Me.FIELDNAME
.SetFocus
.SelStart = 0
.SelLength = Len(Me.FIELDNAME)
End With
DoCmd.RunCommand acCmdSpelling
Question is, how do I get this piece of code to loop through any field beginning with the word 'comment' and check their spelling?!
Any help would be much appreciated
View 7 Replies
View Related
Mar 20, 2006
I have a subform in datasheet view. I would like to put a button on the mainfor that checks all the subform records for spelling mistakes. Is this possible?
View 3 Replies
View Related
Jul 1, 2015
I'm trying to get a spell check to work on a text box on a form. i've got it popping the spell check window after the box has been updated but i'd prefer it to just highlight the errors in red, rather than pop the spell check box. another problem i'm having is when it's finished spell checking the box it moves the form back to the first record. this is the code i'm using.
Code:
Private Sub txt_notes_AfterUpdate()
If Len(Me!txt_notes & "") > 0 Then
DoCmd.SetWarnings False
DoCmd.RunCommand acCmdSpelling
DoCmd.SetWarnings True
Else
Exit Sub
End If
End Sub
View 6 Replies
View Related
Apr 1, 2015
I have a Access 2010 database running in runtime. What options do I have for spell check? I can bind to a 2010 Word spell check (if it is installed), but could I do a late bind to utilise any other office spell check? Tried to use a .net spell checker dll and get access to call out the text and get returned the errors? Not sure what options I have really...
View 1 Replies
View Related
Apr 10, 2008
Hi everyone and many thanks in advance.
I have configured my Access 2007 DB/app to hide the default ribbons and Options settings so that end-users cannot change the config or perform tasks that would jeopardize the integrity of the data. One of the other requirements on this project is to allow the end-user to launch the Spell Check feature.
It was simple enough to launch Spell Check from a button on a form. The problem lies in that the Spell Check feature has an "Options" button that serves as a point of entry to the Access Options that I'm trying to prevent the user from seeing.
Can anyone tell me how to hide or disable the Options button in Spell Check? I fear that this is not possible and I will have to choose between Spell Check and ensuring data integrity.
Many thanks,
Dominick:confused:
View 1 Replies
View Related
Sep 16, 2013
When distributing a program using 2010 runtime, I find that the spell check doesn't work. Is there a spell-check .dll or is there anyway I can get a spell checker?I have several memo fields with long report-type data entry which is being keyed by mutants. Spell checking is essential to get an intelligible report.
View 1 Replies
View Related
Jun 28, 2013
If you look at the attachment in access settings it says it is set how to auto correct and "INDICATE SPELLING".
in my forms/tables/queries... it will not bring up spelling mistakes or the sort.
View 2 Replies
View Related