Hello everyone...
I'm developing a project with with some field need to be filled with the users
(ie emp ID, emp name, case ref, amount, processing date and status) in excel vba userform.
I'm using msaccess 2003 as a backend
Same fields are used in access table (ie emp_ID, emp_name, caseref, vdate and vstatus) all are text fields...
Userform controls
Emp ID - txtempid
Emp name - txtempname
Case ref - txtcaseref
Amount - txtamount
Processing date - txtdate
Status - txtstatus
Save - cmdsave
Find - cmdfind
My query is to find a record by using case ref number from the access table
Every time I press the find button it should populate the other result into the relevant text boxes for that particular case ref number.
Caseref field is not a primary key set, it will contain the repeated number with different other details
Example
In my table the case ref entered two times with different different other fields
Empid1 - empname1 - caseref1 - 10000 - 12/08/2015
Empid2 - empname2 - caseref1 - 5000 - 13/09/2014
Empid3 - empname3 - caseref1 - 900 - 09/12/2015
I'm developing a project with with some field need to be filled with the users
(ie emp ID, emp name, case ref, amount, processing date and status) in excel vba userform.
I'm using msaccess 2003 as a backend
Same fields are used in access table (ie emp_ID, emp_name, caseref, vdate and vstatus) all are text fields...
Userform controls
Emp ID - txtempid
Emp name - txtempname
Case ref - txtcaseref
Amount - txtamount
Processing date - txtdate
Status - txtstatus
Save - cmdsave
Find - cmdfind
My query is to find a record by using case ref number from the access table
Every time I press the find button it should populate the other result into the relevant text boxes for that particular case ref number.
Caseref field is not a primary key set, it will contain the repeated number with different other details
Example
In my table the case ref entered two times with different different other fields
Empid1 - empname1 - caseref1 - 10000 - 12/08/2015
Empid2 - empname2 - caseref1 - 5000 - 13/09/2014
Empid3 - empname3 - caseref1 - 900 - 09/12/2015