Search results

The below code works when I have a record with an Email_Address value. It fails when the value is null / blank. I've tried variations of If Not IsNull, IsBlank, etc.... Code Tags Added by UG Please use Code Tags when posting VBA Code Please read this for further information:-...

Dust in the wind.

So this doesn't work. Did I misinterprete what you recommended I test? Fails to compile on .setfocus (invalid or unqualified reference) Public Function SpellChecker(strText As String) As Boolean On Error GoTo Err_SpellChecker If Trim(strText & " ") <> "" Then 'Handles...

So clear the value, then the delete shows up.

Is there a way to delete the value in the field from the Spell Checker form? Let's say my spelling is checking multiple fields and I get to this result. None of the suggestions are right, I'd like to just delete that word, and continue to spell check the remainder of the fields. There isn't...

I don't quite understand what this means.

@Micron Thank you for your persistence. Tmrw, I'm going to continue to troubleshoot and see if this fixes the issue with the base database. I hope this was the root cause that triggered the request for support.

It's working.

I'm down to a main form with primary key, last and first name and one subform with a text field. Only one field on the subform doing spell checking. I pulled most of the code off the forms. Maybe I'm down to a small enough subset to troubleshoot? In the attached, open Contacts and then move...

Continuing to reduce.

I'm going to keep trying to reduce the code down to try and get to the essentials. Compact on close was checked. I unchecked for the next update. Removed the Navigation form, most of the fields on the Contacts form. Removed all but one subform (since having zero subforms stops the issue...

Looks like we're talking past each other. I think Ive only coded the spelling to happen on specific text fields and definitely not on the organization field which is a combo box.

The Isblank is a public function. It appears that having a no record value on a sub data sheet triggers it. Nothing to do with spelling. If try, why is the question we're trying to answer. The position title field is getting spelled checked because people would be typing in their own values...

A great rhetorical question. When you figure out why it's happening we're all ears.

I took the complete class module (FindASYouTypeCombo) from v11 and put it into the database that we're troubleshooting on the other thread. 13 Type mismatch when I allow the following to run on form load. faytManagerNameID.InitalizeFilterCombo Me.Manager_Name_ID, , anywhereinstring, True I...

Thought I had something..... corrected database uploaded …. but still erroring. For this version, it appears to only trigger when moving from record 1 to record 2. The different between them is record 1 has a value on the Experience subform, while record 2 doesn't.

I hope I wasn't the cause of your frustration.

An updated version, still broke but the other one was missing a lookup table for City, State. To see the issue live. Open the database > click the Contacts button > click with you mouse from one record to another. The error implies that it's trying to spellcheck a field and there isn't a...

Went thru the vba code and put things in A-Z order for the Contact form and the subforms. Removed the 'ghost' Events - where there was something shows as an [Event Procedure] but nothing was supposed to be there. Maybe it helps with readability. Still having the same issue where the...

I'm closing this one out. I got some helpful code suggestions for handling value changes during spell checking but the root cause of the issue doesn't appear to be spelling but some other poorly coded element of my database by your's truly. The previous posting points to where the conversation...