Hi. I have an Access Form (2007) that captures all of the user, hardware, and software information for a certain computer.
This form has 4 tabs:
(1)Manufacturer Information
(2)Specifications
(3)Software
(4)Additional Information
On the Software tab (which is part of the main form), there is a list of all available software programs the company has licenses for. There are checkboxes next to program. I have queries and expressions set up so that Access can calculate how many licenses are still open out of the number currently available based upon the which checkboxes are checked off for each record. I have the calculation set up so it will subtract 1 license (if checked) or add 1 license(if unchecked)This calculation works perfectly and displays as "3 of 27 licenses available."
The problem is, it will only requery the total available (the first number - 3) after closing and reopening the form. I would like it to update the number available as soon as a checkbox is checked or unchecked.
I am not that good with VBA code, but I tried putting in a DoCmd.Requery; however, this does not keep the checkbox checked, it only subtracts 1 from the number available - therefore I can click the same checkbox 20 times on the same record and it will subtract 20 (which is not helpful if software is being removed from the computer and I want it to add 1).
I would appreciate any suggestions or coding samples you can offer.
Thanks,
Staci
Staci – Using Windows 7, Microsoft Office 2007 & Crystal Reports Version 10
This form has 4 tabs:
(1)Manufacturer Information
(2)Specifications
(3)Software
(4)Additional Information
On the Software tab (which is part of the main form), there is a list of all available software programs the company has licenses for. There are checkboxes next to program. I have queries and expressions set up so that Access can calculate how many licenses are still open out of the number currently available based upon the which checkboxes are checked off for each record. I have the calculation set up so it will subtract 1 license (if checked) or add 1 license(if unchecked)This calculation works perfectly and displays as "3 of 27 licenses available."
The problem is, it will only requery the total available (the first number - 3) after closing and reopening the form. I would like it to update the number available as soon as a checkbox is checked or unchecked.
I am not that good with VBA code, but I tried putting in a DoCmd.Requery; however, this does not keep the checkbox checked, it only subtracts 1 from the number available - therefore I can click the same checkbox 20 times on the same record and it will subtract 20 (which is not helpful if software is being removed from the computer and I want it to add 1).
I would appreciate any suggestions or coding samples you can offer.
Thanks,
Staci
Staci – Using Windows 7, Microsoft Office 2007 & Crystal Reports Version 10