I've created a physical inventory database for my company that creates and manages the serialized count sheets used during the inventory process. I'm struggling with an idea for the audit log that gets generated at the very end. Rather than listing all the count sheets by number for each inventory location, I'd prefer to save space and express the the count sheets in ranges. In this way, instead of listing:
00001
00002
...
StuartD
Last Activity: Nov 12 '10, 07:15 PM
Joined: Oct 23 '08
Location:
-
details expressed as ranges of values in a report
-
Nevermind...wen t the selective record set route and it works like a charm. -
use a combobox with no selection as "all values" in a query
I have a sub form that is populated based on the selection of a year from a combo box on the main form. I'm trying to add a second main form combo box for item category to further filter the sub form; however, I'd like the item category combo box to be interpreted as "all values" if no selection is made. I've tried using an IIf statement in the underlying query of the sub form to either use the value of the item category combo box if... -
compare field values while editing records on a subform
I have a sub form that serves as a schedule for annual production, listing items, a planned total (given to use by our corporate overlords), and then separate totals for each month of the year that our facility plans. I'd like to alter the font of the total field if the sum of the month fields doesn't match the total. Is there a way to do this on the fly while the user changes values in the month fields of a given record? If not, any good suggestions...
No activity results to display
Leave a comment: