Database replacing data on own (2000)

[Leesha]

Hans, I know its an unsatisfactory work around but I've got to come up with something that makes getting to these reports easier for the end user who presently is typing the name in when the query prompts her and if the name is spelled wrong etc. she gets nothing. Presently with the number thing going on its a useless form. I'm not even sure if the work around would do the trick but its all I could come up with during the few hours I stepped away from this. Honestly, I'd rather be coding in Excel. My brain thinks like Excel and I could work around this so much easier. This is driving me freaking nuts!

Leesha

[Leesha]

Oh God, that was at about the 8 hour mark when I was brain dead! I must've misunderstood. I'm glad you're not here in the states as I can feel your hands around my neck. You're either a very patient man or just put your fist through the wall. I'll go try this AGAIN!

Humbly,
Leesha

[Leesha]

I'm near tears with giddy relief. It works. Well, chalk it up to a major learning experience?!?!?!?!

Thank you!

Leesha

[HansV]

I'm glad you didn't have to resort to that ugly workaround!

[Leesha]

Tee hee, SO am I!! I wasn't about to let this thing beat me, so one way or another I was gonna find a way to make it work even I died trying. Honestly, it was hard enough sending you my code to laugh at, to have to admit that I was thinking of this work around almost killed me!!! Whew!! St. Jude (patron St. of Hopeless Causes - as in my coding) must've been listen for your sake!

Thanks again. I'm now off to try the parameter stuff you sent me earlier but told me not to do until I took a break. I did take a break, actually ate and now I'm back at it again. Lets hope this goes easier. At least it isn't a show stopper!

Leesha