Create copy of new record every day

[Guest]

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.

 

[Guest]

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.

 

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

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]

 

[Joseph Meehan]

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.

Are you sure you want to copy records based on the date or could you
really want all the records that hand not previously been copied. I suggest
this because if for some reason someone adds records after the transfer or
if somehow a day get's skipped, you would miss transferring records.

A simple binary field that was switched when the records was copied to
be sent, would handle it.

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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

David

 

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

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]