Search results

Just to restate what I believe I am reading: If you had two records in tblClaimLineItems where the value of curRetail is 100, ran your first code, the curPrice would return 15 & 85 ... is this right? Looking at the code, I do not see how this is possible, but some of my fine friends here may...

My first thought is to have a utility table that holds the value of the ProductID of the record that you selected. Then, in your Excel file, have code on the OnOpen Event query the Access database and get the value and do your search. You may want to put a timestamp on the record in the...

Exactly what I was thinking, Bob.

Hello ladies. I do appreciate your being here. You don't usually see me posting in The Watercooler, especially to a hijacked thread. I hear what you are saying about the sad state of this forum. As you can see from my join date, I have been a member here a long time and have enjoyed the good...

Exactly, because the Britains couldn't keep their backyard clean. We needed to help Britain. Did you want our help or not? As I said, you were getting your a$$ handed to you. This exemplifies that. You posted it ... therefore, you agree with me. I was only saying thanks for finally...

Thank you for making my case. I knew you'd come around eventually.

OK, let's do a quick review of my post from which your response was Surely even you must classify yourself as a moron if you seriously believe there is no evidence here on this forum that you hate everything American. You have been able to hijack any thread you want and turn it into an...

You have not addressed a single thing I have posted. A very weak debator from a very weak position.

That was my point ... can you read? Evidence to support what? What accusation? You argue like a 3 year old ...

To get back to my first objection with this wandering thread, Rich hates everything American and will complain about American involvement, but cries about us not coming in to save them earlier. Make up your mind, you can't have it both ways. Ah, I do miss the days prior to Feb, 2002 when you...

Check your ignorance at the door. While it was a facist state, what was the outcome of their relationship with Hitler. Where did it get them? They ended up in the same place as Austria, another country you saved from Hitler. Great, you almost got North Africa back. Congratulations. All...

Oh yeah, and you guys were doing a great job. You were fabulous at saving us, the French, Italians, Northern Africa ... God Bless the Queen.

So then you actually agree with me, you wanted us there earlier to help save you ...

Yes, I have heard the rumors and I am not going to try to defend a staunch Republican's unscrupulous drive for the dollar. If they are true, I would say that the estate be responsible for contributions to reciprocation trusts. But these are Internet rumors. If there is substance, don't you...

Yes, Nazism grown right in your own backyard. It's almost a given when Rich and Colin start posting ... I've belonged to this forum for years and never commented about how threads perpetually get thrown into anti-American jabs ... Jesus guys ... this gets old.

=IF(A1>40,A1-40,0) Fill this in for Col B

1st problem ... posted in wrong forum ... Other than that, I see nothing wrong. It works for me. Ensure that the name of the field is truly DAYS.

I think you will find your answer here. http://www.access-programmers.co.uk/forums/showthread.php?t=125988&highlight=timestamp

DoCmd.RunSQL SQLText, "UPDATE JobDetails SET JobDetails.password = " & randpass & " WHERE SomeID_Field = xxx"

'lmcginn@ems.atttt.com' rejected by 'smtp.ems.att.com' ... too many t's in the address ...? 'lmcginn@ems.att.com'