By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,197 Members | 1,207 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,197 IT Pros & Developers. It's quick & easy.

An Easy Question

P: n/a
I would like to design a database. it is a very simple database.

I want to enter information and then have it produc documents. The
documents are templates and will be the same everytime. It will help
reduce the find and replace kind of thing.

So...I would need an entry screen asking for about 20 items of
info...and this info is automatically placed in the templates and saved
as a file (or files) automatically grabbing info from the fields to
create the file name.
Is Access the thing to do this with?

Thanks,

Tim

Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
It sounds like you need to store the info in appropriate tables, have a form
that can call up the info you need and print a report (template) that
conains the info you chose in the form. If you need help setting this up,
contact me at my email address below. I could have this up and running for
you quickly for a very reasonable fee.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

<ti****@gmail.com> wrote in message
news:11*********************@c13g2000cwb.googlegro ups.com...
I would like to design a database. it is a very simple database.

I want to enter information and then have it produc documents. The
documents are templates and will be the same everytime. It will help
reduce the find and replace kind of thing.

So...I would need an entry screen asking for about 20 items of
info...and this info is automatically placed in the templates and saved
as a file (or files) automatically grabbing info from the fields to
create the file name.
Is Access the thing to do this with?

Thanks,

Tim

Nov 13 '05 #2

P: n/a
In message <11*********************@c13g2000cwb.googlegroups. com>,
ti****@gmail.com writes
I would like to design a database. it is a very simple database.

I want to enter information and then have it produc documents. The
documents are templates and will be the same everytime. It will help
reduce the find and replace kind of thing.

So...I would need an entry screen asking for about 20 items of
info...and this info is automatically placed in the templates and saved
as a file (or files) automatically grabbing info from the fields to
create the file name.
Is Access the thing to do this with?


It sounds like the sort of thing Access is used for. You might also be
able to do the same thing using Word. Do you need to store the data
after the document has been created?

--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.

Nov 13 '05 #3

P: n/a
We would need to store the client data after the docs are created.

I thought of Excel and Word together thought Access would do it a bit
easier...so I could scale with minimal training.

Tim

Nov 13 '05 #4

P: n/a
In message <11**********************@z14g2000cwz.googlegroups .com>,
ti****@gmail.com writes
We would need to store the client data after the docs are created.

I thought of Excel and Word together thought Access would do it a bit
easier...so I could scale with minimal training.


From your description I would say that you should look at storing the
data in Access and either building Access reports or Word mailmerges.
Either could be automated. I would expect the decision which approach to
use to depend on the complexity of the final document. For instance if
you want data to be inserted into the middle of a paragraph with mixed
fonts then Word is probably the best output method. If the layout is
relatively simple then Access reports should handle it. Without seeing
the documents you want to produce that's about as much advice as I can
offer.

--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.

Nov 13 '05 #5

P: n/a
ti****@gmail.com wrote:
I would like to design a database. it is a very simple database.

I want to enter information and then have it produc documents. The
documents are templates and will be the same everytime. It will help
reduce the find and replace kind of thing.

So...I would need an entry screen asking for about 20 items of
info...and this info is automatically placed in the templates and saved as a file (or files) automatically grabbing info from the fields to
create the file name.
Is Access the thing to do this with?

Thanks,

Tim


I created the following with Access 97 without using any pdf printer
drivers:

http://www.oakland.edu/~jafortun/SampleBillOfLading.pdf

Access stores the data when a 'Post' command button is clicked. Post
back if you'd like more information about using this technique. My
program even grabs info from one of the fields to create the file name
like you suggest. Many other techniques such as using pdf forms can
also provide what you are looking for.

James A. Fortune

Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.