software:microsoft:access
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
software:microsoft:access [2017/04/06 04:20] – superwizard | software:microsoft:access [2021/10/11 00:31] – [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 " | ||
+ | Private Declare Function GetExitCodeProcess Lib " | ||
+ | |||
+ | to this and it will compile on both 32-bit and 64-bit | ||
+ | |||
+ | < | ||
+ | #If Win64 Then | ||
+ | Private Declare PtrSafe Function OpenProcess Lib " | ||
+ | Private Declare PtrSafe Function GetExitCodeProcess Lib " | ||
+ | #Else | ||
+ | Private Declare Function OpenProcess Lib " | ||
+ | Private Declare Function GetExitCodeProcess Lib " | ||
+ | #End If | ||
+ | </ | ||
+ | From < | ||
+ | |||
+ | |||
+ | 2020-02-20 | ||
+ | |||
+ | Compile error | ||
+ | |||
+ | |||
+ | |||
+ | Private Declare Function WaitForSingleObject Lib " | ||
+ | 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 < | ||
+ | |||
+ | Also | ||
+ | |||
+ | 2021-10-09 | ||
+ | |||
+ | TRIM() not found? Compile error: Can't find project or library in Excel 2007 | ||
+ | |||
+ | From < | ||
+ | |||
+ | |||
+ | On the VBA window go to Tools-> | ||
+ | |||
+ | ClosedXML - Create Excel files in .Net | ||
+ | • Proposed as answer byTim Johnson at AptosFriday, | ||
+ | • Unproposed as answer byTim Johnson at AptosFriday, | ||
+ | Thursday, January 20, 2011 4:54 AM | ||
+ | |||
+ | From < | ||
+ | |||
+ | |||
+ | </ | ||
+ | |||
+ | |||
+ | | ||
+ | |||
====== 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:// | From: http:// | ||
- | | + | From: https:// |
+ | |||
+ | | ||
+ | | ||
+ | | ||
| | ||
Centerport | Centerport | ||
- | | + | |
+ | |||
+ | I. Click on the Windows Start menu and select ' | ||
+ | II. In the Run command window enter: | ||
+ | | ||
+ | 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