Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Create copy of new record every day

Discussion in 'Information Technology' started by David, Nov 1, 2005.

  1. David

    David
    Expand Collapse
    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.
     
  2. Loading...


  3. tezza

    tezza
    Expand Collapse
    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.

    "David" wrote:

    > 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.
     
  4. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Mon, 31 Oct 2005 09:11:47 -0800, "David"
    <David@discussions.microsoft.com> wrote:

    >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]
     
  5. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    David wrote:
    > 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.

    --
    Joseph Meehan

    Dia duit
     
  6. David

    David
    Expand Collapse
    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

    "tezza" wrote:

    > 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.
    >
    > "David" wrote:
    >
    > > 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.
     
  7. David

    David
    Expand Collapse
    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

    "John Vinson" wrote:

    > On Mon, 31 Oct 2005 09:11:47 -0800, "David"
    > <David@discussions.microsoft.com> wrote:
    >
    > >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]
    >
     
  8. David

    David
    Expand Collapse
    Guest

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

    David

    "Joseph Meehan" wrote:

    > David wrote:
    > > 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.
    >
    > --
    > Joseph Meehan
    >
    > Dia duit
    >
    >
    >
     
  9. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Wed, 2 Nov 2005 04:20:02 -0800, "David"
    <David@discussions.microsoft.com> wrote:

    >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]
     

Share This Page