Null in recordset vba

It works, but isn't necessarily the optimum way to do it. Laugh at my attempt if you want Code:. With rsRecordSet ' convert recordset null values to zeroes. Fields If IsNull objfield. Value Then. Edit objfield. Update End If Next objfield. MoveNext Loop. MoveFirst ' further actions, end with, etc Ruddles Well-known Member.

Joined Aug 24, Messages 5, Click to expand Last edited: Apr 6, You must log in or register to reply here. Similar threads E. Replies 3 Views Apr 28, RoryA.

Replies 0 Views Aug 1, UnDePlusieurs. Pmk Aug 22, Excel Questions 2. Replies 10 Views 1K. Aug 23, jasonb Question PowerQuery performance discussion. Login details for this Free course will be emailed to you. Article by Jeevan A Y.

Please select the batch. Cookies help us provide, protect and improve our products and services. By using our website, you agree to our use of cookies Privacy Policy. Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums. NET Managed Providers. NET managed providers, especially System. SqlClient, System. Odbc and System. Sign in to vote.