Search results for query: *

Thank you both for your input, you both are obviously right. It looks like there is a problem with my Visual Studio (VB6) work/installation (it is running on Windows 11). When starting, it showed a lot 'Method'~'of Object '_' failed' messages. It didn't load controls properly, it changed...

Hello, I needed to update some calculations in an legacy program; I did my updates in one procedure, but when trying to compile the code, another procedure (see code below) gave an error message saying 'Method or data member not found' for 'ListItem' in this part 'lstSELINV.ListItems.Count'...

Well, I downloaded and installed the MS Access 2000 runtime and the program is working again. It isn't the ideal solution, but it works (those report worked and still work OK if run directly from Access 2003).

If you want your own local copy, you can get it for $49 from this site: https://www.geopostcodes.com/Italy

Hello, I had installed multiple versions of MS Access (2000 and 2003) on my computer. After uninstalling 2000 version I am getting 'Error # 13' when trying to open any MS Access report from my VB6 program. Here is the code (show report): Private Sub Command19_Click() Dim rst As...

Your solution worked - I unchecked the utility.mda in the references and used explicit code as you suggested. Thank you!

Hello, I have troubles to run/convert MS Access database 2000 in 2003 version; after opening in 2003 I am getting error massage "Visual Basic module contains a syntax error" I tried to fix some lines with errors like these: - Dim db As Database, td As TableDef, rs As Recordset (replaced with...

Yes, that was the problem, thanks!

I added the 'Everyone' user with the full copntrol of the 'D:' drive but I am still getting this error message Cannot open backup device 'D:\SQLBackupsDB1_FULL_01242020_105232.BAK'. Operating system error 5(Access is denied.) :-(

Yes, I tried to run the .bat with -S .\SQLEXPRES directly on the server Server .bat sqlcmd -U sa -P pswd -S .\SQLEXPRESS2 -Q "EXEC sp_BackupDatabases @backupLocation ='E:\SQLBackups', @BackupType='F'" Workstation .bat sqlcmd -U sa -P pswd -S DSDI\SQLEXPRESS2 -Q "EXEC sp_BackupDatabases...

Hello, I tried to follow these instructions (see below) in order to backup SQL Express 2017 automatically in three steps (A - stored procedure, B - bat file, C - scheduled task) using T-SQL. Link The first step (Step A) went OK. The next step, B, is failing if run as .bat (sqlcmd -U...

Thanks everybody for your input; I cleaned my code according to the combo's suggestion. I made one more change to my code - I changed i=46 (where actual data started) instead of i=1 and the app worked on Win 10 except the message "Error # 0 was generated by, Error Line 0" after it finished. So...

Yes, max value of both variables, i and j, is no less than 400 (number of lines).

I am sorry for making this threat endless, but I have a good news - major breakthrough LOL I was sable to pass over that line giving me errors before by adding 'xlApp1.Visible = True'; it doesn't make much sense to me but it works. Now I am getting "Error # 6, Error Line: 290, Overflow" The...

No, I don't have a reference to Excel in my 'regular app' I tried to hard code file locations in my 'regular app' but it failed saying error in line 111 (see below) 111 Set wb1 = xlApp1.Workbooks.Open("G:\CUTS\2020\J&G - OCT 2019.xls")

> what happens if you try and open one of the real files directly from within Excel on W10? It opens in both Excel version correctly. Hope this is the right one:

Yes, still the same error even when run as Administrator. A real 'Text1.text' value would be like 'G:\SVR-2\Lilly\Cuts\2020\J&G-Oct 2019.xls' Thx

Is this the right one? No, "c:\test.xls" is just for this testing program; the real program is using another Excel files on different drives, not C:, and those files are changed every month so I cannot hard code those files. This "c:\test.xls" was open using Excel 2007 when tested on Windows...

Thanks for your patience. I couldn't find this entry "Under that CLSID you will find a subkey called LocalServer32" I found "Excel.Application.12" in "HKEY_CLASSES_ROOT\Excel.Application\CurVer" (Windows 10) This small VB6 code works okay (it just opens a specific excel file) on both Windows XP...

Well, for the early binding I am using the "Microsoft Excel 9.0 Object Library" (should work for Excel 2000 in both XP and Windows 10 as both have Excel 2000). However, the late binding version (I hope I used it correctly) gives me the same error on Windows 10 (both versions work on XP).