Etxezarreta
Member
- Local time
- Today, 22:54
- Joined
- Apr 13, 2020
- Messages
- 175
Hello everyone,
I would like to ask for advice here: I use many "forms-tabular sub forms", mainly to generate lists of people that match with queries: the queries are directly written in VBA, using ADO and SQl code.
Then I need to generate reports that correspond to the subforms: I use the same code as in the forms basically: same SQl expressions that feed the report.RecordSource instead of the Me.subform.form.Recordset. This looks like double work doesn't it?
I was thinking in another way to do it: using the code from the forms to populate "temporary" tables, that will then populate the reports.
Considering the fact that I will have to migrate the back-end to SQl server, could you please help me:
- Are those two ways to create dynamic records the only ones?
- Which one would be the best to work with a SQL server hosted back-end?
Many thanks in advance.
Etxe.
I would like to ask for advice here: I use many "forms-tabular sub forms", mainly to generate lists of people that match with queries: the queries are directly written in VBA, using ADO and SQl code.
Then I need to generate reports that correspond to the subforms: I use the same code as in the forms basically: same SQl expressions that feed the report.RecordSource instead of the Me.subform.form.Recordset. This looks like double work doesn't it?
I was thinking in another way to do it: using the code from the forms to populate "temporary" tables, that will then populate the reports.
Considering the fact that I will have to migrate the back-end to SQl server, could you please help me:
- Are those two ways to create dynamic records the only ones?
- Which one would be the best to work with a SQL server hosted back-end?
Many thanks in advance.
Etxe.