Re: Archive a data*** once finished with

Thanks guys,
I dont know that I worded the question right. I'll just let you know what I
am trying to do.
I am inputting data for customers orders, enquiries, quotes etc. I want to
be able to take completed orders etc from the form & put into a report. The
reason for this is that I dont want numerous orders (complete & incomplete)
to be in the form. I just want incomplete orders. I need to be able to still
view completed orders so that we can refer to old enquies etc of customers if
need be. Im sorry if I am not getting the point but I would of thought that
this would of been achievable in Access.
Thank you both very much for your help.
Tash

"John W. Vinson" wrote:

On Wed, 2 Jul 2008 21:17:00 -0700, Tash <Tash@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

Hi, Im building a database using Access2003 & Im very new at it. I can not
work out (after days of trying) how to archive a form data*** once I have
finished with it. I want the users to be able to access the archived sheets
later if need be.

Bob's absolutely right. If you're "thinking spread***" you won't be making
the best use of Access!

Data is stored in Tables, for as long as it might be useful (usually
permanently, though you can use Delete queries if you want to permanently and
irrevokably destroy data from a table). Forms and Datasheets are NOT THE DATA;
they are just a *window*, a tool that lets you view the data stored in the
tables. So there's no need to "archive" the data***; it's just a dynamic
view of the data in the table, so it can be recreated or rerun at any time.

Here's some additional resources in addition to the excellent ones Bob
suggested:

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]

.

Loading