Recent content by greyhound48

Broken Report Screen print Thats pretty weird. I am using Access 2003 and I have attached a screen print of what I am seeing. Thanks to anyone who put in time to look into this.

Same Problem I noticed the same problem. I attached a sample. What I was attempting to do was highlight on field on my report if a condition was met. I didnt want to highlight the whole line by using vb code. So I just right clicked on the field in the detail sectional and selected...

Automate pivot table in excel I have previously built the pivot tables in Access which would be my preference. But my client wants the output of the pivot tables in Excel. Access requires a user to click on the "Export to Microsoft Office Excel" button and then save the file as an xls pivot...

I have successfully built an excel pivot table from access, but when it generates I have one problem. My xlDataField(s) are displaying in order/move to row format (stacked) instead of order/move to column format (across) Is there a way to define this in VBA? below is an example of the code I...