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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.