RE: Witango-Talk: Dumb Microsoft Error

[Ted Wolfley]

In VBA and Access Basic, you can use the function NZ([field name) to turn null fields into a zero for number fields or a blank for a text field. -----Original Message----- From: Thomas Ferguson [mailto:[EMAIL PROTECTED]] Sent: Monday, August 12, 2002 4:31 PM To: Multiple recipients of list witango-talk Subject: RE: Witango-Talk: Dumb Microsoft Error Fact Sheets & Bulletins: Database Results Error Description: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'CatID='. Number: -2147217900 (0x80040E14) Source: Microsoft OLE DB Provider for ODBC Drivers One or more form fields were empty. You should provide default values for all form fields that are used in the query -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Campbell, Steve V. Sent: Monday, August 12, 2002 4:14 PM To: Multiple recipients of list witango-talk Subject: RE: Witango-Talk: Dumb Microsoft Error Here we go again, and I know that probably the same good souls on this list has drilled this error into my thick skull. What is this error denoting, any help would be appreciated!   Thanks   -3100 [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'No Show'. 37000 ---------------------------------------------------------------------------------------------   Steve Campbell OU Physicians Internet Software Developer/Web Manager University of Oklahoma Health Sciences Center 800 Northeast 15th Street ROB #601 Oklahoma City, Oklahoma 73172 o -405-271-4647 x54163 f -405-271-1217 c -405-226-4901 p -405-690-9703      CONFIDENTIALITY NOTICE: This e-mail, including any attachments, contains information from The University of Oklahoma College of Medicine, which may be confidential or privileged.  The information is intended to be for the use of the individual or entity named above.  If you are not the intended recipient, be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited.   If you have received this email in error, please notify the sender immediately by "reply to sender only" message and destroy all electronic and hard copies of the communication, including attachments. -----Original Message-----