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 [2021/10/07 01:48] – [PtrSafe Access adjustment for 64 bit] superwizardsoftware:microsoft:access [2021/10/11 00:32] (current) – [Can t find project or library] superwizard
Line 8: Line 8:
 Change this 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 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+    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 to this and it will compile on both 32-bit and 64-bit
  
 +<code>
 #If Win64 Then #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 OpenProcess Lib "kernel32" (ByVal dwDesiredAccess As Long, ByVal bInheritHandle As Long, ByVal dwProcessId As Long) As Long
Line 20: Line 21:
     Private Declare Function GetExitCodeProcess Lib "kernel32" (ByVal hProcess As Long, lpExitCode As Long) As Long     Private Declare Function GetExitCodeProcess Lib "kernel32" (ByVal hProcess As Long, lpExitCode As Long) As Long
 #End If #End If
 +</code>
 From <https://stackoverflow.com/questions/6255750/how-do-i-convert-this-program-to-work-on-a-64-bit-machine>  From <https://stackoverflow.com/questions/6255750/how-do-i-convert-this-program-to-work-on-a-64-bit-machine> 
  
Line 33: Line 34:
     hHandle As Long, ByVal dwMilliseconds As Long) As Long     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 303: Line 339:
          
     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.1633571311.txt.gz · Last modified: 2021/10/07 01:48 by superwizard