Can anyone help me set a table dynamically using VB and an Access database? I am creating archive tables that have identical field names to the original table and need to access the new table in the Crystal Report. Is there a way to do this in VB or do I need a new report for each Archive table?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Set table dynamically in VB
- Thread starter SamWalker
- Start date
If you're using the ActiveX control in your program, this code:
CrystalReport1.DataFiles(0) = strArchive
will set the database to the path and filename contained in strArchive. Datafiles is a zero-based array. If you have more than one database in your report, you can see the order they're in by looking in Databases / Set Location.
CrystalReport1.DataFiles(0) = strArchive
will set the database to the path and filename contained in strArchive. Datafiles is a zero-based array. If you have more than one database in your report, you can see the order they're in by looking in Databases / Set Location.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question