Search results

Is there something inherently wrong with check boxes and option buttons?

The location of the message box and the Exit Sub were in middle of the loop so it didn't continue after the first one.

The only thing is the borders of acCheckBox and acOptionButton (when added to the case statment) aren't affected. Any ideas?

I sorted it out. Here is the working code. ' Ensure all fields are filled For Each ctl In Me.Controls Select Case ctl.ControlType Case acTextBox, acComboBox, acListBox, acCheckBox If Len(Nz(ctl.Value, vbNullString)) = 0 Then...

Yes it is. Thanks again.

Are you waiting for a response?

One more problem... I want to change the border of the empty controls. I tried this but no changes are made to the controls. ' Ensure all fields are filled For Each ctl In Me.Controls Select Case ctl.ControlType Case acTextBox, acComboBox, acListBox, acCheckBox...

See post #6 and #10.

Thank You.

Will the above work with all types of controls? will Len() and Nz() actually work for option groups, check boxes and radio buttons?

Thanks for the pointers. How can I make the error message user friendly, I know I can capture the error but how do I determine what control is null? Is that to suggest that this If ctl.Value = "" Then should be this If ctl.Value = Null Then Or is that method one that will not work? btw, why...

Hello all, I'm using DAO to insert data (entered in unbound controls on a unbound form) into a table. Before running the code to insert the the data I must check that all fields on the form are not empty. I don't want to Set the Required property of the fields to Yes since the error message...

The same thing happened when I had bound the form to the table (and added a textbox (YourChqNum) to hold the cheque numbers.

I added your code to a command button and it throws a runtime error 2105; You can't go to the specified record. Attached you'll find my sample.

Thank you. So far so good.

I have 3 tables: City: ID (PK) City Neighborhood: ID (Number, indexed) Neighborhood Street: ID Street I want to create relationships so the city table will expand to show all neighborhoods in the selected city, and the neighborhood table (which shows when a record in the City table is...

I understood the concept. The problem is I want to add, lets say, some 30 cheques per click.

John Big Booty, Thanks for your response. Using your suggested method only adds one record per on current firing. Ideally the number of records and the seed number will be entered in unbound text boxes on a form, and on a click of a button the records will be added to the table and displayed...

Our organization has a db used among other things to track all checks (cheques) given to employees and suppliers. All check information (bank info, and check numbers) is entered by hand in a form in datasheet view, that seems ridicules because the checks are numbered sequentially. It would make...

You have to set the ColumnCount property to 2.