Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / December 2007

Tip: Looking for answers? Try searching our database.

Help on a design

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
dplove - 03 Dec 2007 18:24 GMT
I have a form called "software info".  In this form is a subform with the
license number for the software. I have also created a "check out/in" form
for the software.  In the software form I have a button that I can click on
that will open the "check out/in" form in order for me to put in the info
when someone borrows the software.

Here is what I would like to happen after I have inserted the info into the
"check out/in":
When it is checked out I would like, maybe a red button or something, that
says that the software has been checked out.  Also when it returns I would
like for the above red button to uncheck or disappear.  Can this be done and
how?

Thanks
Klatuu - 03 Dec 2007 19:10 GMT
I have a similar application.  What I use is an Option Group with two Toggle
Buttons.  One says Check Out and the text is red.  The other says Check In
and the text is green.  There is a Boolean field in the table that indicates
whether a record is checked in or out.  If it is Checked In, The Check In
button is disabled and if Checked out, the Check Out button is disabled.  I
use the After Update event of the option button to update the checkout field
in the table and enable and disable the correct buttons.
Signature

Dave Hargis, Microsoft Access MVP

> I have a form called "software info".  In this form is a subform with the
> license number for the software. I have also created a "check out/in" form
[quoted text clipped - 10 lines]
>
> Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.