Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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

    >
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page