Search results

I'm looking for something similar... i think I would like to create a form, to populate a main table, of which would have drop down and text boxes lets say... Customer, Product, Location, txt entry, and #of records needed. Info like Customer, Product, Location, would be drop down boxes which...

I entered that code onto the reports on open, it doesn't do anything, won't allow me to go from design view to report view... this was also copied code so i assume there are variables i need to enter which pertain to my database / records? | whereas "ShipmentsID=" would be the field that i...

Ok here is the code i was directed to... On Local Error GoTo Some_Err Dim MyDB As Database, RS As Recordset Dim strBody As String, lngCount As Long, lngRSCount As Long DoCmd.RunCommand acCmdSaveRecord Set MyDB = DBEngine.Workspaces(0).Databases(0)...

I had grabbed code from here... .granite.ab.ca/access/email/recordsetloop.htm but i can't access this site any more. So now, i am back at the beginning. All i have is the report right now. I want to understand what im doing too...

I don't have the code saved anymore... so im back to having the report, and looking for guidance from here to just have it separate it by the field used to group the report, and it appears the site is down or i cannot access it.

Thx VBA, Im travelling today... all i did was copy the code from that page Paul gave. I will come back here when i can have the DB open.

OK, im on this again... I just made a simple form for the report with a command button which contains the loop code. I click the button and get Error (2046) the command or action 'SaveRecord'; isn't available now. I am assuming since there are multiple users and I do not have exclusive access to...

Paul, I read through the info, and forgive my ignorance, I have to create a form, then code a button to run the report, which will then take that 1 single report and split it into multiple ones? The code on that page Me.Filter = "ShipmentsID=" & Forms![Select Load List]![LoadID] Me.FilterOn...

What about saving the report as multiple reports, say 10 active customers, one 48 page report, to save as 10 separate reports based on the grouping criteria?

I have a report made which creates and groups data by customer, taken from a query that displays only active items. I have the page break set after each group to start a new customer with a new page. So the single report is multiple pages containing all active customers, where each new customer...