Solved

Access 2013 - Invalid use of Null

Posted on 2013-06-13
3
579 Views
Last Modified: 2013-06-13
Has anybody found that queries that worked in previous versions of Access, stop working in Access 2013, due to "Invalid use of Null"?

Any fixes besides adding NZ or finding the nulls?
0
Comment
Question by:tbsgadi
3 Comments
 
LVL 22

Expert Comment

by:Kelvin Sparks
Comment Utility
I haven't stuck it but would be interested to see the SQL of an example.

Kelvin
0
 
LVL 77

Assisted Solution

by:peter57r
peter57r earned 250 total points
Comment Utility
Can't say I've noticed this happening.

My impression  (no evidence) is that Access has got less tolerant of 'bad' designs since A2007 .
If your data can contain Nulls then you must cater for it.
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 250 total points
Comment Utility
2013 moved to using SQL Server as the default database, so you'll likely find issues like this start to crop up as more people move to the new version.

I agree with Peter's observation - newer versions of access are far less tolerant of sketchy coding practices and syntax. A good example of that is the OpenReport issue many (including myself) found when moving to 2007

DoCmd.OpenReport "MyReport, acViewPreview, "Customer='Bob'"

This would work in earlier versions but began to fail in 2007. The 3rd argument is the "Filter" argument, and Access expected to find the name of a query there. The 4th argument is the "Where" argument, and these codes needed to be rewritten as such:

DoCmd.OpenReport "MyReport, acViewPreview, ,"Customer='Bob'"

Including a blank space for the Filter argument.

I assume that
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now