Welcome to SPN

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

Sign Up Now!

Bypass message??

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

Tags:
  1. Jim

    Jim
    Expand Collapse
    Guest

    I have a macro which overwrites an object. When the macro is clicked
    it gives a message asking if I want to replace the existing file
    (Yes/No). Is there a way to have 'Yes' automatically selected and run,
    thereby bypassing having to click on it everytime?

    Thanks

    Jim
     
  2. Loading...

    Similar Threads Forum Date
    SIKH WOMEN: Bypassed by history but why? Hard Talk Dec 6, 2013
    Sikh News Sikh school bypasses French secular laws (Australian Broadcasting Corporation) Breaking News Sep 15, 2007
    How message of love from Sikh gurus are helping Pakistani Christians to fight forced conversions Sikh Sikhi Sikhism Oct 12, 2015
    Messages from God Sikh Sikhi Sikhism Aug 23, 2015
    Message of Guru Granth Sahib Essays on Sikhism Jan 30, 2014

  3. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    Setwarnings False
    .... ' your existing command(s)
    SetWarnings trrue

    HTH

    Pieter

    "Jim" <james.tischuk@ge.com> wrote in message
    news:1148303131.765433.193810@j73g2000cwa.googlegroups.com...
    >I have a macro which overwrites an object. When the macro is clicked
    > it gives a message asking if I want to replace the existing file
    > (Yes/No). Is there a way to have 'Yes' automatically selected and run,
    > thereby bypassing having to click on it everytime?
    >
    > Thanks
    >
    > Jim
    >
     
  4. xingxing

    xingxing
    Expand Collapse
    Guest

    ?????
    "Jim" <james.tischuk@ge.com> ????
    news:1148303131.765433.193810@j73g2000cwa.googlegroups.com...
    > I have a macro which overwrites an object. When the macro is clicked
    > it gives a message asking if I want to replace the existing file
    > (Yes/No). Is there a way to have 'Yes' automatically selected and run,
    > thereby bypassing having to click on it everytime?
    >
    > Thanks
    >
    > Jim
    >
     
  5. AFSSkier

    AFSSkier
    Expand Collapse
    Guest

    SetWarnings to False (No in 97) does not work when export to an existing file
    (Excel). SetWarnings to False works great for the other Access warnings.

    Is there something else that can be done?
    --
    Thanks, Kevin


    "Pieter Wijnen" wrote:

    >
    > Setwarnings False
    > .... ' your existing command(s)
    > SetWarnings trrue
    >
    > HTH
    >
    > Pieter
    >
    > "Jim" <james.tischuk@ge.com> wrote in message
    > news:1148303131.765433.193810@j73g2000cwa.googlegroups.com...
    > >I have a macro which overwrites an object. When the macro is clicked
    > > it gives a message asking if I want to replace the existing file
    > > (Yes/No). Is there a way to have 'Yes' automatically selected and run,
    > > thereby bypassing having to click on it everytime?
    > >
    > > Thanks
    > >
    > > Jim
    > >

    >
    >
    >
     
  6. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    Switch to using VBA, rather than a macro. You can check whether the file
    exists, and delete it if it does.

    If Len(Dir(strFullPathToFile)) > 0 Then
    Kill strFullPathToFile
    End If

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no private e-mails, please)


    "AFSSkier" <AFSSkier@discussions.microsoft.com> wrote in message
    news:312EB685-CADD-4348-AA1B-931ECCF21FA9@microsoft.com...
    > SetWarnings to False (No in 97) does not work when export to an existing
    > file
    > (Excel). SetWarnings to False works great for the other Access warnings.
    >
    > Is there something else that can be done?
    > --
    > Thanks, Kevin
    >
    >
    > "Pieter Wijnen" wrote:
    >
    >>
    >> Setwarnings False
    >> .... ' your existing command(s)
    >> SetWarnings trrue
    >>
    >> HTH
    >>
    >> Pieter
    >>
    >> "Jim" <james.tischuk@ge.com> wrote in message
    >> news:1148303131.765433.193810@j73g2000cwa.googlegroups.com...
    >> >I have a macro which overwrites an object. When the macro is clicked
    >> > it gives a message asking if I want to replace the existing file
    >> > (Yes/No). Is there a way to have 'Yes' automatically selected and run,
    >> > thereby bypassing having to click on it everytime?
    >> >
    >> > Thanks
    >> >
    >> > Jim
    >> >

    >>
    >>
    >>
     

Share This Page