Database used to make work orders and purchase orders

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chip Smith - 26 Jan 2008 03:40 GMT

i would like to make a database that could hold information like a customers
name, address, phone, etc. then within the database either by button or thru
word, have it dump that information into a workorder or purchase order
template i've already made. and then after the workorder had been created and
saved, have that file associated with that customer in the database either in
a new field or by clicking on the customer and bringing up all the associated
documents

Signature

--Chip Smith--

Reply to this Message

John W. Vinson - 26 Jan 2008 05:29 GMT

>i would like to make a database that could hold information like a customers
>name, address, phone, etc. then within the database either by button or thru
[quoted text clipped - 3 lines]
>a new field or by clicking on the customer and bringing up all the associated
>documents

Ok. What would you like the unpaid volunteers here to do? Implement this
rather complex application for you?

What is the "template"? An Access Report would be simplest; if this is a Word
document or something else you may be costing yourself a lot more work than
you're saving.

Take a look at the Northwind sample database, and/or check out the
introductory tutorials below. Access can get your job done, but maybe not
exactly in the way you're visualizing.

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

John W. Vinson [MVP]

Reply to this Message