A
aaron.reese
hi guys,
I am writing an application which generates a report with an image
linked from a path in a table.
I have also resized this image based on values in the table.
This application will be deployed as an MDE so the users will not have
access to the report design tools.
What I am thinking of doing is...
Allowing the user to define the position (top and left), size (width
and height) and style (font, weight, colour) for every field on the
report and store this information in a table.
Now for the one report this is relatively straight forward if long
winded because I will need to call the on_format event and pull the
details from the table for each field.
What I would like to do is...
Build an array of all the fields on the report
For each field in the array, find the relevant table record
Apply the formatting.
I could then make this generic for any other reports that I need and
make the form that edits the parameters generic as well.
Two questions:
Has anyone ever done this (Access 2003) and do they have some sample
code
What is the processing overhead likely to be. to load the image seems
to take a little time.
Thanks in advance
Obiron
I am writing an application which generates a report with an image
linked from a path in a table.
I have also resized this image based on values in the table.
This application will be deployed as an MDE so the users will not have
access to the report design tools.
What I am thinking of doing is...
Allowing the user to define the position (top and left), size (width
and height) and style (font, weight, colour) for every field on the
report and store this information in a table.
Now for the one report this is relatively straight forward if long
winded because I will need to call the on_format event and pull the
details from the table for each field.
What I would like to do is...
Build an array of all the fields on the report
For each field in the array, find the relevant table record
Apply the formatting.
I could then make this generic for any other reports that I need and
make the form that edits the parameters generic as well.
Two questions:
Has anyone ever done this (Access 2003) and do they have some sample
code
What is the processing overhead likely to be. to load the image seems
to take a little time.
Thanks in advance
Obiron