Recent content by eRed

Help :confused: I know it's not normally done but I have a one page report that requires the total (sum) of a field - [EDS_total] - be at the bottom of the page. I found a post on Microsoft's site but it is for a sum on every page's footer and it is for MS Access 2003. I am using MS Access...

vbaInet, Thank you for the reply. I followed your suggestion and it worked! eRed

Thanks for the reply. I am trying to use the following code but I am missing something. I get an "run-time error '424' object required" on this line: Set QueryDef = Object.CreateQueryDef("QDLTCFarNF", query) "some SQL String" is much longer but did seem relevant for this post. Dim query As...

From eRed the Noobe :-) I have a report that I am trying to save as a PDF using DoCmd.OutputTo This code properly saves the report: DoCmd.OutputTo acOutputReport, "LTCFarNF", acFormatPDF, "M:\ARMGR\Reports\" & Me.ltcfname.Value & Chr(34) & ".pdf", True However, I need to filter the report...

Thank you for reading the post. Records 2 - 6 are payment TYPE = 5000. Records 2&3 are both in the >30 Column (there Days old are over 30 - "Now()-DUE DATE"). Records 5&6 are both in the Future Column (there Days old are less than 0 - "Now()-DUE DATE"). Is they a way to apply...

I cleaned up the original post to make it readable.

will do thanks for the feedback

I need to create an Aging Report. The clients have two types of dollar amounts due (FIELDS: "NAME", "TYPE", "AMT_DUE", "DUE_DATE" ). The first is a single line item, one time charge (TYPE=4000), The second is a series of amounts in the form of monthly payments (TYPE = 5000). I...

Thank you very much... this was the code that worked: DoCmd.OpenReport "ReportName", acViewPreview, , "[ReportName].[FieldID]=" & Me.FieldID & " And " & "[ReportName].[DateRec] = #" & Me.[DateRec] & "#" Thanks again! E

Please help :confused: This works DoCmd.OpenReport "ReportName", acViewPreview, , "[ReportName].[FieldID]=" & Me.FieldID and this works DoCmd.OpenReport "ReportName", acViewPreview, , "[ReportName].[DateRec]= #" & Me.[DateRec] & "#" But this doesn't work DoCmd.OpenReport "ReportName"...

They are the names of forms that when rec'd trigger operational events. So the code looks correct? I have tried a number of variations on this line: DoCmd.OpenReport "CouponBk", acViewPreview, , "[CouponBk].[fk_patientID]=" & Me.fk_patientID And "[CouponBk].[1259rec]=" & Chr(34) &...

I do... :-/ what's wrong with those names?? I am a bit of a noob.

I am trying to run a report from a Form Button based on two criteria; patient.ID and 1259rec (date) I can make it work based on the patient.ID but not the date (nor both) :confused: THIS WORKS Private Sub Command70_Click() DoCmd.OpenReport "CouponBk", acViewPreview, ...

John Big Booty you are the man, thanks :)

This is about a Command Association with a button in a subform COMMAND DoCmd.OpenReport "AR", acViewPreview, , "[ar].[ltcfname]=" & Me.ltcfname.Value When I run the code I get the following error: Run-time error '3075': Syntax error (missing operator) in query expression...