Solved

Access 2013 - Invalid use of Null

Posted on 2013-06-13
3
582 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
ID: 39243887
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
ID: 39244001
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
ID: 39244029
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

896 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

14 Experts available now in Live!

Get 1:1 Help Now