Search results for query: *

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...

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

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...

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...

Greetings, I need a code or validation rule that will allow the user to include multiple hyperlink/website entries in a field. For example: "www.yahoo.com; www.msn.com; www.lycos.com" My field properties has it set-up to auto hyperlink their entries (e.g.: Yes on...

Greetings, Does anyone have a list or a good website that has a list of all Access VB code identifiers (i.e: SetFocus, DoCmd, etc.) and their descriptions/uses? Thanx!!!

Greetings, Does anyone have any reference site(s) that has a list of all existing E-mail extensions? (i.e.: .com, .net, .gov, .org, etc.) Much obliged... thanx!

Greetings all, We're trying to set-up a code for an E-mail field where the user cannot leave the field unless they place the "@" symbol. Then, have a msg box that indicates that the e-mail is invalid and it locks them in that field until they correct the e-mail address. I'll...

Greetings, We're trying to set-up a validation rule for an E-mail field where the user cannot leave the field unless they place the "@" symbol. Just trying to avoid as much room for error as possible. What would be the validation rule so that once they input the e-mail address, if...

What input mask character is utilized to make the entry always start from LEFT TO RIGHT? The "!" makes it go from right to left. So what do we need to use for LEFT TO RIGHT? Please help! Thanx!!!

When creating the list of items to put in a look-up list (via the Wizard), it says we are only allowed and limited to 20 entries. Is there any way to bypass that and make a bigger list, like 50 entries per se? Thanx!!! ~LeiDBug007

Currently, no input mask in properties. Validation Rule entered in properties is: - Like "LLLL000000" Validation Text entered in properties is: - Please enter the complete file number. When activating in data sheet view, when user enters INCORRECT information, validation text...