What the heck is a "compile error"?

[Guest]

When I add a find button (binoculars) to my form & then try to use it in form
view, a visual basic window opens up. (Editor's note - I am intimidated by
visual basic.) The error message displayed says: COUNT ([#CyclesChemo]) FROM
[tblPatients] WHERE ([#CyclesChemo] =NotNull;

What does this mean?

 

[Arvin Meyer [MVP]]

Are you sure it doesn't say:

SELECT COUNT ([#CyclesChemo]) FROM [tblPatients] WHERE ([#CyclesChemo]
=NotNull;

If not, try changing it to the above. The code is counting the number of
instances of chemo-therapy cycles in the patient's table where that field
has a value.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Douglas J Steele]

Shouldn't that be

SELECT COUNT ([#CyclesChemo]) FROM [tblPatients] WHERE ([#CyclesChemo] Is
Not Null;

?

And in actual fact, the WHERE clause shouldn't be required. From the Help
file:

"The Count function doesn't count records that have Null fields unless expr
is the asterisk (*) wildcard character. If you use an asterisk, Count
calculates the total number of records, including those that contain Null
fields."

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Are you sure it doesn't say:

SELECT COUNT ([#CyclesChemo]) FROM [tblPatients] WHERE ([#CyclesChemo]
=NotNull;

If not, try changing it to the above. The code is counting the number of
instances of chemo-therapy cycles in the patient's table where that field
has a value.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

When I add a find button (binoculars) to my form & then try to use it in form
view, a visual basic window opens up. (Editor's note - I am intimidated by
visual basic.) The error message displayed says: COUNT ([#CyclesChemo]) FROM
[tblPatients] WHERE ([#CyclesChemo] =NotNull;

What does this mean?

 

[Arvin Meyer [MVP]]

Shouldn't that be

Yep. Cut and paste strikes once again. Thanks, Doug.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access