
VB 3.0 + Access 2.0 + Crystal Reports 4.0
This should be fairly simple to do. I am using access queries not tables to drive
my
Crystal Reports. (You can do this thru odbc). I have set up a userid field as
a parameter in access, and I manipulate it in vb. I want to be able to set the
value to the parameter in vb, pass it to access (where clause) and on to crystal so
that each user will only see their data in the crystal report. Also, isn't there a
way for a crystal report to prompt for data, i.e. data range?
I am not using the vbx, but am using api calls.
Any ideas?
Bob