Search results

Is Null OR Like "###########" Would this work in my validation rule?

I would like to go simple and use the input mask. It's been a while since I used one, for text how would I enter it in the table properties (i.e.: should I list out 00000000000, or use another character for text?) Is there a way to have the input mask be zero or 11 characters? but nothing in...

Is there a way to force the entries to be a specific length? I'm thinking that if I can require that the CID be 11 digits (bytes/characters - no less, no more) then I can avoid having incomplete entries. Is there a way to enforce a character length?

Here ya go...

I will have to accept it and start working on a redesign of my form. I changed all the controls to Unbound, where do I go from here?

The form actually serveds 2 puproses 1) Search table for records based on the selection made in the 3 drop-down lists, and 2) [main function] Create records based off the data selected in the 3 drop-down lists. I can not find the Continuous Form Wizard, I think it is because I am using Access...

...also... I want to make a continuous form for adding multiple records at once. Would you be able to direct me in performing this correctly? Any assistance is greatly appreciated.

With the unbound controls not all of the data is being saved. I assumed that it was. I have some queries in between the click of the button and the actual saving of the record. To be specific (SQL Attached): DoCmd.RunCommand acCmdSaveRecord DoCmd.OpenQuery "UpdateMasterCreativeID"...

I have a form that when the end user is searching for previous records it creates an erroneous record based off of the search criteria. I want it to create a record ONLY when the "Enter" button is pressed. Is there a way to limit the form to creating records only when ENTER is clicked on?

I'll give it a whirl and provide feedback.

Glad to have vbaInet and Uncle gizmo in on the conversation.

Stand alone wizard form to walk them through the steps sounuds good. How would that work?

The main form allows the user to enter one record at a time. There are some users who have to multiple entries and would like a form to enter those multiple entries all at once. Is this possible?

I recently received help from AWF and couldn't be happier with the outcome. Off of the same dB I would like to create a subform which will allow me to enter multiple records to the main table, the one attached to the main form. Any ideas on how to go about creating one?

[SOLVED] Option buttons (2) to control Combo box Yes I do. Thanks so much for clearing this up...I owe you a beer (pint)!:D

Sorry,...the code you supplied is not making the switch for me. It allows me to select Option1, and I get the values in the drop-dosn combo box. When I select Option2 Option one stays selected. If I try to switch to Option1 then the values for Option2 remain in the drop-down combo. here is...

I have 2 Option buttons that I want to use to control a combo box. If I select Option1 then I want it to pull from one table for the drop-down choices. If I select Option2 I want it to pull from a different table. The Option buttons and combo box are all on the same form. Thanks in advance for...

SOLVED Form not Cooperating

Outstanding,..Thanks so much.

Correct. CCode ComboBox relies on the choice made in the option buttons. Option1 (Automated) pulls from the table [CCode] and Option2 (CCAH) pulls from table [CCAH].