User Tools

Site Tools


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:49] – [PtrSafe Access adjustment for 64 bit] superwizardsoftware:microsoft:access [2021/10/11 00:32] (current) – [Can t find project or library] superwizard
Line 34: 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 304: 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.1633571387.txt.gz · Last modified: 2021/10/07 01:49 by superwizard