Archive a datasheet once finished with
in [Getting Started]
|
From: Tash on 3 Jul 2008 00:17 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.
From: boblarson on 3 Jul 2008 04:03 This isn't like Excel where you have a self-contained worksheet. The datasheet view is only a view of a table. Your design should NOT be making tables for each "time you need something." I think you need to read a few things first: http://r937.com/relational.html http://support.microsoft.com/kb/283878 http://www.functionx.com/access2003/index.htm -- Bob Larson Access MVP Access World Forums Administrator Utter Access VIP Tutorials at http://www.btabdevelopment.com __________________________________ "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.
From: John W. Vinson on 3 Jul 2008 12:14 On Wed, 2 Jul 2008 21:17:00 -0700, Tash <Tash(a)discussions.microsoft.com> 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]
From: Tash on 3 Jul 2008 20:03 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(a)discussions.microsoft.com> > 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] >
From: John W. Vinson on 3 Jul 2008 20:15
On Thu, 3 Jul 2008 17:03:01 -0700, Tash <tash(a)discussions.microsoft.com> 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] |