Search results

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

Oh, I figured out the link property. Always just dragged the subform on to the main form and thought it would work automatically everytime. :o

Hi, I've attached my relationship diagram. I want to create 'frmInvoice' which displays the following fields: All fields from 'tblInvoices' ServiceID, AppID from 'tblOrders' addLine1, addLine2, addLine3, town, county, postCode from 'tblAppAddresses' Also I want to let the user select...

Could you explain a bit more in detail. I'm fairly new to Access forms and reports. Thanks

I've created a button 'btnCreateInvoice' on the 'frmOrders' that opens 'frmInvoice'. I want to pre-populate relevant fields in 'frmInvoice' based on 'frmOrders'. So 'frmInvoice' would have to be unbound, right? So, would I have to create another bound form 'frmInvoice1' if the user wants to...

Thanks Simon. That might work.