Passing data to a report with VB

N

nickpup

What is the proper/recommended way to pass data, via VB,
to an Access 2002 report? I want to be able to change
report heading strings, column labels etc etc.

I have tried several methods that did not work.

Thanks,
nick pup
 
D

Duane Hookom

You could place the value in tables and use text boxes bound to the fields
in the tables. I would always prefer a solution that reads the data from
tables.
 
N

nickpup

Thanks for your advice, which I am sure is hard earned. But why? I do not
need to save this data.

Are you implying that other methods do not exist or do not work well?

I know I could just do what you say, but understanding allows me to answer
related questions without asking.

Thanks again,
Nick
 
D

Duane Hookom

If you don't want to save the data or edit it in a controlled form then use
text boxes with control sources like:
=[Enter the label for fieldA]
This doesn't require any code.
 
N

nickpup

If I use a table, how do I get to the proper record? Do I need to have it as
part of the recordsource? Does there need to be a relationship setup with my
real recordsource?

Thanks,
Nick


Duane Hookom said:
If you don't want to save the data or edit it in a controlled form then use
text boxes with control sources like:
=[Enter the label for fieldA]
This doesn't require any code.

--
Duane Hookom
MS Access MVP
--

nickpup said:
Thanks for your advice, which I am sure is hard earned. But why? I do not
need to save this data.

Are you implying that other methods do not exist or do not work well?

I know I could just do what you say, but understanding allows me to answer
related questions without asking.

Thanks again,
Nick
Click to expand...
Click to expand...
 
D

Duane Hookom

Use a table with a single record. Then you don't need to join the table to
anything else in your report's record source.

--
Duane Hookom
MS Access MVP


nickpup said:
If I use a table, how do I get to the proper record? Do I need to have it as
part of the recordsource? Does there need to be a relationship setup with my
real recordsource?

Thanks,
Nick


Duane Hookom said:
If you don't want to save the data or edit it in a controlled form then use
text boxes with control sources like:
=[Enter the label for fieldA]
This doesn't require any code.

--
Duane Hookom
MS Access MVP
--

nickpup said:
Thanks for your advice, which I am sure is hard earned. But why? I
Click to expand...
do
not
need to save this data.

Are you implying that other methods do not exist or do not work well?

I know I could just do what you say, but understanding allows me to answer
related questions without asking.

Thanks again,
Nick


:

You could place the value in tables and use text boxes bound to the fields
in the tables. I would always prefer a solution that reads the data from
tables.

--
Duane Hookom
MS Access MVP


What is the proper/recommended way to pass data, via VB,
to an Access 2002 report? I want to be able to change
report heading strings, column labels etc etc.

I have tried several methods that did not work.

Thanks,
nick pup
Click to expand...
Click to expand...
Click to expand...
 
Top