By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,192 Members | 1,276 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,192 IT Pros & Developers. It's quick & easy.

Reports - Changing Properties on the fly

P: n/a
Edd
I have a VB App that instantiates a Access Application from which I
have triggered the running of reports using the standard
DoCmd.OperReport. This is an automated printing app that just reads
parameters in a database and then just prints the report OR emails
them to a recipient.

My problem is that we have switched our backend to MSSQL 2000 and
Access is the front end.

I need to, prior to running the report change a number of properties
in the report, eg we are now running stored procedures on some reports
so the "inputparameters" property is prepared ahead of time and just
loaded. I also need to change a number of other properties at the same
time, e.g. Caption etc.

Does anyone have a clue how to script this, noting that doing changes
in design mode is NOT an option as this is a Multi-User environment.

TIA
Edd
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
You can make DESIGN changes to Access reports with VB code assuming you are
NOT using runtime and each user has a copy of the front-end.

You can also make many changes using event procedures. I regularly change
captions in the On Open event.

"Edd" <ep*****@syntech.com.au> wrote in message
news:e8**************************@posting.google.c om...
I have a VB App that instantiates a Access Application from which I
have triggered the running of reports using the standard
DoCmd.OperReport. This is an automated printing app that just reads
parameters in a database and then just prints the report OR emails
them to a recipient.

My problem is that we have switched our backend to MSSQL 2000 and
Access is the front end.

I need to, prior to running the report change a number of properties
in the report, eg we are now running stored procedures on some reports
so the "inputparameters" property is prepared ahead of time and just
loaded. I also need to change a number of other properties at the same
time, e.g. Caption etc.

Does anyone have a clue how to script this, noting that doing changes
in design mode is NOT an option as this is a Multi-User environment.

TIA
Edd

Nov 12 '05 #2

P: n/a
Edd
Maybe I didn't explain myself - these usually reports are constructed
by users - they are put in an MSAccess repository and a scheduler runs
along, picks up the report and prints it to a PDF file.

I need to control the report from VB by instantiating it and
modifiying the properties in that instance, retrieve the data and then
print it. I have been using the DoCmd up to now but I need to modify
aspects of the report BEFORE I open it and the OPEN event is not an
option.

TIA
Edd

"paii" <pa**@packairinc.com> wrote in message news:<vl************@corp.supernews.com>...
You can make DESIGN changes to Access reports with VB code assuming you are
NOT using runtime and each user has a copy of the front-end.

You can also make many changes using event procedures. I regularly change
captions in the On Open event.

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.