I need help for a project at work. I'm tired of doing it manually and can't take my co-workers acting as if the world was going to end because I wasn't in to get them a card. I now have some help. A co-worker will be helping me with this but I need some help getting it started.
I created a form (frmParkingPasses) to sign out special assignment parking passes. On the form I have the following fields: Parking Pass, Personnel Name, Date Out and Expected Back. The Parking Pass field is a combo box with values of Park Pass 1 thru 10. All this information is set to be input to a table - tblCards.
What I'm trying to do is have the Parking Pass combo box requery against tblCards (the table the form is attached to). Example: if I sign out Parking Pass 1 to John Doe from January 1, 2009 to January 30, 2009, I shouldn't be able to sign this card out from January 2, 2009 to January 31, 2009. I would like the combo box to show what cards are available. I would also like the form to reject the entry if it is entered manually knowing full well the card is out. Not that I'd ever do it but when you're working with other people, you never know what they'll do. I'm still new to Access so I may ask some silly questions.
Any and all help is appreciated.
I created a form (frmParkingPasses) to sign out special assignment parking passes. On the form I have the following fields: Parking Pass, Personnel Name, Date Out and Expected Back. The Parking Pass field is a combo box with values of Park Pass 1 thru 10. All this information is set to be input to a table - tblCards.
What I'm trying to do is have the Parking Pass combo box requery against tblCards (the table the form is attached to). Example: if I sign out Parking Pass 1 to John Doe from January 1, 2009 to January 30, 2009, I shouldn't be able to sign this card out from January 2, 2009 to January 31, 2009. I would like the combo box to show what cards are available. I would also like the form to reject the entry if it is entered manually knowing full well the card is out. Not that I'd ever do it but when you're working with other people, you never know what they'll do. I'm still new to Access so I may ask some silly questions.
Any and all help is appreciated.