Recent content by Travis33

I have a combo box that finds the record that I type in this is the code I placed in the after update event dim rs as object set rs = me.recordset.clone rs.findfirst "[Item number] = ' "&me! [combo2]& "'" me.bookmark = rs.bookmark This code works fine but I want to...

I have a combo box that finds the record that I type in this is the code I placed in the after update event dim rs as object set rs = me.recordset.clone rs.findfirst "[Item number] = ' "&me! [combo2]& "'" me.bookmark = rs.bookmark This code works fine but I want to...

I have a combo box that finds the record that I type in this is the code I placed in the after update event dim rs as object set rs = me.recordset.clone rs.findfirst "[Item number] = ' "&me! [combo2]& "'" me.bookmark = rs.bookmark This code works fine but I want to...

I have a combo box that finds the record that I type in this is the code I placed in the after update event dim rs as object set rs = me.recordset.clone rs.findfirst "[Item number] = ' "&me! [combo2]& "'" me.bookmark = rs.bookmark This code works fine but I want to...

Thank You so much braindead2 it worked great Travis

Kathryn THank You so much again for helping me. THe field names are Auto number = auto number = number date = date time = time string = string The auto number I would like generated the time and date I would like taken from the computer. and the string i would like to be a random string...

I have a database with one table and one form. I am building it to test the search feature when you have 20,000+ records. I have five fields(auto number,number,date,time,string) I have a command button that I want to be able to click and it writes 20 new records to the table. I want them to...

I have a database with one table and one form. I am building it to test the search feature when you have 20,000+ records. I have five fields(auto number,number,date,time,string) I have a command button that I want to be able to click and it writes 20 new records to the table. I want them to...

I have a database with one table and one form. I am building it to test the search feature when you have 20,000+ records. I have five fields(auto number,number,date,time,string) I have a command button that I want to be able to click and it writes 20 new records to the table. I want them to...

I have a database with one table and one form. I am building it to test the search feature when you have 20,000+ records. I have five fields(auto number,number,date,time,string) I have a command button that I want to be able to click and it writes 20 new records to the table. I want them to...

Thank You all for your Help, At this time I am only checking for passwords. I will be checking usernames too but for now I am seeing if it will work. I have a Table called "Users" In that Table I have recordset for password,username,forms,reports,admin. The last three are marked...

I have a database where a user inputs a password and I check the table record to see if it is there to grant them access to the forms. This is the code I am using but it only finds the first record in the table. I want it to search the whole column. Dim db As Database, rs As Recordset Set db...

I have a database where a user inputs a password and I check the table record to see if it is there to grant them access to the forms. This is the code I am using but it only finds the first record in the table. I want it to search the whole column. Dim db As Database, rs As Recordset Set db...

I have a database where a user inputs a password and I check the table record to see if it is there to grant them access to the forms. This is the code I am using but it only finds the first record in the table. I want it to search the whole column. Dim db As Database, rs As Recordset Set db...

I have a database where a user inputs a password and I check the table record to see if it is there to grant them access to the forms. This is the code I am using but it only finds the first record in the table. I want it to search the whole column. Dim db As Database, rs As Recordset Set db...