Marcus Hall

User Tools

Site Tools

Trace:
software:microsoft:access

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
Next revisionBoth sides next revision
software:microsoft:access [2017/04/06 04:20] – superwizardsoftware:microsoft:access [2021/10/07 21:20] – [How to solve missing MSCAL.OCX reference in Microsoft Access 2010] superwizard
Line 1: Line 1:
 +====== PtrSafe Access adjustment for 64 bit ======
 +
 +2020-02-26
 +
 +
 +Compile error 64-bit
 +
 +Change this
 +
 +    Private Declare Function OpenProcess Lib "kernel32" (ByVal dwDesiredAccess As Long, ByVal bInheritHandle As Long, ByVal dwProcessId As Long) As Long
 +    Private Declare Function GetExitCodeProcess Lib "kernel32" (ByVal hProcess As Long, lpExitCode As Long) As Long
 +
 +to this and it will compile on both 32-bit and 64-bit
 +
 +<code>
 +#If Win64 Then
 +    Private Declare PtrSafe Function OpenProcess Lib "kernel32" (ByVal dwDesiredAccess As Long, ByVal bInheritHandle As Long, ByVal dwProcessId As Long) As Long
 +    Private Declare PtrSafe Function GetExitCodeProcess Lib "kernel32" (ByVal hProcess As Long, lpExitCode As Long) As Long
 +#Else
 +    Private Declare Function OpenProcess Lib "kernel32" (ByVal dwDesiredAccess As Long, ByVal bInheritHandle As Long, ByVal dwProcessId As Long) As Long
 +    Private Declare Function GetExitCodeProcess Lib "kernel32" (ByVal hProcess As Long, lpExitCode As Long) As Long
 +#End If
 +</code>
 +From <https://stackoverflow.com/questions/6255750/how-do-i-convert-this-program-to-work-on-a-64-bit-machine> 
 +
 +
 +2020-02-20
 +
 +Compile error
 +
 +
 + 
 +Private Declare Function WaitForSingleObject Lib "kernel32" (ByVal _
 +    hHandle As Long, ByVal dwMilliseconds As Long) As Long
 +    
 +====== Can t find project or library ======
 +<WRAP center round box >
 +
 +
 +        dtFMSProcessingDate = Date
 +        
 +        
 +        MsgBox VBA.Date
 +
 +From <https://stackoverflow.com/questions/31575414/access-vba-date-function-not-working> 
 +
 +</WRAP>
 +
 +
 +        
 +
 ====== How to display Access query results without having to create temporary query? ====== ====== How to display Access query results without having to create temporary query? ======
  
Line 262: Line 313:
 From: http://community.spiceworks.com/how_to/show/5517-how-to-solve-missing-mscal-ocx-reference-in-microsoft-access-2010 From: http://community.spiceworks.com/how_to/show/5517-how-to-solve-missing-mscal-ocx-reference-in-microsoft-access-2010
  
-    However note, that the solution specified is a work-around for the above problem. Microsoft has stated that the Calendar control feature is deprecated in Access 2010 and has suggested a number of options for replacing it. See the link referenced at the bottom of this page for more details+From: https://social.msdn.microsoft.com/Forums/office/en-US/fd1d449e-d39c-4c0b-99ea-ed561d8906ce/mscalocx-microsoft-calendar-control-conversion-to-mscomct2ocx?forum=exceldev 
 + 
 +    However note, that the solution specified is a work-around for the above problem. Microsoft has stated  
 +    that the Calendar control feature is deprecated in Access 2010 and has suggested a number of options  
 +    for replacing it. See the link referenced at the bottom of this page for more details
          
     Centerport     Centerport
-    +   
 +   
 +    I. Click on the Windows Start menu and select 'Run'  
 +    II. In the Run command window enter: 
 +       regsvr32 %SystemRoot%\syswow64\mscal.ocx  
 +    III. Select OK to execute the command  
 ====== Forms: Date Picker without ActiveX ====== ====== Forms: Date Picker without ActiveX ======
  
software/microsoft/access.txt · Last modified: 2021/10/11 00:32 by superwizard