macro condition

  • Thread starter Thread starter Guest
  • Start date Start date
Steve's "munged" his address so that the harvesters won't get it and sell it
to the spammers.

Replace -at- with @, and -dot- with a period.
 
Katherine,

I have received your database file.

You had told me that the Waterfront Number field is a Number data type.
It isn't. It is a Text data type. Therefore, your macro Condition
shopuld read...
DCount("*","Employees","[Waterfront Number]='" & [Waterfront Number] &
"'")>0
 
Yes Steve it works now. I thank you so much. This is the first time that I
used this discussion forum and I must say it was well worth it. Thanks again.

Katherine Clark

Steve Schapel said:
Katherine,

I have received your database file.

You had told me that the Waterfront Number field is a Number data type.
It isn't. It is a Text data type. Therefore, your macro Condition
shopuld read...
DCount("*","Employees","[Waterfront Number]='" & [Waterfront Number] &
"'")>0

--
Steve Schapel, Microsoft Access MVP
I don't think its too big. Am I to type the email as you type it?
Click to expand...
Click to expand...
 
Back
Top