Spell Checker Causes error and form buttons to break

[AussieGal]

I have no idea what is going on, but a form I have that has a spell checker button on it, seems to occasionally cause the attached error message ...(The expression on click you entered as the event property setting produced the following error: Object or class does not support the set of event....). After this happens no button on the form will work. This is happening on a pop up form that allows for users to enter details about an entry from a previous form. There are some text box's on this form which are populated from the previous form that I don't want spell checked or changed. I just want it to spell check the 4 memo box's which users are entering details about. I believe what is happening when spell check button is pressed it sometimes seems to try and check the auto populated at the top and not the memo box's and something gets crossed. It works for a while and then when the message occurs nothing will work, but going into design view and playing around somehow seems to fix it for a while and then a day later the same thing happens. I am not sure what to check as I don't know what or why this is happening. I am hoping someone can provide an answer. I hate it when things work sometimes.

The code I am using on this form is:

Option Compare Database
Option ExplicitPrivate Sub cmdNoteComplete_Click()
Me.PNComplete = Now()
DoCmd.Close
End Sub
Private Sub cmdNoteIncomplete_Click()
Me.PNStarted = Now()
DoCmd.Close
End Sub
Private Sub Command37_Click()
DoCmd.RunCommand acCmdSpelling
End Sub

The code that I am using from my other form that brings this form up is as follows:

Private Sub Command65_Click()
    Dim intID As Integer
    intID = Me.SessionID
    DoCmd.OpenForm "frmProgressNotes", , , "[DSLIDNumber]=" & [SessionID], , acDialog
    Me.Requery
    With Me.RecordsetClone
    .FindFirst "SessionID=" & intID
    Me.Bookmark = .Bookmark
End With

[June7]

If you want to limit the spellcheck to those 4 controls and not the entire record, this suggests a method http://www.accessmonster.com/Uwe/For...ell-check-form

[AussieGal]

Hi, I looked at the code, yet it seems to only deal with selecting either 1 field or the entire record. I was just wanting to select 4 fields from the current record. Do you believe this is what is causing all the buttons to produce this error message I am getting?

[June7]

I've never done spell checker code but that is my best guess.

[AussieGal]

It really doesn't make any sense. The fix I am using at the moment is to go into design view, look at the code that that runs the spellcheck button, close the form, when asked to save changed (even though none were made) I say yes, and the buttons again work. If I don't do this, all buttons give that error message. It just dones't make sense to me.

[June7]

I know but don't have enough experience with the feature to give better suggestion. If you want to provide db for analysis, follow instructions at bottom of my post.

What is purpose of the two procedures with DoCmd.Close line? I know they are populating fields but why? Try:

DoCmd.Close acForm, Me.Name, acSaveNo

[AussieGal]

Hi,

I have attached the database with data removed, and added some simple data in. Unfortunately I cannot get it to produce the error on this test version (my users seem great at breaking it on the real verison). To get to the form, go to SErvice Providers button, then Enter daily service logs (DSL) botton and enter 1234 as the pasword. This will get you to the main form the staff are entering. if you click the form button (just after the c/min field, it will pop up with the form that is breaking when sometimes when spell check is pressed. I do have mulitple users using this database and have found it hard to see how they are breaking it. I do notice however that the name field is somehow getting focus when the spell check is being pressed when it breaks, yet this doesn't always happen. Hoping for some resolve. Thank you for taking the time.

[June7]

Sorry, won't break for me.

[AussieGal]

I have attached a copy of the front end that is showing the error message that appears once it is broken. Like I said all i need to do is view the code and it seems to fix it, but they keep breaking it. I have noticed that it is sometimes creating another record in the progress notes forms and I am wanting for this not to happen. They are meant to open the progress notes, enter only 1 and then close it. I don't want them to be able to create 2 records here which I believe it is what it is doing. The users see all their notes, use the spell checker and then it seems to continue onto the next record which really shouldn't exist. I only want one record showing that links to this account. Not sure what to do here

[June7]

I can't get to the ribbon. Even holding the shift key doesn't override settings that disable the ribbon. Getting to the VBA editor means I have to find a form with an [Event Procedure] and click the ellipses.

If you don't want to allow moving to another record, set the form Cycle property to CurrentRecord.

[AussieGal]

Oh sorry I forgot to turn off the security on it. I think I have it worked out at the moment. I have the code working to only check the 4 memo box's instead of all fields on the form, and yes I forgot about the current record property which I have now correctly set. I sent the updated database out to the users. I guess tomorrow I will find out if they found a new way to break it. Thank you kindly for your help it is appreciated !