Can anyone help me with this:
A. From excel look for a specific ticket number [tbticket] in a access table called tracker, and return the record to a userform. From there I want to fill if blank or apend data to a field in the database called [tbresolution].
The userform will only have 3 fields:
1. a blank textbox for entering the ticket number to search
2. a blank textfield for apending the resolution to the database
3. the record number
Right now I have the workbook adding, searching and displaying information from the database but I have not yet been able to figure out how to edit that data.
Any help is appreciated.
A. From excel look for a specific ticket number [tbticket] in a access table called tracker, and return the record to a userform. From there I want to fill if blank or apend data to a field in the database called [tbresolution].
The userform will only have 3 fields:
1. a blank textbox for entering the ticket number to search
2. a blank textfield for apending the resolution to the database
3. the record number
Right now I have the workbook adding, searching and displaying information from the database but I have not yet been able to figure out how to edit that data.
Any help is appreciated.
