K
Kimberly3626
I have been asked to revamp a process of creating a 'report' that is
currently taking days in Microsoft Word. At present, the document is
hand-typed, images and captions are put into the report, and changes are
difficult to keep consistent.
Here is the goal:
Create a DB that allows a user to make selections that autofill in
information to generate a 5 page document. Some of this will be easy,
resulting in bulleted lists which I will be able to create. However, they
would like to enter a few text boxes and have access fill the paragraph in
around the blanks in the report.
For example: given a text input of "Brown" and the default text somehow
stored in Access ("The fox is . It ran fast"), my user would like
Access to generate the paragraph: "The fox is brown. It ran fast."
Unfortunately, sometimes the fox will be red, or burnt umber. Therefore, I
will need the paragraph stored in Access to shift to accomodate a larger or
smaller entry in the final report.
In addition, there are pictures and captions in the report that will be
entered by basic users with no knowledge of access. I need a quick easy way
for them to click a button (simulating the 'insert image' button in Word),
select their image off of the drive, and have the path be stored with a
preview. Then, I need them to be able to associate a caption with the image
(not too difficult with MS Help and this forum), to later be spit out as page
2 of the report.
currently taking days in Microsoft Word. At present, the document is
hand-typed, images and captions are put into the report, and changes are
difficult to keep consistent.
Here is the goal:
Create a DB that allows a user to make selections that autofill in
information to generate a 5 page document. Some of this will be easy,
resulting in bulleted lists which I will be able to create. However, they
would like to enter a few text boxes and have access fill the paragraph in
around the blanks in the report.
For example: given a text input of "Brown" and the default text somehow
stored in Access ("The fox is . It ran fast"), my user would like
Access to generate the paragraph: "The fox is brown. It ran fast."
Unfortunately, sometimes the fox will be red, or burnt umber. Therefore, I
will need the paragraph stored in Access to shift to accomodate a larger or
smaller entry in the final report.
In addition, there are pictures and captions in the report that will be
entered by basic users with no knowledge of access. I need a quick easy way
for them to click a button (simulating the 'insert image' button in Word),
select their image off of the drive, and have the path be stored with a
preview. Then, I need them to be able to associate a caption with the image
(not too difficult with MS Help and this forum), to later be spit out as page
2 of the report.