Re: Archive a datasheet once finished with

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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 datasheet 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 spreadsheet" 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 datasheet; 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]

.

Relevant Pages

  • Re: How to backup XP and no-webview
    ... copy of the installer CD as long as I use it for this computer with my ... I dont mind having more power, and all of that, but I dont ... want or need this nonsense using up resources. ... I was trying to find some place that stocked memory cards to upgrade when ...
    (microsoft.public.windowsxp.basics)
  • Re: assignment delays?
    ... The whole point is that I dont want to start these tasks from day 1 of the project but further on in the schedule, say in a couple of months. ... It is not a matter of resources availability either, theses tasks will be started later on, there is no rush for them to be done yet. ... "Jackie" wrote in message ...
    (microsoft.public.project)
  • Re: Roles Groups Question
    ... The obvious one which springs to mind is the use of Groups and Roles. ... somethwere which someone has already dont the hard work. ... for any ideas on approach or resources. ...
    (microsoft.public.dotnet.languages.vb)
  • Roles Groups Question
    ... The obvious one which springs to mind is the use of Groups and Roles. ... somethwere which someone has already dont the hard work. ... for any ideas on approach or resources. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Moss with Active/Active SQL 2005
    ... I dont know anyone who has done this - I'm keen to see if you get a response ... as I asked this question at in the MVP private groups and got nothing back. ... geogrpahical locations as the MOSS devices. ... the databases in difference geographical locations. ...
    (microsoft.public.sharepoint.portalserver)