Hello all,
I am creating reports in VB using RDC. I can connect via jet 4.0 to the Access 2000 database and run a select statement to populate a report.
Now I am looking to use the functions in the Access database which can do all the lookups I need.
ie. A field label is determined by looking a 2 tables and then using some logic to determine which description should be used.
The Access database has all the functions already written to automate the lookups. My report has over 50 fields which require the lookups in order to determine the label for the field.
Does anyone know if a recordset can be created in Access 2000 and then passed to VB? If this is possible it will greatly simplify the lookup problem.
Thanks in advance
I am creating reports in VB using RDC. I can connect via jet 4.0 to the Access 2000 database and run a select statement to populate a report.
Now I am looking to use the functions in the Access database which can do all the lookups I need.
ie. A field label is determined by looking a 2 tables and then using some logic to determine which description should be used.
The Access database has all the functions already written to automate the lookups. My report has over 50 fields which require the lookups in order to determine the label for the field.
Does anyone know if a recordset can be created in Access 2000 and then passed to VB? If this is possible it will greatly simplify the lookup problem.
Thanks in advance