macro condition

[Douglas J. Steele]

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.

 

[Steve Schapel]

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

 

[Guest]

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

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?