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!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Travis33

    help with finding part of a string

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

    help with finding part of a string

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

    find part of a record Help

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

    searching a string Help

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

    DataBase Help

    Thank You so much braindead2 it worked great Travis
  6. Travis33

    DataBase Help

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

    DataBase Help

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

    DataBase Help

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

    DataBase Help

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

    Database help

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

    finding a record in a table

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

    finding a record in a table

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

    finding a record in a table

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

    finding a record in a table

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

    Help with finding a record in a table

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

    changing properties on a form for another form

    I have a database that I need to change the properties of command buttons based on the input of a user. I have a main form that pops up when the database is open and asks the user to enter a password. Based on that password the user will have rights to other forms. What code do I need to...
  17. Travis33

    Changing properties of a form from another form

    I have a database that I need to change the properties of command buttons based on the input of a user. I have a main form that pops up when the database is open and asks the user to enter a password. Based on that password the user will have rights to other forms. What code do I need to...
  18. Travis33

    changing command button properties on a form from another form

    I have a database that I need to change the properties of command buttons based on the input of a user. I have a main form that pops up when the database is open and asks the user to enter a password. Based on that password the user will have rights to other forms. What code do I need to...
  19. Travis33

    calling a form within a form

    I have a database that I need to change the properties of command buttons based on the input of a user. I have a main form that pops up when the database is open and asks the user to enter a password. Based on that password the user will have rights to other forms. What code do I need to...
  20. Travis33

    "ARGUMENT NOT OPTIONAL" Help

    I HAVE THIS CODE BELOW THAT i AM TRYING TO HAVE MY FORM WHEN I ENTER IN NUMBERS INTO A COMBO BOX SCROLL THROUGH THE RECORDS THAT MATCH PART OR ALL OF THE STRING. ********************************************************** Dim db As database, rst As Recordset, strsql As String Set db = CurrentDb...

Part and Inventory Search

Back
Top