Welcome to SPN

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

Sign Up Now!

macro query cancel causes error

Discussion in 'Information Technology' started by Alex Pavluck, Nov 3, 2005.

  1. Alex Pavluck

    Alex Pavluck
    Expand Collapse
    Guest

    >-----Original Message-----
    >I'm using a command button on a form to launch a macro,
    >which in turn opens a query. That's because I don't see
    >an option to directly launch a query from a command
    >button, without the intermediate step of using a macro to
    >open the query. I imagine launching a query directly from
    >the button can be done in VBA code but I don't know how.
    >
    >My problem is this. The query has a built in prompt (text
    >in brackets under "criteria" in query design view) which
    >opens a little dialog box that prompts the user to enter
    >which Order Number to search for in this case.
    >
    >The query runs fine when opened *directly* without the
    >intermediate step of using a macro to open the query, in
    >that I can click on cancel when the dialog box appears,
    >and the action cancels without an error message.
    >
    >The query also runs fine from the command button's macro,
    >with one exception. If you click on cancel when the
    >dialog box appears prompting for Order Number to search
    >for, there is an error message window titled "Action
    >Failed" which pops open.
    >
    >In the Action Failed window it has the following lines:
    >
    >MacroName:
    >macFindOrder
    >
    >Condition:
    >True
    >
    >ActionName:
    >OpenQuery
    >
    >Arguments:
    >qryFindOrder, Datasheet, Edit
     
  2. Loading...

    Similar Threads Forum Date
    Microcosm and Macrocosm Gurmat Vichaar Mar 20, 2009
    Adobe Unruffled by Macromedia Restatement (AP) Interfaith Dialogues May 4, 2005
    Macromedia Flash animation and designing. Interfaith Dialogues Oct 21, 2004
    Query about Jhatka Meat by Shooting in Head Sikh Sikhi Sikhism Aug 26, 2011
    Who is a sikh? A non sikh friend's query!! Sikh Sikhi Sikhism Apr 30, 2010

  3. Kernow Girl

    Kernow Girl
    Expand Collapse
    Guest

    Hi Alex - you did not say what ver of Access you are running, and I don't
    know if it will help your error, but in ver 2002 there is an option when
    creating your command button to Run Query rather than Run Macro.
    yrs - Dika
    Kernow Girl

    "Alex Pavluck" wrote:

    > >-----Original Message-----
    > >I'm using a command button on a form to launch a macro,
    > >which in turn opens a query. That's because I don't see
    > >an option to directly launch a query from a command
    > >button, without the intermediate step of using a macro to
    > >open the query. I imagine launching a query directly from
    > >the button can be done in VBA code but I don't know how.
    > >
    > >My problem is this. The query has a built in prompt (text
    > >in brackets under "criteria" in query design view) which
    > >opens a little dialog box that prompts the user to enter
    > >which Order Number to search for in this case.
    > >
    > >The query runs fine when opened *directly* without the
    > >intermediate step of using a macro to open the query, in
    > >that I can click on cancel when the dialog box appears,
    > >and the action cancels without an error message.
    > >
    > >The query also runs fine from the command button's macro,
    > >with one exception. If you click on cancel when the
    > >dialog box appears prompting for Order Number to search
    > >for, there is an error message window titled "Action
    > >Failed" which pops open.
    > >
    > >In the Action Failed window it has the following lines:
    > >
    > >MacroName:
    > >macFindOrder
    > >
    > >Condition:
    > >True
    > >
    > >ActionName:
    > >OpenQuery
    > >
    > >Arguments:
    > >qryFindOrder, Datasheet, Edit

    >
    >
     

Share This Page