Invalid use of null error

**aman1234** · 10-01-2013, 05:39 AM

Hi guys

I am getting an error message at the following line of code. Any help would be much appreciated.

strsql = "select sum(cases) as [Total Letters] from tblmain where tdate >= #" & Format(DateSerial(ComboBox3, ComboBox2, ComboBox1), "mm/dd/yyyy") & "# and tdate <= #" & Format(DateSerial(ComboBox6, ComboBox5, ComboBox4), "mm/dd/yyyy") & "# AND type='GH'"
rs.Open strsql, cn

  Label5.Caption = rs.Fields(0).Value 
rs.Close

Thanks
Aman

**OllieB** · 10-01-2013, 05:49 AM

Aman,

Where to start;
- is the cn object valid?
- is the rs object valid?
- is a record returned by the sql statement?

If you answered all questions with yes then try

Label5.Caption = rs.Fields(0).Value & ""

**aman1234** · 10-01-2013, 06:06 AM

Thanks Ollie. It worked perfectly.

**OllieB** · 10-01-2013, 06:16 AM

You are welcome. May I please ask you to mark this thread as solved and remember that you can click the star icon to add to my reputation if you are happy with my contribution.

Invalid use of null error

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Invalid use of null error

Re: Invalid use of null error

Re: Invalid use of null error

Re: Invalid use of null error

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Run-time error 94; Invalid use of Null

[SOLVED] VBA - runtime error 94, invalid use of null

Run Time Error: 94 (invalid use of null)

Invalid use of null error

Run Time Error '94' Invalid use of null

Bookmarks

Bookmarks

Posting Permissions