Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 How to Find a Report Group in VBA

Author  Topic 

rrb
SQLTeam Poet Laureate

1479 Posts

Posted - 2005-08-10 : 23:40:22
Dearest gurus

please tell me, how can I check (in VBA) what fields are included in the sorting and grouping of a report?

--
I hope that when I die someone will say of me "That guy sure owed me a lot of money"

timmy
Master Smack Fu Yak Hacker

1242 Posts

Posted - 2005-08-11 : 00:47:11
I'm almost sure it's in the Report object somewhere. Have a dig around and you'll find it there. Perhaps in the Report.Properties collection?

I don't have Access installed on my machine at the moment so I can't confirm.

HTH,

Tim
Go to Top of Page

rrb
SQLTeam Poet Laureate

1479 Posts

Posted - 2005-08-12 : 03:12:00
Thanks Timmy - but no luck, I tried that long before I posted...

Anyone else got an idea?

--
I hope that when I die someone will say of me "That guy sure owed me a lot of money"
Go to Top of Page
   

- Advertisement -