Passing variables to a report through Visual Basic

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

Hey guys, quick question.

I call my access reports through my VB application. Is there any way
to pass variables to my access report from my VB App?

I want to pass what options the users selected from the main form.

Thanks
Matt
 
That was what I was originally going to go for, but it would be much
easier if I could just pass variables over instead of having to store
them in yet another table.
 
There are many other places values can be stored and retrieved such as text
files, registry,...
 
Thats true...but I was hoping for a simpler solution.

I mean an access report can be called from Visual basic via the
Access.Application object. There is truely no way to just set a label
or whatever on an access report to something using visual basic code?
 
Access reports allow you to set label captions and values in unbound text
boxes are run-time.
Reports!rptYourReport!lblHeading.Caption = "My Department Report by
Supervisor"
 
Duane Hookom said:
Access reports allow you to set label captions and values in unbound text
boxes are run-time.
Reports!rptYourReport!lblHeading.Caption = "My Department Report by
Supervisor"
Click to expand...
In what method I may set field QurterSum plased in group subtotal? If period is "year" - there are 4 quarter sums : -(
 
Back
Top