Replies

thank you

well I didn

I basically wanted 1 macro associated with the onClick event of 2 buttons, the problem was the macro must recognize which button was clicked, I had trouble wrapping my head around how to specify a condition that would distinguish between either of buttons & which one was the active one (the one clicked) The condition I specified in my last post was an attempt at making a condition I thought would work but is not acceptable by access.

my bad you can

never mind I fixed it, I was using the wrong name DOH!

thank you!

Unfortunately, no Charlotte, did not make any change at all.

no Charlotte, If Not .NoMatch Then did not make any difference.
Mark, I only tested your code for 1 field, refNum & that comes from a query, a concatenation of 2 number fields. InvoiceNum, the one I didn

Hi Mark,
I tried your suggestion but the .noMatch=True criteria is set for all values I query on, whether they

well I did exactly as you said & then did tools/send and receive/pop.mail.yahoo.com because I have hotmail set there as the default in outlook express.

I get an error message that the connection to the server failed. Account

excellent thank you very much, I

why wud microsoft do such a stupid thing at their site? I mean, who wants to read in landscape, are you positive there

when I do the above & click ok, a blank file opens, & then I open whatever file I want from the file/open menu. When I close this new file, I get the error message

thanks Dreamy!

using access97 & it’s basically a switchboard w/buttons on it. the swtichboard opens 2 forms & only 1 of these forms can be open at one time, not both. that’s what i’m trying to achieve in vba unless there’s some better solution, i don’t think modal applies does it?