Category Archives: MS Access

MS Access VBA: Get/set Javascript Variable in Microsoft Web Browser ActiveX Control

In your MS Access application, if you are using Microsoft Web browser, we may have to interact with the Javascript variable inside the loaded page. There is no obvious method exists in the Web browser control but using the following trick you can get/set the Javascript variable in the webpage. Quick Tip: Add Javascript function… Read More »

Change MS Access application title and icon using VBA

Here is a code to change MS Access application title and icon using VBA. This code also sets the application icon as form and report default icon. Dim db As Database Set db = CurrentDb db.Properties("AppIcon").Value = CurrentProject.Path & "\Bee.ico" db.Properties("AppTitle").Value = msgMainTitle db.Properties("UseAppIconForFrmRpt").Value = True Application.RefreshTitleBar Click here for list of all properties exposed… Read More »

how to assign recordset to the recordset property of listbox?

set me.List0.Recordset = rs.clone rs.close by this way the new recordset will be assigned to the list and the original will be closed. Vishal MonparaVishal Monpara is a full stack Solution Developer/Architect with 13 years of experience primarily using Microsoft stack. He is currently working in Retail industry and moving 1’s and 0’s from geographically… Read More »