G
Gary
I am very new to Access and trying to decide even if Access is right for my
project. One of the things that I'm trying to accomplish is to keep track
of various records which have been sent to me for storage. Many of these
records are patient records and I'd like to keep track of and be able to
search on the patient name, ID number, and date of birth for each record.
However, I want to only have to manually enter (via barcode scan) the
patient ID number and not the name and DOB. I have a txt file (updated
regularly) which lists the name, ID, and DOB of all the patients that have
been seen in all the clinics. Can anybody tell me if/how I can have Access
automatically populate a table with the name and DOB if I enter the ID#.
TIA! Very much!!
Gary Vocks
project. One of the things that I'm trying to accomplish is to keep track
of various records which have been sent to me for storage. Many of these
records are patient records and I'd like to keep track of and be able to
search on the patient name, ID number, and date of birth for each record.
However, I want to only have to manually enter (via barcode scan) the
patient ID number and not the name and DOB. I have a txt file (updated
regularly) which lists the name, ID, and DOB of all the patients that have
been seen in all the clinics. Can anybody tell me if/how I can have Access
automatically populate a table with the name and DOB if I enter the ID#.
TIA! Very much!!
Gary Vocks