Search results

I have an inventory table that contains products that come in different unit types, i.e pail, drum, tote etc. When I run my purchase/sales queries for a certain month, some products with multiple unit types may have one type that was purchased/sold while other types are not I.e. Product A...

I have an inventory report that is based on a user inputted date range on a form. When I click preview on the form, the report opens via a macro and sometimes shows an "#Error". However, when I click design view and then print preview again, the report queries the desired results. How can...

I have two user-inputted date range forms. One controls the inventory while the other control the sales report. When I input the sales report date range, which is linked to the inventory, it asked me to input a date range from the inventory form in the form of an Access warning box. Is...

I have a checkbox on my form that determines whether the shipping address is the same as the billing address. My VBA code looks like the following: Private Sub Check_Same_As_Billing_Box_AfterUpdate() If Check_Same_As_Billing_Box = True Then ShippingAddress = BillingAddress ShippingCity =...

Hi, I am trying to create a monthly inventory report such that I can query the beginning inventory, purchases and sales between a user-inputted date range on a form. The problem is that during the specified date range, customers may not have ordered a certain product. Hence, when the...