M
Mike Barbone
Hello,
I sometimes have projects that I need to create queries, forms and reports
for specific fields in an MS Access 2000 table. Usually these are only for 5
or so fields and I can do them manually using copy and paste. However, this
last project actually needed 50 of these which was time consuming.
I can do the queries through a Module using CreateQueryDef. However, I'm not
sure how to go about it for the Forms and Reports.
In this specific example, I have 8 fields for each query/form/report, with 4
of them always being the same; recid, store, shop,location and 4 of them
changing for each form: qXX, qXXCD1, qXXCD2, qXXCD3. Each form/report will
generate off of the corresponding query that is created for the
corresponding qXX fields.
I usually just design a form and report and then copy and paste for each new
one changing the fields and query as needed but this time it was time
consuming.
Can this be done and if so, would you point me in the proper direction?
Thank you,
Mike
I sometimes have projects that I need to create queries, forms and reports
for specific fields in an MS Access 2000 table. Usually these are only for 5
or so fields and I can do them manually using copy and paste. However, this
last project actually needed 50 of these which was time consuming.
I can do the queries through a Module using CreateQueryDef. However, I'm not
sure how to go about it for the Forms and Reports.
In this specific example, I have 8 fields for each query/form/report, with 4
of them always being the same; recid, store, shop,location and 4 of them
changing for each form: qXX, qXXCD1, qXXCD2, qXXCD3. Each form/report will
generate off of the corresponding query that is created for the
corresponding qXX fields.
I usually just design a form and report and then copy and paste for each new
one changing the fields and query as needed but this time it was time
consuming.
Can this be done and if so, would you point me in the proper direction?
Thank you,
Mike