Alex & Access

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

Create a free website or blog at WordPress.com.