Sql Question

[JamesJ]

Trying to return records if the record has data in Email field with the
on the OnClick of a command button:

Dim strSQL As String

strSQL = "SELECT * FROM tblContacts WHERE (Email<>IsNull)"
Me.RecordSource = strSQL

It's not working and I'm getting a headache.

Any help will be appreciated,
James

 

[Dirk Goldgar]

Trying to return records if the record has data in Email field with the
on the OnClick of a command button:

Dim strSQL As String
strSQL = "SELECT * FROM tblContacts WHERE (Email<>IsNull)"
Me.RecordSource = strSQL

It's not working and I'm getting a headache.

Try this:

strSQL = "SELECT * FROM tblContacts WHERE (Email Is Not Null)"

 

[Douglas J. Steele]

strSQL = "SELECT * FROM tblContacts WHERE Is Not Null"

 

[JamesJ]

Got it.

Thanks to all,
James

Try this:

strSQL = "SELECT * FROM tblContacts WHERE (Email Is Not Null)"

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[JamesJ]

Thanks much,

James

strSQL = "SELECT * FROM tblContacts WHERE Is Not Null"


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


[QUOTE="JamesJ"]
Trying to return records if the record has data in Email field with the
on the OnClick of a command button:

Dim strSQL As String
strSQL = "SELECT * FROM tblContacts WHERE (Email<>IsNull)"
Me.RecordSource = strSQL

It's not working and I'm getting a headache.

Any help will be appreciated,
James[/QUOTE]
[/QUOTE]