Welcome to SPN

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

Sign Up Now!

auto answer on system message

Discussion in 'Information Technology' started by VB, Nov 7, 2005.

  1. VB

    VB
    Expand Collapse
    Guest

    when I create table using VB there is system 'yes no' message asking to
    create a table or not.

    how can I switch it off or automatically answer yes not to let users to
    interupt?

    thanks
     
  2. Loading...

    Similar Threads Forum Date
    Opinion Is Autocomplete Evil? Some Women Take A Hard Look at Google ! Breaking News Nov 7, 2013
    Sikh News AutoZone sued for firing Everett Sikh Breaking News Sep 29, 2010
    India Singh: Centre Ready To Give Kashmir Autonomy Breaking News Aug 11, 2010
    India Paste tariff cards behind driver’s seat: Transport dept to automen Breaking News Jul 21, 2010
    Gursharan Kaur: India's First Lady's Autobiography Sikh Personalities Jun 1, 2010

  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Sun, 6 Nov 2005 16:27:56 -0800, "VB" <VB@discussions.microsoft.com>
    wrote:

    >when I create table using VB there is system 'yes no' message asking to
    >create a table or not.
    >
    >how can I switch it off or automatically answer yes not to let users to
    >interupt?
    >
    >thanks


    In your code (VB? or VBA?) put a line

    DoCmd.SetWarnings True

    before the table creation event; and

    DoCmd.SetWarnings False

    afterward. Or, use the querydef's Execute method.

    John W. Vinson[MVP]
     

Share This Page