How do I archive a report?

[Computer202]

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

[RuralGuy]

You should look into creating a PDF of the report.

[Computer202]

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!

[RuralGuy]

Why do you think the value goes away? Where does the focus go to after the TextBox?

[Computer202]

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

[RuralGuy]

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.

[Computer202]

I knew forms were windows but I only know how to save data in tables :P

[RuralGuy]

You could use a Custom Database Property but I would stick with a table.