Recent content by Binworkin

Hello Crystal - It's been a while but constantly editing padding and changing border gridlines etc and thought of your reply. Is there a way to save my default preferences to the property sheet so when I add a field its closer to what I need. Thanks

yes, no back up this week. I have been doing but missed one and did alot of work in between. Lesson learned (again).

Is there any way to recover a deleted report?

Thanks, ended up with: Private Sub Command6_Click() Dim FN As String FN = DLookup("FileNamePart", "qryLaborCostData") DoCmd.OutputTo acOutputReport, "Task Detail", acFormatPDF, "C:\Users\SH\Desktop\CC\CC Reports\WSP\Production\" & FN & " Task Detail.pdf", acExportQualityPrint End Sub

I am using the following to print a report in pdf to a location on my C drive. A query on which the report is based has a field called [FileNamePart] in [qryLaborCostData]. I would like the file name to be "Task Detail" & [FilenamePart] & ".pdf" Private Sub Command6_Click() DoCmd.OutputTo...

Thanks for the responses. I tried the row heights and can grow suggestion and since the values are $0 and not Null, and also have row names so I don't think it will work. In considering the second option using a cross tab, I realize I that my example data was not well represented. I have...

In the group and report footer I have a table of values in a structured tabular layout. There are 5 rows - sum of cost for Type 1, 2, 3, 4 and 5. I used sum(iif([type]=1,[Type1_Cost),0)) etc and I used this formula for in each of the 5 rows for each of the columns I want to sum. It formats and...

Thank you - This worked.

I am creating a report and have used the Stacked control function which has helped considerably because I have a lot of fields in the report. However I am having some alignment issues. The attached screen shot highlights the issue: 1. RED: I have two rows of data, the top row is $ currency, the...