Alex & Access

April 23, 2014

Access 2013 SP1 Runtime

Filed under: Access 2013 — access @ 11:44 am

The Microsoft Access 2013 Runtime enables you to distribute Access 2013 applications to users who do not have the full version of Access 2013 installed on their computers. Now version 2013 SP1 is available for download

April 16, 2014

How to detect, if you are running 64-bit Office

Filed under: Access 2010, Access 2013 — access @ 10:54 am

New data type LongPtr is Long integer on 32-bit systems and LongLong integer on 64-bit systems, by checking it VarType you can find out on what environments you run your VBA code:

Function Is64BitOffice() As Boolean
    Dim lp As LongPtr
    Is64BitOffice = Not (VarType(lp) = vbLong)
End Function

This trick I learned from fellow MVP Brent Spaulding

March 20, 2014

Navigation Pane in Access 2010

Filed under: Access 2010, Access 2013 — access @ 10:51 am

Get lost with Access Navigation pane? Here some great tips from Albert D. Kallal how to be even more productive with the navigation pane in Access 2010: Become friends with the nav pane in 2010

February 26, 2014

Office 2013 Service Pack 1

Filed under: Access 2013 — access @ 10:01 am

Microsoft has announced availability of Service Pack 1 (SP1) for the Office 2013 and SharePoint 2013. According to Issues Fixed by Service Pack 1 several Access crashes were fixed, the only new feature introduced with SP1 is "Access app developers can now upgrade the apps they have made available in the Store or a corporate catalog".

Blog at WordPress.com.