[MS_AccessPros] Dcount syntax question

 

Hello

I have a dcount expression on the form load event that puts the count of a table on the caption of a button. In the code the second line works great, but I would like to add a word at the beginning of the dcount and everything I have tried has stopped the form from loading. Is it possible to add a word before the dcount? The first line is the one that does not work.

Private Sub Form_Load()

cmdEditEmailAddr.Caption = DCount("Edit "& " " & "[EmailAddress]", "tblAccounts", "EmailAddress Is Null") & " " & "Empty email addresses"

'cmdEditEmailAddr.Caption = DCount("[EmailAddress]", "tblAccounts", "EmailAddress Is Null") & " " & "Empty email addresses"

End Sub

Thank You

 

Jim Wagner

---

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___