Recent content by LeiDBug007

Wow, good catch! You're the only one that's been able to catch my handle... and I've had that handle for everything for more than 5 years now! I guess you would have to have some kind of heavy exposure to the island to catch it. I'm actually partial... most of my mom's family is in the island...

What made you ask if I was Hawaiian? And...nothing wrong with convincing family members to live in paradise! :-) In any case... why did YOU leave? Gotta be a good reason to leave paradise...

Hi Bob, looks like that's the only way to go. I set it up like you suggested and it seems to do the job. It's an extra step to the process but... it works! That's all I care about. Thanx so much for taking the time in responding to my problem. Wish me luck! :-) ~LeiDBug007

Greetings experts! I've got a text field called "Rule Number". And basically in this field, the rule# is entered in sequence...1A, 1B, 1C...10A, 10B, 10C... So far, I have entered the records in order by rule number, however... it's sorting it weird. My records in my table & form keep...

Can anybody please give me a list of reasons why we would get the "#Name?" error message on fields? Can't figure this out...? Keep seeing it in various fields in different forms. Thanx!!! ~LeiDBug007

Greetings Experts, We've got a combo box field (cfCeaseDesistLtrMailed) that has a "YES/NO" choice for the user to indicate if a particular letter was sent. Right after that field, we've got a date field (cfDateMailed) where the user has to enter the date the letter was sent. I want to run...

Aloha Foolio12/Pete, Your added string of code worked! Thanx so much for all the time you spent with this. All systems go! ~This is LeiDBug007, over and out...w/this problem that is.. P.S. In'eresting handle... ;-)

Greetings Experts, We've got a memo field that users enter their notes on each case. We would like the spellcheck feature/command to run (when needed) on misspelled words. Your expertise is much needed, thanx! ~LeiDBug007

TO JDEMMER: As requested, here is the exact code for the On Click procedure for the CLOSE button... ******************************************************** Private Sub Command13_Click() Dim i As Integer For i = 0 To Controls.Count - 1 If TypeOf Controls(i) Is TextBox Or _...

TO EDSKI: Thanx for the suggestion on the "required property". That's actually our initial step, however, we cannot mark any of the fields in this table as in some occasions in a different form, it is NOT a required field. Therefore, marking the fields "required-yes" in the table is not an...

Hi Mike, Yep, DoCmd.Close. It's basically the default code Access gives when you create a close command button. We haven't done anything to it. Here's the code: **************************************** Private Sub Command13_Click() On Error GoTo Err_Command13_Click DoCmd.Close...

Hi Mike, Sorry, still doing the same... click close button...message box... click OK on message box... closes the form?! I copied your exact code in our forms property, On Unload procedure. Should we change the close button On Click procedure maybe? I dunno anymore... sorry for bothering...

Hi mgolla, Tried your code but still lets me close the form?! I loaded it in the "On Unload" procedure, and tested the form. Left a few fields empty (null)... click on the close button...message box popped...said OK to message box, then it closes the form??! ~LeiDBug

Greetings Experts, We’ve got a form that has 7 fields, and a close command button at the bottom. We want to ensure that the user cannot leave the form when there are null values in any of the fields. We currently have a code that works perfectly and prevents the user from creating a new...

To grnzbra, Mind sharing me the code for your suggestion? Thanx! ~LeiDBug007