Search results for query: *

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

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

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

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.

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