Need Help Building Tape Backup Database

R

Ryan C.

I am in charge of logging all the backup tapes and the old way was scanning
the barcode into a text file and saving the text file as the date in which
the tape was sent off site.

I want to create a database that will allow me to scan the barcode into a
table so that I can quickly find a tape using the query. The part where I
need help is with the form or the table (not sure).

What I want to do (unless you can think of a better way) is to have a simple
form that allows me to have the date, the tape number (barcode) and the bin
or box number the tapes go in for storage.

1. I would like to have the date automatically filled out for me, but not as
a editable field. Meaning that it's there, but will not allow me to change
the date in the form itself.
2. Make it so that I only have type in the Bin or Box number one time, and
then it stays that way until I close the form. (hope that makes since).

If anyone can help me with this, I would appreciate it. I think I will move
the data to a SQL server because I plan to have a lot of information to
store.

Ryan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top