This one was a tricky request. What I had was a recordset from a query in MS Access. I needed to create a report where when printed it would create one PDF file per record. MS Access has the...
Recent Posts
Use this bit of VBA to create a list of Excel sheet name. - EASY Just add this code in VBA to the ThisWorkbook node and press F5 Sub ListSheetNamesInNewWorkbook() Dim objNewWorkbook As...
If you find Windows 10 file explorer will not refresh there is a registry setting that will solve this problem for you. You can find the original post here Here's the down and dirty. Open...
Over the past week my access to network shares has been incredibly slow - viewing, uploading, and downloading - just awful. The fix that worked for me was to make and entry into the registry. ...
Here are a couple steps to find what version of .Net you have on your machine. This is for Windows 10... From the command prompt type reg query "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET...
Here's a function that will close all object in MS Access using VBA Function closeAll() Dim aob As AccessObject With CurrentData ' "Tables" For Each aob In .AllTables If aob.IsLoaded...