|
|
|
date: Wed, 2 Jul 2008 21:17:00 -0700,
group: microsoft.public.access.gettingstarted
back
Re: Archive a datasheet 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
> 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]
>
date: Thu, 3 Jul 2008 17:03:01 -0700
author: Tash
Re: Archive a datasheet once finished with
On Thu, 3 Jul 2008 17:03:01 -0700, Tash
wrote:
>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.
Achievable, and easy; but it has nothing whatsoever to do with "archiving
datasheets", which is what you originally asked.
You can do this a couple of ways. One would be to base the Form, not on your
Table, but on a Query selecting only incomplete orders.
Another would be to set the Form's Filter to select only incomplete orders.
This would let you put a command button on the form to choose whether to
display all orders or only incomplete orders.
--
John W. Vinson [MVP]
date: Thu, 03 Jul 2008 18:15:05 -0600
author: John W. Vinson
Re: Archive a datasheet once finished with
Thankyou so much, I knew it would of been easy I just couldnt get my head
around it as Im only just starting to use this program. Im sorry I worded it
incorrectly.
Thanks again
"John W. Vinson" wrote:
> On Thu, 3 Jul 2008 17:03:01 -0700, Tash
> wrote:
>
> >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.
>
> Achievable, and easy; but it has nothing whatsoever to do with "archiving
> datasheets", which is what you originally asked.
>
> You can do this a couple of ways. One would be to base the Form, not on your
> Table, but on a Query selecting only incomplete orders.
>
> Another would be to set the Form's Filter to select only incomplete orders.
> This would let you put a command button on the form to choose whether to
> display all orders or only incomplete orders.
> --
>
> John W. Vinson [MVP]
>
date: Thu, 3 Jul 2008 17:30:00 -0700
author: Tash
|
|
