Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Conditional Statements
I tried it as "or" insead of "and"...this returns every record found in the loop - in this case 20 records. I'm looping thru the form for values (only displaying one below to save space) then writing to the database if one of three fields contain data. Here's some code: 'Loop for values For x... -
Conditional Statements
Hey all, I have 3 fields on a form. If any of theses fields contain a value then I want to write a record to a database. I've got all the logic down to write to the database, but I'm having problems with a complicated IF Then statement. The three fields are stored in variables - strNewPay... -
Noob Needs Assistance
Thanks for the replies. My only concern with the IF Then statement using the Ubound function is that I plan to have up to 50 fields on the form (SSN1-SSN50) and the records being returned could vary from 0-50. I would have to write many IF Then statements to cover all the possibilites. I was... -
Noob Needs Assistance
Thanks PHV, I'm going to have a large number of fields for SSN and the records being returned could be anywhere from 1 to 50. I'm thinking ubound in some sort of Loop might work but not exactly sure how to accomplish this. -
Noob Needs Assistance
Hey All, I'm using a Form Designer (FormFlow99) to design a form. I'm using ADO to connect to an Oracle Database - that part is working just fine. My issue is that I have a fixed number of textboxes drawn onto the form and a varying amout of records being returned. If there are less records...
