Recent content by Shoo

I am completely stuck. I need the code to specify that the order that has been double clicked should open. This principle works fine for my products and customer datasheets without any need for additional filters but not so for the order double click code it seems.

Thanks I will look it up. What's strange is that the exact same code (with name adjustments) works for the products list.

hey can anyone please explain how to adjust the below code to open the specific order ID that has been double clicked? At the moment no matter which order is double clicked the same order is opened. Private Sub OrderID_DblClick(Cancel As Integer) On Error GoTo Err_OrderID_DblClick Dim...

My query keeps popping up with a dialog box for "beginning date" "end date" even though the query itself has no requirement for dates. There are no fields within the query requesting that information. Any ideas how to fix this?

that worked, thanks guys.

here's the event procedure. Private Sub View_Click() On Error GoTo Err_View_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "View Customer Orders" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_View_Click: Exit Sub Err_View_Click: MsgBox...

Thanks Gizmo, but where should I put that info?

Is there any fix? Here's the essence of the bug: I add a button that opens another form (form B) within my form (form A). Even though form B is set to datasheet view it always opens in single form. I go into the design properties of form B and make sure it is at datasheet view(which it is)...

Looks like all I simply needed to do was: "LessDiscount: CCur(([Order Details].[UnitPrice]*[Quantity])*[discount%])"

^ Any suggestions are appreciated.

Here it is, thanks. SELECT DISTINCTROW Orders.DeliveryName, Orders.DeliveryAddress, Orders.DeliveryCity, Orders.DeliveryRegion, Orders.DeliveryPostcode, Orders.CustomerID, Customers.CompanyName, Customers.Address, Customers.City, Customers.Region, Customers.Postcode, Orders.OrderID...

NB this field is within the Invoices query itself.

What's wrong with this query equation? it prompts me to enter a value for order details.totalunitprice instead of retrieving it from the appropriate table. I guess I am missing a marker. "LessDiscount: CCur([customers].[discount%]*[Invoices].[TotalUnitPrice])" [customers] denotes customer...

So all it it requires is a smidgen of VB - thanks Gizmo.

- after qty entry into order form. Hi, How can I configure my order form to do this, it will require perhaps a "post order" button? How would that work? Thanks.