Cancelling query box popup

[Colin Hayes]

Hi All

I have a query which runs a popup box , using this line in the query
itself

Like [Filter By Which Number?]

I run this via a sendkeys macro through F10.

When I run it , the box comes up and finds the number I need when I fill
it in. However , if I cancel the box I get a 'Halt' box.

Is it possible to avoid this extra halt box , so If I cancel the query ,
it just disappears?

Grateful for any help.

 

[Margaret Bartley]

I have a query which runs a popup box , using this line in the query
itself

Like [Filter By Which Number?]

I run this via a sendkeys macro through F10.

When I run it , the box comes up and finds the number I need when I fill
it in. However , if I cancel the box I get a 'Halt' box.

Is it possible to avoid this extra halt box , so If I cancel the query ,
it just disappears?

That's one reason why people learn VBA.
You can do it in a few lines of code.

 

[Colin Hayes]

I have a query which runs a popup box , using this line in the query
itself

Like [Filter By Which Number?]

I run this via a sendkeys macro through F10.

When I run it , the box comes up and finds the number I need when I fill
it in. However , if I cancel the box I get a 'Halt' box.

Is it possible to avoid this extra halt box , so If I cancel the query ,
it just disappears?

That's one reason why people learn VBA.
You can do it in a few lines of code.

Hi

Thank you Margaret , that's very helpful.

Best wishes.



Are you aware that we also buy CDs, Vinyl and DVDs? Send your lists of
unwanted items to (e-mail address removed) and we’ll quote you a price…


You can browse and buy direct from my full list of items at these addresses :

http://s1.amazon.co.uk/exec/varzea/ts/my-zshop/SPJK3X6KOJZR6/026-3393902-9
050050

or:

http://www.CDandVinyl.co.uk

or :

http://www.netsoundsmusic.com/chayes

or:

http://chayes.musicstack.com



To DOWNLOAD the full catalogue click here :


http://www.chayes.demon.co.uk/CDandVinyl_full_catalogue.exe



Best Wishes ,

Colin Hayes.



TEL / FAX : (UK) (0)208 804 9181

 

[Ed Robichaud]

Skip the macro and sendkeys, just put "Like [Filter By Which Number?]" in
the criteria line of your query In the proper column and without the quotes)
and this parameter query will now pop-up that input box and cancel without
error.

-Ed