Access vba if recordset is null

Below are some useful excel articles related to VBA —. Forgot Password? Free Excel Course. Login details for this Free course will be emailed to you. Article by Jeevan A Y. It makes sense that they would--just because one field contains a null value doesn't negate the row's purpose within the context of the domain.

If you want to exclude null values in a count, specify the field in the form Count field. The result of both forms may or may not be the same. The point is, the field-specific form won't consider null values in its count.

Otherwise, Jet excludes the row from the results. This behavior is inherent in the equality issue discussed in 3. Because Null doesn't equal anything, it can't satisfy a condition other than Is Null. For instance, the simple expression. Now, that might be what you want, but it might not. If you want to include null values, include Is Null in the condition as follows:. Instead, Jet sorts null values to the top or the bottom of the result set, depending on the sort order.

For instance, the following query includes records where the Region field is Null:. The result isn't right or wrong, it just might not be what you want. You must explicitly exclude null values. There's no specific method for explicitly excluding null values. The statement's purpose will dictate the solution.

A null value is an acceptable value. However, too many null values often point to an unnormalized table. For instance, if you store customer phone and fax numbers, you might end up with a lot of empty fax number fields. Even if you have no null values, your table's still not normalized properly, in this case. To normalize the phone data, you'd add a table that includes three fields: the foreign key column that relates the phone record to its corresponding customer, the phone number type, and the phone number.

The phone number type would identify the phone number as an office, fax, home, cell, and so on. Then, you'd enter phone number records only when appropriate, eliminating null values.

If the customer has no fax, there'd be no record for a fax number. Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals. Editor's Picks. The best programming languages to learn in Check for Log4j vulnerabilities with this simple-to-use script. TasksBoard is the kanban interface for Google Tasks you've been waiting for. Paging Zefram Cochrane: Humans have figured out how to make a warp bubble.

Viewed 1k times. Add a comment. Active Oldest Votes. If rs. You could also use the recordcount property to see if you have records: IF rs.

See documentation here: msdn. Use the rs. RecordCount property. IF rs. Gene Gene 6 6 silver badges 13 13 bronze badges.

Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name.