|
|
|
#1
03-06-2010, 02:52 AM
|
|||
|
|||
How do I archive a report?
Hi
I am new to this but I have learnt a lot already. My database is based on one table, at the moment I have an expansion which allows the user to search for certain items and create a report. This report produces some totals etc and what I would like to do is be able to SAVE that report and then change/edit the table without altering the report (an archive)  Is this possible, Basically I want to cut the report off from the database but keep it their for archive purposes... I am using Access 2007  Cheers Dan Last edited by Computer202; 03-06-2010 at 06:47 AM. 
|
|
#2
03-06-2010, 03:30 AM
|
||||
|
||||
|
You should look into creating a PDF of the report.
__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07 If your issue is resolved...follow this link for directions on how to use the Solved thread tool! Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"
|
|
#3
03-06-2010, 05:37 AM
|
|||
|
|||
|
Cheers Just what I needed... Just as an extra...
I have a text box which is designed for my user to enter a number... for example 0001 :P when I press enter and exit that text box I want it to keep the value which is doesn't. That value is only relevant to that report Cheers for the original reply I installed the Microsoft Add in for Access 2007!
|
|
#4
03-06-2010, 08:30 AM
|
||||
|
||||
|
Why do you think the value goes away? Where does the focus go to after the TextBox?
__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07 If your issue is resolved...follow this link for directions on how to use the Solved thread tool! Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"
|
|
#5
03-07-2010, 03:40 AM
|
|||
|
|||
|
Not sure what happens but I have been told that the only way to keep the value is to bound the text box, which I am in the process of doing now
Thanks
|
|
#6
03-07-2010, 05:39 AM
|
||||
|
||||
|
You do know that forms do not hold data right? They are just windows into tables where data is actually stored. There are other places where you can store data in a Database as well.
__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07 If your issue is resolved...follow this link for directions on how to use the Solved thread tool! Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"
|
|
#7
03-07-2010, 07:29 AM
|
|||
|
|||
|
I knew forms were windows but I only know how to save data in tables :P
|
|
#8
03-07-2010, 07:58 AM
|
||||
|
||||
|
You could use a Custom Database Property but I would stick with a table.
__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07 If your issue is resolved...follow this link for directions on how to use the Solved thread tool! Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Archive and Compact function | dollygg | Access | 3 | 08-18-2009 01:49 AM |
| query based report question - run report on one record | Skeyelab | Reports | 1 | 02-02-2009 02:52 AM |
| Sub-report backcolor matching alternating row color in main report | postman | Reports | 0 | 10-24-2008 09:20 AM |
| Archive data | markhook | Forms | 0 | 08-08-2006 08:23 AM |
How do I archive a report?
Windows Vista 
Access 2007 (version 12.0)
Linear Mode
