Create copy of new record every day

D

David

Hi,

I have a database with only one table.
I would like to create every day a file automatically with the new records
of that day, so that I can send it by e-mail, instead of sending everyday the
complete database.
Is that possible?

Thanks in advance.
 
T

tezza

Hi,
Do the records in your table contain a date that you can latch on to?
If they do, then you can simply write a make table query that selects all
the records in your database with the 'date' equal to today or
format(Now(),"dd/mm/yy").
Run the query and it should create a table that only contains those records.
 
J

John Vinson

Hi,

I have a database with only one table.
I would like to create every day a file automatically with the new records
of that day, so that I can send it by e-mail, instead of sending everyday the
complete database.
Is that possible?

Thanks in advance.
Click to expand...

What will the recipients be doing with this information? Printing it
out, just reading it, using it in their own database, editing it and
sending it back...?

More details please. I'm guessing that generating a Report and
exporting a snapshot image might work but without knowing the purpose
I can't be sure!

John W. Vinson[MVP]
 
D

David

But it has to do the things automatically. That's my big question. How to
do that query and send it to a text file automatically.

David
 
D

David

The table has phone numbers, so the user just wants the new numbers inserted
in a text file, then to use it as he wants (that I'm not sure).
The main problem is how can I do this automatically.

David
 
D

David

That's not really very important. The main thing is to do it automatically.

David
 
J

John Vinson

The table has phone numbers, so the user just wants the new numbers inserted
in a text file, then to use it as he wants (that I'm not sure).
The main problem is how can I do this automatically.
Click to expand...

Take a look at the VBA help file under the heading "TransferText".
Basically you'll want to use a Macro or (better) VBA code to export
the data in the query to an external .txt file; the manual way to do
this is File... Export, but it can be automated using TransferText.

John W. Vinson[MVP]
 
Top