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
software:microsoft:access [2017/04/06 04:20] – superwizardsoftware:microsoft:access [2021/10/11 00:32] (current) – [Can t find project or library] 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> 
 +
 +Also
 +
 +2021-10-09
 +
 +TRIM() not found? Compile error: Can't find project or library in Excel 2007
 +
 +From <https://social.msdn.microsoft.com/Forums/office/en-US/608c32c1-3d47-47f4-a6ff-893b4695db20/trim-not-found-compile-error-cant-find-project-or-library-in-excel-2007?forum=exceldev> 
 +
 + 
 +Answer: **On the VBA window go to Tools->References and uncheck the MISSING references.**
 +
 +    ClosedXML - Create Excel files in .Net
 + • Proposed as answer byTim Johnson at AptosFriday, June 6, 2014 5:13 PM
 + • Unproposed as answer byTim Johnson at AptosFriday, June 6, 2014 5:13 PM
 +    Thursday, January 20, 2011 4:54 AM
 +
 +From <https://social.msdn.microsoft.com/Forums/office/en-US/608c32c1-3d47-47f4-a6ff-893b4695db20/trim-not-found-compile-error-cant-find-project-or-library-in-excel-2007?forum=exceldev> 
 +
 +
 +</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 332:
 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.1491452429.txt.gz · Last modified: 2017/04/06 04:20 by superwizard