Search results for query: *

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

TO: Omega36 Hi Omega... I am getting a compile error "Next without For". It highlights the "Next" on "Next ctl" at the end? Thanx! ~LeiDBug007

Aloha, We've got a form that has 7 fields, and a close command button at the bottom. We need a code that will prevent the user from closing the form (clicking the close button) when there are null values in any fields. We need all fields filled out, and none left blank. And of course, a...

Greetings! I know it's something really simple but we seem to be drawing a blank......? You know how Access has their own default gray message boxes when certain functions are done..... Well.... we've got a field that we marked as "Required" in the tables properties so that the user...

Have a subform that has a notes field where the user can enter comments on a specific record/file within our MAIN form. However, when we enter new records in the notes subform the entries disappear when we change the record/file in the MAIN form. But, those records entered in the subform ARE...

Ever seen this error message? "You can't assign a value to this object...The object may be a control on a read-only form...The object may be on a form that is open in Design view...The value may be too large for this field." We keep getting it when trying to enter information in a...