Passing data to a report with VB

  • Thread starter Thread starter nickpup
  • Start date Start date
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
 
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.
 
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
 
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.
 
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...
 
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...
 
Back
Top