Category : vba

My problem is that the fujitsu ix500 ADF scanner does not support WIA and TWAIN drivers and thus cannot be called from MS-ACCESS or MS-EXCEL via scanDiag.ShowAcquireImage(). The fujitsu driver application "scanmanager" (C:Program Files (x86)PFUScanSnapDriverPfuSsMon.exe) is located in the Windows system tray and is started automatically with Windows. A click with the RIGHT mousebutton on ..

Read more

System Update Required cannot open database connection wrong username and password Greetings everyone i have the following issue with restaurant management system that is programmed in C# connected with Microsoft Access database (2019), the program is work correctly in main developer laptop while we transfer the files to target or other PC or Laptop the ..

Read more

This Works: If I run these two commands in manually opened cmd window, or PowerShell window, both give the expected results. w32tm /stripchart /computer:time.nist.gov /dataonly /samples:3 /rdtsc /period:1 ntpq -p The second, ntpq -p, is bundled with NTP windows software from the home of the Network Time Protocol project that gives similar information to windows’ ..

Read more

EDIT: more debugging… ntpq -p works if I do .exec instead of .run, but then of course can’t hid the cmd window. Extra test code at the end. This Works: If I run these two commands in manually opened cmd window, or PowerShell window, both give the expected results. w32tm /stripchart /computer:time.nist.gov /dataonly /samples:3 /rdtsc ..

Read more

I need to read entries from old-fashioned INI-file with a DLL and after some manipulation export them to VBA code. The c++ code for the function looks like this: BSTR __stdcall GetSectionEntry(LPCSTR sSection, LPCSTR sEntry) { LPCTSTR gszINIfilename = "C:testtest.ini"; TCHAR localStr[64]; GetFileAttributes(gszINIfilename); if (INVALID_FILE_ATTRIBUTES == GetFileAttributes(gszINIfilename) && GetLastError() == ERROR_FILE_NOT_FOUND) { bstr_t bstrt = ..

Read more