Reports made with VBA

[Lilian]

Hi,
How to make reports using VBA code? I must do so that database users do not
need at all to come in to the report construction guide to make the reports.
If some have some example of vba code to make reports will be very
appreciated for your help.
Best regards,
Lilian

 

[Marshall Barton]

How to make reports using VBA code? I must do so that database users do not
need at all to come in to the report construction guide to make the reports.
If some have some example of vba code to make reports will be very
appreciated for your help.

Well, it is possible, but you would have to duplicate pretty
much what the report wizards do. This would be a very
complex and large pile of code and is almost never worth the
effort. In addition to that problem, doing design time
operations in a running application really opens the door to
corruption, bloat and other problems as well as being
totally impossible in an mde.

I strongly suggest that you back up and figure out the
user's real needs. Most often it's only that they need to
display a standard report with different criteria and/or,
occasionally with a different layout. Both of those
requirements can be dealt with in far simpler ways than
creating new reports all the time.