Update Design of a Number of Reports at Once

[charcurley]

Hello. I have to go into the design of about 100 reports to check on all fields on the reports. (The reports are in a letter format). For example: I have to update
[Company]with company().

I have started to work my way thru them but thought there may be I could do in VBA code that would make life easier?

Any help would be appreciated.

Thanks.

 

[TrojanRabbit]

Hmm. Maybe use AllReports object and Report object to loop through and set the field in each. You should be able to get to the field name and assign it the command. I don't know the code to give you, though. Maybe something like

For Each rpt In reports
rpt.Company = company()

Dunno for sure.

 

[charcurley]

Thanks for replying so quickly. You know I found a great little shareware program that does exactly what I wanted to do. It works great and I'm giong to go online and register it because it will definitely come in handy again I'm sure.

Again thanks for the info.. I was struggling along.

 

[p7eggyc]

Can you post the info for the shareware program? I would like to know more about it.

Thanks!

Peggy

 

[charcurley]

http://www.rickworld.com

I ended up buying it last night it was such a big help.