replace query message prompts?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • WPW07
    #1

    replace query message prompts?

    Hello,

    I've got a "data import form" that is a simple dialog type form. On
    the form is an "Import" button with code that runs several action
    queries. The queries import data from an Oracle database into various
    staging tables, then appends the data to the main tables in the
    database. Currently, the user has to click yes on all of the query
    prompts (e.g. "are you sure you want to run this type of action
    query?" and "are you sure you want to create a new table with the
    selected records?", etc.

    1. Is there a way to code this so the user doesn't receive all of the
    messages prompting for a yes answer. The default will always be yes.

    2. Instead of seeing all of the prompts, how would I put just one
    message with an hour glass saying, "import process running" Then
    another that says, import process complete?

    Thank you for your help.
    Tags: None
    • Salad
      #2
      Re: replace query message prompts?

      WPW07 wrote:
      Hello,
      >
      I've got a "data import form" that is a simple dialog type form. On
      the form is an "Import" button with code that runs several action
      queries. The queries import data from an Oracle database into various
      staging tables, then appends the data to the main tables in the
      database. Currently, the user has to click yes on all of the query
      prompts (e.g. "are you sure you want to run this type of action
      query?" and "are you sure you want to create a new table with the
      selected records?", etc.
      >
      1. Is there a way to code this so the user doesn't receive all of the
      messages prompting for a yes answer. The default will always be yes.
      >
      2. Instead of seeing all of the prompts, how would I put just one
      message with an hour glass saying, "import process running" Then
      another that says, import process complete?
      >
      Thank you for your help.
      Docmd.SetWarnin gs False
      docmd.openquery
      Docmd.SetWarnin gs True

        Comment

        • WPW07
          #3
          Re: replace query message prompts?

          On Aug 11, 12:29 pm, Salad <o...@vinegar.c omwrote:
          WPW07 wrote:
          Hello,
          >
          I've got a "data import form" that is a simple dialog type form.  On
          the form is an "Import" button with code that runs several action
          queries.  The queries import data from an Oracle database into various
          staging tables, then appends the data to the main tables in the
          database.  Currently, the user has to click yes on all of the query
          prompts (e.g. "are you sure you want to run this type of action
          query?" and "are you sure you want to create a new table with the
          selected records?", etc.
          >
          1.  Is there a way to code this so the user doesn't receive all of the
          messages prompting for a yes answer.  The default will always be yes.
          >
          2.  Instead of seeing all of the prompts, how would I put just one
          message with an hour glass saying, "import process running" Then
          another that says, import process complete?
          >
          Thank you for your help.
          >
          Docmd.SetWarnin gs False
          docmd.openquery
          Docmd.SetWarnin gs True


          Thanks for your reply. If I turn the warnings off, is the default
          answer always yes to the warning prompts?

            Comment

            • fredg
              #4
              Re: replace query message prompts?

              On Mon, 11 Aug 2008 10:02:17 -0700 (PDT), WPW07 wrote:
              On Aug 11, 12:29 pm, Salad <o...@vinegar.c omwrote:
              >WPW07 wrote:
              >>Hello,
              >>
              >>I've got a "data import form" that is a simple dialog type form.  On
              >>the form is an "Import" button with code that runs several action
              >>queries.  The queries import data from an Oracle database into various
              >>staging tables, then appends the data to the main tables in the
              >>database.  Currently, the user has to click yes on all of the query
              >>prompts (e.g. "are you sure you want to run this type of action
              >>query?" and "are you sure you want to create a new table with the
              >>selected records?", etc.
              >>
              >>1.  Is there a way to code this so the user doesn't receive all of the
              >>messages prompting for a yes answer.  The default will always be yes.
              >>
              >>2.  Instead of seeing all of the prompts, how would I put just one
              >>message with an hour glass saying, "import process running" Then
              >>another that says, import process complete?
              >>
              >>Thank you for your help.
              >>
              >Docmd.SetWarni ngs False
              >docmd.openquer y
              >Docmd.SetWarni ngs True
              >
              Thanks for your reply. If I turn the warnings off, is the default
              answer always yes to the warning prompts?
              There are some things you can do for yourself.
              If you had taken just a moment to try this you would not have to wait
              for an answer.
              --
              Fred
              Please respond only to this newsgroup.
              I do not reply to personal e-mail

                Comment

                Previous template Next
                Working...