Access 2003 Question

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

cmgerken

Thread Starter
Joined
Jul 6, 2007
Messages
1
Hello all,
I am a college student at a department at my school and am creating a database in Access to catalog our video library. I have a form in which users enter their unique, university supplied user name to create an account in the database. I also have a form with the videos we have in our database. The command button on the form "Check Out Video" is grayed out if the video is already checked out; otherwise, its clickable. What I want is to create a way that users will be required to enter their unique ID when they click the Check Out button, so that their ID is recorded as the person with the video. Then, obviously, we can just lookup user ID's in our other table to see who the person actually is. How can I set it up so that they will have to enter their ID and it will be added to the table and still retain the feature of having the button become gray when a video is not available?
 

OBP

Joined
Mar 8, 2005
Messages
19,896
cmgerken, let me expand on that.
When you use the security Wizard to make a secure database, each person has to log on to the database.
The Access System then knows that user and can provide their details at nay time.
The way that your system is currently set up, if someone knows someone else's ID they can book out videos in their name instead of their own.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top