'Evening,I've been given a task to create a MS Access db for a community support network, and have run into a small bug. As a part of this, I've created a form for data entry of new people to ...

Dim strsql As String 'this will be your sql statement Set db = CurrentDB 'tell access to use the current database 'assign the sql statement to a string strsql = "SELECT Sum ( [Payments Table].

After transferring an existing workstation configuration to a new computer, a "Microsoft Access can't change the working directory" error may occur when launching Access.

Microsoft is rolling out a fix for a known issue that caused MS Access runtime applications not to open after installing July 2022's Patch Tuesday Office/Access security updates.