Error: You cancelled the previous operation (No I didn't!)

#1 (**permalink**) 28-Jul-2006, 08:35 AM

Hi All,

This line of code, which sits within a function, in a module (Access
2003)...
MsgBox (DLookup("[gas_standing_charge]", "tbl_constants"))

Is causing this error...
"You cancelled the previous operation"

Don't geddit! Any ideas anyone?

Thanks!
Simon.

--
-
* Please reply to group for the benefit of all
* Found the answer to your own question? Post it!
* Get a useful reply to one of your posts?...post an answer to another one
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13250-error-you-cancelled-previous-operation-no.html
* Search first, post later : http://www.google.co.uk/groups
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13250
* Want my email address? Ask me in a post...Cos2MuchSpamMakesUFat!

#2 (**permalink**) 28-Jul-2006, 08:35 AM

The message indicates that one of the arguments is invalid.

Either there is no table named tbl_contants, or the table does not have a
field named gas_standing_charge.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Simon Harris" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13250
news:%237Aq3%230pGHA.1548@TK2MSFTNGP04.phx.gbl...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13250
> Hi All,
>
> This line of code, which sits within a function, in a module (Access
> 2003)...
> MsgBox (DLookup("[gas_standing_charge]", "tbl_constants"))
>
> Is causing this error...
> "You cancelled the previous operation"
>
> Don't geddit! Any ideas anyone?
>
> Thanks!
> Simon.