Archive a datasheet once finished with

  • Thread starter Thread starter Tash
  • Start date Start date
T

Tash

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.
 
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

__________________________________
 
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.
Click to expand...

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
 
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
 
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.
Click to expand...

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.
 
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
 
Back
Top