Welcome to SPN

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

Sign Up Now!

Recording Warnings In Access

Discussion in 'Information Technology' started by Pradeep, Jul 28, 2006.

  1. Pradeep

    Pradeep
    Expand Collapse
    Guest

    Hello,

    I have a procedure which performs various activities like running action
    queries, executing TransferSpreadSheets and a few OutputTo commands. At the
    begining of the procedure there is a DoCmd.SetWarnings False statement and
    the end there is a DoCmd.SetWarnings True statement. Considering this
    scenario I would want to keep track of warnings that might have been
    generated between a:

    DoCmd.SetWarnings False

    and a

    DoCmd.SetWarnings True

    Please Suggest.

    Thanks,

    Pradeep
     
  2. Loading...

    Similar Threads Forum Date
    Sakhis 26 New Katha Recordings on G. Sant Singh Ji Maskeen Website History of Sikhism Oct 2, 2010
    1984 Court resumes recording of statements in ’84 Sikh riots History of Sikhism Sep 30, 2010
    1984 '84 riots case: Court defers recording statement of victim History of Sikhism Jul 7, 2010
    Kirtan Live Recording from Harmandir Sahib Videos Oct 10, 2009
    Siri Guru Granth Sahib English Translation Audio Recording Discourses in English Mar 21, 2009

  3. Nick Coe \(UK\)

    Nick Coe \(UK\)
    Expand Collapse
    Guest

    IIRC you can't intercept those warnings.

    --
    Nick Coe (UK)
    http://www.alphacos.co.uk/ AccHelp is now Free
    http://www.mrcomputersltd.com/ Repairs Upgrades

    In news:726BCA6C-DCBB-4C24-8200-FEDC1BD01A14@microsoft.com,
    Pradeep typed:
    > Hello,
    >
    > I have a procedure which performs various activities like
    > running action queries, executing TransferSpreadSheets and
    > a
    > few OutputTo commands. At the begining of the procedure
    > there
    > is a DoCmd.SetWarnings False statement and the end there
    > is a
    > DoCmd.SetWarnings True statement. Considering this
    > scenario I
    > would want to keep track of warnings that might have been
    > generated between a:
    >
    > DoCmd.SetWarnings False
    >
    > and a
    >
    > DoCmd.SetWarnings True
    >
    > Please Suggest.
    >
    > Thanks,
    >
    > Pradeep
     
  4. Guest

    Guest
    Expand Collapse
    Guest

    If you really want this, you should switch to DAO or ADO
    actions, and use the RecordCount and RecordsAffected properties.

    It will be more than twice as much work.

    (david)

    "Pradeep" <Pradeep@discussions.microsoft.com> wrote in message
    news:726BCA6C-DCBB-4C24-8200-FEDC1BD01A14@microsoft.com...
    > Hello,
    >
    > I have a procedure which performs various activities like running action
    > queries, executing TransferSpreadSheets and a few OutputTo commands. At

    the
    > begining of the procedure there is a DoCmd.SetWarnings False statement and
    > the end there is a DoCmd.SetWarnings True statement. Considering this
    > scenario I would want to keep track of warnings that might have been
    > generated between a:
    >
    > DoCmd.SetWarnings False
    >
    > and a
    >
    > DoCmd.SetWarnings True
    >
    > Please Suggest.
    >
    > Thanks,
    >
    > Pradeep
     
  5. Pradeep

    Pradeep
    Expand Collapse
    Guest

    Hello David,

    It is very interesting and would like to know how we could record warnings
    with the RecordCount and the RecordsAffected properties.

    Could you please explain it in detail so that I can try and see if the task
    can be accomplished.

    Thanks,

    Pradeep

    "david@epsomdotcomdotau" wrote:

    > If you really want this, you should switch to DAO or ADO
    > actions, and use the RecordCount and RecordsAffected properties.
    >
    > It will be more than twice as much work.
    >
    > (david)
    >
    > "Pradeep" <Pradeep@discussions.microsoft.com> wrote in message
    > news:726BCA6C-DCBB-4C24-8200-FEDC1BD01A14@microsoft.com...
    > > Hello,
    > >
    > > I have a procedure which performs various activities like running action
    > > queries, executing TransferSpreadSheets and a few OutputTo commands. At

    > the
    > > begining of the procedure there is a DoCmd.SetWarnings False statement and
    > > the end there is a DoCmd.SetWarnings True statement. Considering this
    > > scenario I would want to keep track of warnings that might have been
    > > generated between a:
    > >
    > > DoCmd.SetWarnings False
    > >
    > > and a
    > >
    > > DoCmd.SetWarnings True
    > >
    > > Please Suggest.
    > >
    > > Thanks,
    > >
    > > Pradeep

    >
    >
    >
     
  6. david epsom dot com dot au

    david epsom dot com dot au
    Expand Collapse
    Guest

    The warnings are generated partly from the RecordCount and
    RecordsAffected properties.

    For example, the warning 'this will update 5 records' is
    generated from the Records Affected property.

    If you wish to record that the update affected 5 records,
    the only way is to use ADO or DAO, and record the RecordsAffected
    property.

    The warning '5 updates failed' is a kind of error message
    that is not normally displayed. There may be a way to capture
    these error messages, but I don't know about that. But you
    can simulate that kind of error message by selecting the
    records affected first, recording the RecordCount, then
    running the update and recording the RecordsAffected.

    (david)

    "Pradeep" <Pradeep@discussions.microsoft.com> wrote in message
    news:ECDB87DF-FC18-4A24-BE9B-1AADC9EC3406@microsoft.com...
    > Hello David,
    >
    > It is very interesting and would like to know how we could record warnings
    > with the RecordCount and the RecordsAffected properties.
    >
    > Could you please explain it in detail so that I can try and see if the
    > task
    > can be accomplished.
    >
    > Thanks,
    >
    > Pradeep
    >
    > "david@epsomdotcomdotau" wrote:
    >
    >> If you really want this, you should switch to DAO or ADO
    >> actions, and use the RecordCount and RecordsAffected properties.
    >>
    >> It will be more than twice as much work.
    >>
    >> (david)
    >>
    >> "Pradeep" <Pradeep@discussions.microsoft.com> wrote in message
    >> news:726BCA6C-DCBB-4C24-8200-FEDC1BD01A14@microsoft.com...
    >> > Hello,
    >> >
    >> > I have a procedure which performs various activities like running
    >> > action
    >> > queries, executing TransferSpreadSheets and a few OutputTo commands. At

    >> the
    >> > begining of the procedure there is a DoCmd.SetWarnings False statement
    >> > and
    >> > the end there is a DoCmd.SetWarnings True statement. Considering this
    >> > scenario I would want to keep track of warnings that might have been
    >> > generated between a:
    >> >
    >> > DoCmd.SetWarnings False
    >> >
    >> > and a
    >> >
    >> > DoCmd.SetWarnings True
    >> >
    >> > Please Suggest.
    >> >
    >> > Thanks,
    >> >
    >> > Pradeep

    >>
    >>
    >>
     
  7. Pradeep

    Pradeep
    Expand Collapse
    Guest

    David,

    Like I said earlier, the procedure has numerous statements like Action
    Queries, TransferSpreadSheet and OutputTo statements. Now I would not really
    know which statement has caused the warning like:

    Is it the TransferSpreadSheet
    or
    Is it the Action Query
    Or
    Is it the OutPutTo statement

    In which I cannot really formulate the message and then append it with the
    records affected property, if I understood your suggestion properly.

    Thanks,

    Pradeep


    "david epsom dot com dot au" wrote:

    > The warnings are generated partly from the RecordCount and
    > RecordsAffected properties.
    >
    > For example, the warning 'this will update 5 records' is
    > generated from the Records Affected property.
    >
    > If you wish to record that the update affected 5 records,
    > the only way is to use ADO or DAO, and record the RecordsAffected
    > property.
    >
    > The warning '5 updates failed' is a kind of error message
    > that is not normally displayed. There may be a way to capture
    > these error messages, but I don't know about that. But you
    > can simulate that kind of error message by selecting the
    > records affected first, recording the RecordCount, then
    > running the update and recording the RecordsAffected.
    >
    > (david)
    >
    > "Pradeep" <Pradeep@discussions.microsoft.com> wrote in message
    > news:ECDB87DF-FC18-4A24-BE9B-1AADC9EC3406@microsoft.com...
    > > Hello David,
    > >
    > > It is very interesting and would like to know how we could record warnings
    > > with the RecordCount and the RecordsAffected properties.
    > >
    > > Could you please explain it in detail so that I can try and see if the
    > > task
    > > can be accomplished.
    > >
    > > Thanks,
    > >
    > > Pradeep
    > >
    > > "david@epsomdotcomdotau" wrote:
    > >
    > >> If you really want this, you should switch to DAO or ADO
    > >> actions, and use the RecordCount and RecordsAffected properties.
    > >>
    > >> It will be more than twice as much work.
    > >>
    > >> (david)
    > >>
    > >> "Pradeep" <Pradeep@discussions.microsoft.com> wrote in message
    > >> news:726BCA6C-DCBB-4C24-8200-FEDC1BD01A14@microsoft.com...
    > >> > Hello,
    > >> >
    > >> > I have a procedure which performs various activities like running
    > >> > action
    > >> > queries, executing TransferSpreadSheets and a few OutputTo commands. At
    > >> the
    > >> > begining of the procedure there is a DoCmd.SetWarnings False statement
    > >> > and
    > >> > the end there is a DoCmd.SetWarnings True statement. Considering this
    > >> > scenario I would want to keep track of warnings that might have been
    > >> > generated between a:
    > >> >
    > >> > DoCmd.SetWarnings False
    > >> >
    > >> > and a
    > >> >
    > >> > DoCmd.SetWarnings True
    > >> >
    > >> > Please Suggest.
    > >> >
    > >> > Thanks,
    > >> >
    > >> > Pradeep
    > >>
    > >>
    > >>

    >
    >
    >
     
  8. david epsom dot com dot au

    david epsom dot com dot au
    Expand Collapse
    Guest

    > Is it the TransferSpreadSheet
    > or
    > Is it the Action Query
    > Or
    > Is it the OutPutTo statement


    If you really want this, you should switch to DAO or ADO
    actions, and use the RecordCount and RecordsAffected properties.

    It will be more than twice as much work.

    (david)

    "Pradeep" <Pradeep@discussions.microsoft.com> wrote in message
    news:1801F29D-A38D-41AE-93A5-83108848401D@microsoft.com...
    > David,
    >
    > Like I said earlier, the procedure has numerous statements like Action
    > Queries, TransferSpreadSheet and OutputTo statements. Now I would not
    > really
    > know which statement has caused the warning like:
    >
    > Is it the TransferSpreadSheet
    > or
    > Is it the Action Query
    > Or
    > Is it the OutPutTo statement
    >
    > In which I cannot really formulate the message and then append it with the
    > records affected property, if I understood your suggestion properly.
    >
    > Thanks,
    >
    > Pradeep
    >
    >
    > "david epsom dot com dot au" wrote:
    >
    >> The warnings are generated partly from the RecordCount and
    >> RecordsAffected properties.
    >>
    >> For example, the warning 'this will update 5 records' is
    >> generated from the Records Affected property.
    >>
    >> If you wish to record that the update affected 5 records,
    >> the only way is to use ADO or DAO, and record the RecordsAffected
    >> property.
    >>
    >> The warning '5 updates failed' is a kind of error message
    >> that is not normally displayed. There may be a way to capture
    >> these error messages, but I don't know about that. But you
    >> can simulate that kind of error message by selecting the
    >> records affected first, recording the RecordCount, then
    >> running the update and recording the RecordsAffected.
    >>
    >> (david)
    >>
    >> "Pradeep" <Pradeep@discussions.microsoft.com> wrote in message
    >> news:ECDB87DF-FC18-4A24-BE9B-1AADC9EC3406@microsoft.com...
    >> > Hello David,
    >> >
    >> > It is very interesting and would like to know how we could record
    >> > warnings
    >> > with the RecordCount and the RecordsAffected properties.
    >> >
    >> > Could you please explain it in detail so that I can try and see if the
    >> > task
    >> > can be accomplished.
    >> >
    >> > Thanks,
    >> >
    >> > Pradeep
    >> >
    >> > "david@epsomdotcomdotau" wrote:
    >> >
    >> >> If you really want this, you should switch to DAO or ADO
    >> >> actions, and use the RecordCount and RecordsAffected properties.
    >> >>
    >> >> It will be more than twice as much work.
    >> >>
    >> >> (david)
    >> >>
    >> >> "Pradeep" <Pradeep@discussions.microsoft.com> wrote in message
    >> >> news:726BCA6C-DCBB-4C24-8200-FEDC1BD01A14@microsoft.com...
    >> >> > Hello,
    >> >> >
    >> >> > I have a procedure which performs various activities like running
    >> >> > action
    >> >> > queries, executing TransferSpreadSheets and a few OutputTo commands.
    >> >> > At
    >> >> the
    >> >> > begining of the procedure there is a DoCmd.SetWarnings False
    >> >> > statement
    >> >> > and
    >> >> > the end there is a DoCmd.SetWarnings True statement. Considering
    >> >> > this
    >> >> > scenario I would want to keep track of warnings that might have been
    >> >> > generated between a:
    >> >> >
    >> >> > DoCmd.SetWarnings False
    >> >> >
    >> >> > and a
    >> >> >
    >> >> > DoCmd.SetWarnings True
    >> >> >
    >> >> > Please Suggest.
    >> >> >
    >> >> > Thanks,
    >> >> >
    >> >> > Pradeep
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>
     

Share This Page