In general, queries shouldn't be affected by conversion to 64-bit but newer versions of Access don't always accept code that worked in earlier versions.
If you do have APIs, them you will indeed need to convert them. However, the conditional compilation is the last post was incorrect and won't work correctly in 64-bit Access.
It should have been (changes shown in RED):
Code:
#If VBA7 Then 'Access 2010 or later (32/64-bit)
Private Declare PtrSafe Function GetSystemMenu Lib "user32" (ByVal hWnd As LongPtr, ByVal bRevert As Long) As LongPtr
#Else
Private Declare Function GetSystemMenu Lib "user32" (ByVal hWnd As Long, ByVal bRevert As Long) As Long
#End If
If all users are running A2010 or later, you can omit the conditional compilation and just have:
Code:
Private Declare PtrSafe Function GetSystemMenu Lib "user32" (ByVal hWnd As LongPtr, ByVal bRevert As Long) As LongPtr