Search results

OrderDetailsID missing in the T2 setting and I am nor sure how to fix it (when adding to SELECT and GROUP BY it results in multiplying the same lines)

Nope. Simple values from tblProduct and tblPurchaseDetails - cost incl. VAT

Not obvious

.accdb Access 2010

Well, I appreciate the inputs of arnelgp and Isaac, but my tread remained unsolved: the running total solution and the reason for crushing when using my quite simple query. I'd really appreciate more to-the-point assistance.

New concepts for me, I will google it out. I don't really know how to implement suggested approach for running total, would appreciate some tip. In general, my query runs smoothly by itself, but crushes when used in another query. What is the technical reason?

Which query needs to be chopped and what "use layout' means in query designing?

qrySalesCount counts products sales (the FO part of FIFO): SELECT T1.ProductID, tblProduct.ProductName, T1.OrderID, tblOrder.OrderDate, T1.Quantity, T1.UnitCost, (SELECT Sum(tblOrderDetails.Quantity) AS Total FROM tblOrderDetails WHERE tblOrderDetails.OrderDetailsID <=...

Do you mean this: Sub Search() Dim strCriteria, task As String Me.Refresh If IsNull(Me.StartDate) Or IsNull(Me.EndDate) Then MsgBox "Missing dates interval", vbInformation, "Enter dates interval" Me.StartDate.SetFocus Else strCriteria = "(OrderDate >= #" & Me.StartDate & "# and...

This is the calling sub: Private Sub btnCurrentMonth_Click() Me.StartDate = DateSerial(Year(Date), Month(Date), 1) Me.EndDate = DateSerial(Year(Date), Month(Date) + 1, 0) Call Search End Sub I was wondering how could I change the locale date setting on the other computer. The...

t'was my fault. everything works fine with formatting

Thank you. This must be it!

Hello dear experts. In my frmListOfOrders I have unbound StartDate and EndDate text boxes as well as search buttons for several predefined intervals (btnCurrentMonth, btnLastMonth etc.). The underlying code for the search sub is: Sub Search() Dim strCriteria, task As String Me.Refresh If...

All 3 options open frmCustomer unfiltered (on 1st existing record). I guess, the DataEntry property should be turned off before the argument "CustomerID = " & Me!CustomerID is passed, nor after.

How do i edit this properly: Private Sub CustomerID_Click() DoCmd.OpenForm "frmCustomer", , , "CustomerID = " & Me!CustomerID Forms!frmCustomer.DataEntry = False End Sub So I pass the argument and switch the DataEntry to False in one click?

Thought of this too. I was hoping to find a simple solution without multiplying DB objects unnecessarily.

Thank you for your reply. Unfortunately none of your suggestions seems to address the problem I've described. The form opening trigger is executed automatically (so I don't know where to add DoCmd.OpenForm method) and I cannot add On Load event for the reasons I've mentioned.

In frmOrders, when adding notinlist value in combobox "CustomerID" a List Items Edit data property triggers frmCustomers form to open. It opens on the 1st existing record (CustomerID=1). I need it to open on new record (preferably inheriting the entered new customer's name, but this is less...

Your original code was something I was able to understand code-wise, so I was hoping there is some simple tweak to make it work. I prefer to understand the advised code, not to just copy-past it. Calling user-defined functions is not something I am familiar with, so I could not even understand...

It would be 4th change of the code.I need to stop somewhere:) Is there any way to stay with the original approach If Me.OrderStatusID = 5 Then Me.OrderDate.Enabled = False Me.frmOrderDetailsSubfrm.Enabled = False .... Else Me.OrderDate.Enabled = True...