Search results
-
B
Recover a deleted report
Is there any way to recover a deleted report? -
B
doCmd print to pdf syntax using a field ref in the file name string
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... -
B
Suppressing blank rows in a summary table
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... -
B
Aligment using control layouts
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...