473,320 Members | 1,979 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Reports - Changing Properties on the fly

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
2 3615
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Tom Rahav | last post by:
Hello. I use visual basic .net 2003 and Crystal Reports for creating win-reports. My question is if there is any possibility to set font properties (type, color and size) of a text control or...
7
by: dog | last post by:
I've seen plenty of articles on this topic but none of them have been able to solve my problem. I am working with an Access 97 database on an NT4.0 machine, which has many Access reports. I...
11
by: Grasshopper | last post by:
Hi, I am automating Access reports to PDF using PDF Writer 6.0. I've created a DTS package to run the reports and schedule a job to run this DTS package. If I PC Anywhere into the server on...
19
by: LP | last post by:
I am using (trying to) CR version XI, cascading parameters feature works it asks user to enter params. But if page is resubmitted. It prompts for params again. I did set...
4
by: Atley | last post by:
How do I add items and components to my Crystal Report at runtime... the report I want to make will be greatly varied based on data gathered throughout the course of the program... There is no way...
1
by: tony | last post by:
Is there a way to change the "print date" field in vb/vb.net code? I have a report that uses keywords like "MonthToDate" and "YearToDate" to genereate the report, I want to be able to change the...
7
by: Steve_Black | last post by:
Hello, I'm toying with the idea of loading a MenuStrip (VB.Net 2005) dynamically based on who is logged into my system. Every user has different security settings and I want to customize the...
5
by: glbdev | last post by:
I am running Crystal Reports in Visual Studio 2003. I have CR version 11 installed on my system. I noticed on the page that the CRviewer has no "print" button in the toolbar. I went into the...
1
by: =?Utf-8?B?Q2lhcmFuIE8nJ0Rvbm5lbGw=?= | last post by:
On reflection, you could possibly make the app a self extracting zip file which extracts the EXE and a settings file and then starts the app, then when you app closes, it can repack the settings...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.