Recent content by leafsrock100

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...

Same thing happens, TransactionDate is unrecognized

yes, the parameter box appears when I click the preview button on that form. It doesn't appear when I leave it as the original code but the #Error message pops up

Thanks for the helpful advice!

I tried: DoCmd.OpenReport "Inventory Summary", acViewPreview, "", "[TransactionDate] Between [Forms]![Filtered Inventory Summary Date Range]![BeginDate] And [Forms]![Filtered Inventory Summary Date Range]![EndDate]", acNormal but that gave me an "Enter Parameter value" box

So there is no way I can open my sales report without have the inventory summary date range form open and the "begindate" text box filled out?

I have that written your way in my "beginning inventory" query though. When I click to open that query, I get the same box that pops up The SQL statement for that query is: SELECT [Inventory Transactions].ProductID, Sum(nz([QtyReceived],0)-nz([QtyShipped],0)-nz([QtyShrinkage],0)) AS...

I use a textbox for both of the date range forms already. The sales report won't query without the "Enter Parameter Value" box from coming up i.e. it asks for the following: "Forms!Filtered Inventory Summary Date Range!BeginDate" when I click the preview button. I think this is because...

Here is the code: Private Sub Preview_Click() On Error GoTo Preview_Click_Err DoCmd.OpenReport "Inventory Summary", acViewPreview, "", "[Forms]![Manage Inventory]![Products Subform].[Form]![TransactionDate] Between [Forms]![Filtered Inventory Summary Date Range]![BeginDate] And...

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 don't understand how I would use the Month() and year() functions. Would I need a separate dates table? How would I incorporate the day of the month? or would I even have to? Why does it not work the way I outer joined the products and transactions table?

Hi Galaxiom, I tried to query the Purchases/Sales as you stated from above. I started to enter past data starting from January 2010 and the query worked for that month. However, the subsequent months did not query all the products, only the products that had a purchase/sale in that month...

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 =...

Thanks for the quick reply, Galaxiom I got it to work! Sorry, I'm pretty new to Access and I didn't understand what you were asking me to do in your previous post Thanks again