E
Emily
I have created a filing database that (should) enable
users to search the files we have, and check them out. I
have a table for all files, a table for users, and a check
out table that records when and by whom the files are
checked out. My check out process consists of two forms.
The check out form works perfectly: you enter the barcode
and who the file is going to, and the current date is
automatically entered in the the Check out date field of
the Check out table. I am having problems with the check
in form. Right now, you enter the barcode and click a
command button that should enter the current date in the
check-in field for the barcode entered. Unfortunately,
the result is that the check-in form creates a new record
(instead of going to the record with a corresponding
barcode and a check in field that is null and filling in
that field with current date making the file "checked in")
and because a combination of barcode, user, and check out
date make the primary key (for the check out table), the
check in is not allowed because it results in a null value
for the primary field.
How do I creat a check-in process that targets the file
that is checked out (check in is null)by the barcode and
adds a check in date to that specific field instead of
creating a new record with only the check in date? I hope
that this is clear enough because I'm really at a loss for
ideas. I'm a beginner user so if this requires VB please
explain fully.
Thank you for saving me once again!!!
Emily
users to search the files we have, and check them out. I
have a table for all files, a table for users, and a check
out table that records when and by whom the files are
checked out. My check out process consists of two forms.
The check out form works perfectly: you enter the barcode
and who the file is going to, and the current date is
automatically entered in the the Check out date field of
the Check out table. I am having problems with the check
in form. Right now, you enter the barcode and click a
command button that should enter the current date in the
check-in field for the barcode entered. Unfortunately,
the result is that the check-in form creates a new record
(instead of going to the record with a corresponding
barcode and a check in field that is null and filling in
that field with current date making the file "checked in")
and because a combination of barcode, user, and check out
date make the primary key (for the check out table), the
check in is not allowed because it results in a null value
for the primary field.
How do I creat a check-in process that targets the file
that is checked out (check in is null)by the barcode and
adds a check in date to that specific field instead of
creating a new record with only the check in date? I hope
that this is clear enough because I'm really at a loss for
ideas. I'm a beginner user so if this requires VB please
explain fully.
Thank you for saving me once again!!!
Emily