Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Convert all null data in table/recordset into non-nulls
Well... some background: The overall purpose of converting nulls in this dataset is because I need to pass all of the data into a function that does not accept null values. Although I have the function set up to accept variant values, the function returns an error if any null exists in the...- LLYTLE
- Post #7
- Forum: Microsoft: Access Modules (VBA Coding)
-
Convert all null data in table/recordset into non-nulls
Your solution definitely places me on the right track. I have only a little experience with referencing objects. As the code stands, I have gotten an error message for the statement: "If rstfld.Value Is Null Then" Error message: Error '424' Object required. What piece of code am...- LLYTLE
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Convert all null data in table/recordset into non-nulls
Currently, I am trying to write code to programmatically convert null values into non-nulls for various data types. In the present method, I have to name each field individually and recode using a sql statement. Ideally, I would like to programmatically cycle through the recordset and...- LLYTLE
- Thread
- Replies: 7
- Forum: Microsoft: Access Modules (VBA Coding)
