Recent content by sv89

Ah, I feel so stupid. I should have figured that on my own. :o

Oops...my bad. Meant to do a Count. Not a Sum. Thanks.

Hi, Is it possible to calculate more than 1 sum of the same field in a SQL statement/ I want a result like the following. Ordered Done Pending ----------------------------------------------------------- 10 8...

Thanks Banana. That worked :)

Hi I have the following query: SELECT tblAppTypes.appType, tblAppTypes.appTypeID, Count(tblOrders.OrderID) AS Orders FROM tblAppTypes LEFT JOIN (tblApplicants LEFT JOIN tblOrders ON tblApplicants.appID = tblOrders.AppID) ON tblAppTypes.appTypeID = tblApplicants.appType WHERE...

Decided to go with a report based on a cross tabbed query instead. Thanks.

Hi, I'm trying to build a report with each group in a new column similar to 'Products by Category' report in the Nwind example. I've set it such that 2 groups appear on a page. The problem is that the 1st group appears in the middle of the first page and only 1 group appears on the 1st page...

My frmInvoices can be compared to the Orders form in the Nwind example. You select a Product from a combo box in the Orders subform to add it to the Order. The Nwind example lets you save the record in Orders and move on to the next one even if there aren't any products selected in the Orders...

I have the code below for sbfrmInvoiceDetails but it doesn't seem to work: totUnits is a calculated field on sbfrmInvoiceDetails. totUnits = Count([OrderLineNum])

Hi, I have a bound form Invoice and a bound subform InvoiceDetails joined by InvoiceID. How do I prevent saving a record in tblInvoice if the InvoiceDetails section is empty?

This works for the current record on the mainform. If the field on the mainform is equal to 2, it allows 3 entries in the subform and then no additions. However if I move to the next record on the mainform, I want the allowadditions on the subform to be true.

Thanks Bob

Thanks Bob. Solved the hanging up part I've got 4 rows in my subform datasheet but the above code returns the value in the first row 4 times. :confused:

Hi, I'm trying to get all values of a field from a subform in datasheet view using the following code: Dim rs As DAO.Recordset Set rs = Me.sbfrmMySubForm.Form.RecordsetClone Do While Not rs.EOF strMyValues = "" & Forms!frmMyMainForm!sbfrmMySubform!MyField & "" Loop MS Access...

Hi, I have a frmOrders and sbfrmOrderDetails linked by OrderID. I want to limit the records on sbfrmOrderDetails based on a field TotUnits on the mainform. So, if the user enters 5 as the value in TotUnits, only 5 records are to be entered in the sbfrmOrderDetails. This is the code I'm using...