Search results

Is there any other way to automatically tab to the next field after value has been entered ?

What is the alternative (if any) ?

I have a form with text boxes. I want to automatically tab through when a single value is entered. I have 'Auto Tab' set to 'Yes' for the first three (3) text boxes (just for testing) in the form. The table definition for each field is set to 'Single' for 'Field Size', 'General Number' for...

Moke123, Are you saying I should continue my validation process in the 'Button' 'Event Procedure' ?

Can anyone tell me why the below code works in my 'Event Procedure' code behind a 'Button' and not when I move the code to 'Event Procedure' for 'Before Update' ? When I tab pass an empty (blank) text boxes, it does not produce the pop-up error message. The code works with the 'Button' 'Event...

Uncle Gizmo, Thank you for the thorough explanation ! ! ! I though Pat Hartman was referring 'DLookup'. During my investigation, I did create code to test for '0' or '-1'. I have to check to see if I still have the code in place. Also, as suggested, I did try to do my testing for blank text...

Pat Hartman, If you're talking about 'DLookup'. I'm not using it. What are you talking about ? I'm just referring to fields in the 'Test' table.

Uncle Gizmo, Pat Hartman, I changed the 'Data Type' from 'Yes/No' to 'Short Text'. The default value of 'No' is no longer appearing when tabbing through the form. I'll work on moving the validation code to the 'Before Update' 'Event Procedure'. Thank you for the solutions to this error ! ! !

OK, I copied and stripped down my database. I'm getting the same results as soon as I enter data and tab down. The code for 'After Update' should not cause the problem. Uncle Gizmo, 'Option Group' ? 'Test' database uploaded.

ridders, The combo box and table both have no value.

I have a 'Yes/No' field in a table with no value for the 'Default Value' of the table definition. This field is bounded to a combo box of a form. When tabbing through the form the combo box insert 'No' automatically. If I blank out the value 'No', it comes back. I can override it with 'Yes'...

Pat Hartman/jdraw, Sorry for not responding ! ! ! I've off the forum for a few days. I ended up creating multiple queries and using a macro to call the queries. Thanks for following up ! ! !

pbaldy,, OK, got it . . . I have my fishing rod. Any takers ?

Arnelgp, I did changed 'anotherTable' to another table name.

Arnelgp, Did not work, I added 'From Administration', but it did fix the problem. INSERT INTO anotherTable ( [Name], [Survey_Taker_Telephone_Number], [Type], [Type_Score], [Contact_Me] ) (SELECT Leadership.Name, Leadership.Survey_Taker_Telephone_Number, Leadership.Type, Leadership.Type_Score...

NauticalGent, What happened . . .

pbaldy, Fish ?

How can I insert the below "Select" queries results (that works) in to one (1) table. SELECT Leadership.Name, Leadership.Survey_Taker_Telephone_Number, Leadership.Type, Leadership.Type_Score, Leadership.Contact_Me FROM Leadership Union SELECT Administration.Name...

What I'm doing is using a form for a survey. After the user answers the last question on the form (survey), press a button, his/her record is saved to a table that has all records (individual's responses). I want to capture the firstname, middlename, and lastname on the form and pass it to a...

OK,I found out that I can get the information in VBA. I guest I have to somehow (through VBA and SQL) insert the form information into a table via SQL query in VBA (via DoCmd command). Do you think this is the solution. I originally wanted to pass the firstname, middilename, and lastname into...