Access MVP (2010-2015)


Confirm record count after Excel import…

When importing records from Excel here’s a way you can let the User know they all made it.

Step 1… In your Import code include the UpdateUser() line…

Function ImportMySpreadsheet() Dim lngColumn As Long Dim xlx As Object Dim xlw As Object, xls As Object, xlc As Object Dim dbs As DAO.Database Dim rst As […]

 1,400 total views,  1 views today