Passing variables to a report through Visual Basic

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
 
D

Duane Hookom

How about creating some tables in Access (or where ever) to hold the values.
 
M

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.
 
D

Duane Hookom

There are many other places values can be stored and retrieved such as text
files, registry,...
 
M

Matt

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?
 
D

Duane Hookom

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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

pass through query for sub report 0
Weekly Report 2
Passing OrderBy criteria from Form to Report 1
Passing values to subreports 1
Passing data to a Report 3
Show 'From' and 'To' Dates on a Report 6
Passing SQL query to a Subreport through Visual Basic 0
passing OrderBy criteria from Form to Report in accde file 1

Top