Please Help

T

T. Burr

Here is a quick run down of my problem.

I want to use a form to enter data into a table that I will use to generate
a report. I managed to get that set up and working, but I want to
clear/delete the table of all information after every use so that everytime
you can enter different information without having to worry about getting old
information from the last time.

How do I create and delete a new table each time, or clear the table that I
have of all information?

Please help I've been stuck on this for 2 days now and I am so close to
being done it hurts.
 
D

DebbieG

Are you wanting to create a new RECORD after you have saved a record?


| Here is a quick run down of my problem.
|
| I want to use a form to enter data into a table that I will use to generate
| a report. I managed to get that set up and working, but I want to
| clear/delete the table of all information after every use so that everytime
| you can enter different information without having to worry about getting old
| information from the last time.
|
| How do I create and delete a new table each time, or clear the table that I
| have of all information?
|
| Please help I've been stuck on this for 2 days now and I am so close to
| being done it hurts.
 
R

Rick B

Now why would you add all that data only to delete it?

Just store a date when you add the record and then use that date to select
today's records only.

That is assuming that you will wnat to keep the data. If you truly don't
want to store the data for later use, then there are other ways to handle
your situation. Typically, Access would be used to
store/manipulate/evaluate data over time, not just for the current session.
(That is not to say there are not valid reasons to do what you ask, just
uncommon.)

Post back if you truly want to clear the data each time.

Rick B
 
V

Vic.

Rick,
can you please help me creating User Interactive report in MS Excel?
I have no clue where to begin.
thanks.
 
T

T. Burr

The form will be used to create a equipment transfer sheet. I am pulling all
of the static equipment data from one table and for each piece of equipment
getting the user to input all of the other data that is variable. Since
there could be more than one piece being transfered I need to be able to
store the variable data until after the report is generated and mailed out.
After that it becomes useless data that won't be used again so I want to get
rid of it so that it doesn't clog up the database.

Let me know if I need to get into more detail. If I need to I'm willing to
send a copy of what I have done to help with understanding the problem.
 
T

T. Burr

The form will be used to create a equipment transfer sheet. I am pulling all
of the static equipment data from one table and for each piece of equipment
getting the user to input all of the other data that is variable. Since
there could be more than one piece being transfered I need to be able to
store the variable data until after the report is generated and mailed out.
After that it becomes useless data that won't be used again so I want to get
rid of it so that it doesn't clog up the database.
 
R

Rick B

Well, if you only need it for the report, then you don't have to save it in
a table. You can pull data from an open form into the report when the
"print report" button is clicked.

After the report is completed, they can close the form and any unbound data
will be lost.


Rick B
 
T

T. Burr

Will that work if I will be having more than one entry with different data
for each entry? If so how?
 
R

Rick B

Ummm probably not.

I'm guessing that you will be "transferring" more than one line item and you
ened to print details for each item?

You may need to store it as you previously mentioned. Unfortunately, I have
never worked with this scenario. Hopefully one of the others will have a
suggestion for you.


Sorry I could not be of more help.

Rick B
 
T

T. Burr

Thanks for trying.

Rick B said:
Ummm probably not.

I'm guessing that you will be "transferring" more than one line item and you
ened to print details for each item?

You may need to store it as you previously mentioned. Unfortunately, I have
never worked with this scenario. Hopefully one of the others will have a
suggestion for you.


Sorry I could not be of more help.

Rick B
Click to expand...
 
T

T. Burr

The form will be used to create a equipment transfer sheet. I am pulling all
of the static equipment data from one table and for each piece of equipment
getting the user to input all of the other data that is variable. Since
there could be more than one piece being transfered I need to be able to
store the variable data for each piece of equipment until after the report is
generated and mailed out. After that it becomes useless data that won't be
used again and I want to get rid of it so that it doesn't clog up the
database.
 
T

T. Burr

I thought about your posts a bit more and I think you gave me the answer and
didn't even realize it. I think I can add date/time stamps to each entry
plus "On Open" and "On Unload" using "=Now()". Then just set up a "Delete
Query" base on those times. I'm trying it now. Thank you.
 
Top