Search results

Sometimes I hate our IT team. This morning I came to my desk early to run some tests, especially the one @sonic8 suggested in #10, only to find out that IT had replaced all the Windows 10 machines with brand-new Windows 11 PCs overnight, including the one that had the problem. :mad: The new...

I'll follow the steps as soon as I'm allowed to work on it. Thanks for the details.

Yes, that's true. As I mentioned in #1 I had to replace the connections string to SQLOLEDB to be able to open the connection. I just noticed that the PC that fails to connect with MSOLEDBSQL, is running on Windows 10. All other PCs with no problem are on Windows 11. Maybe it's an some weird OS...

This explains why the following fails: stCon = "ODBC;DRIVER={ODBC Driver 18 for SQL Server};SERVER=Server;DATABASE=MyDB;Trusted_Connection=Yes;TrustServerCertificate=Yes;Encrypt=Yes But still I wonder why this one can not open the connection: stCon =...

I just noticed that we have the same (the following) connection string for Microsoft Access linked tables to the same sql server and the same database and it works just fine in the PC that shows error. It seems that it's a Visio problem. stCon = "ODBC;DRIVER={ODBC Driver 18 for SQL...

I downloaded version 18 from your link. The installer asked me that a previous version on this machine has been found and weather I want to update it. I selected yes. The install finished successfully. Dim Con As New ADODB.Connection stCon = "ODBC;DRIVER={ODBC Driver 18 for SQL...

All the PCs that pass that connection, have ODBC Driver 18 installed. I thought installing MSOLEDBSQL ver 19 would solve the problem. Which unfortunately didn't. I'll give your connection string a test. But unfortunately the PC is in use and I can not work on it until Saturday. I'll test and...

Before starting, I must apologize to everyone, especially @Isaac, for ruining this thread and their shared interesting quotes. However, I see thousands of quotes shared daily on social media that nobody actually thinks about them. I'm on the verge of exploding, so let me clear my mind here...

I'm working on a Microsoft Visio project and I need to open a recordset to a table in sql server, read the data and work on each record. I've tested the result on several PCs and all are fine, except only one PC. This specific PC throws Runtime error: 3706 "Provider can not be found" on .Open...

Specially why obfuscating something and putting it in Code Repository sub forum, a place that's used for sharing codes and learning how something is done, not hiding the techniques.

We really appreciate this. If this dream comes true, it would be a huge win for us. Send them our regards and let them know we’ve started the countdown.

I loved the one with you and your wife in it.

thanks.

@isladogs Thanks for additional details. Now I'm set and the my form looks perfect. I really appreciate your help. One final (I promise, It's the last) favor. Whenever you have 5 minutes free time, would you please test the database attached to this post? Does it work for you? It seems it can...

@CJ_London First, I’m truly sorry that I missed your second post. Second, please accept my sincere apologies. I tested your solution again this morning, and it’s working perfectly. I honestly don’t know why the homepage didn’t show up when I tested it last night. It may have been because I was...

I'm sorry. It seems that I missed your post. It's 3 AM here. I will check again in the morning. Thanks

As I said, I edited your database in #9. The only edit I did was Changed this line: pdfBrowser.Height = 8000 to: pdfBrowser.Height = wBrowser.Height Your database stopped working. Give it a try. I'll follow your instructions in the morning Thanks again

@isladogs You may not believe me, but I had already tested that and still couldn’t get the result I needed. As you can see in my shared database, the pdfBrowser is shorter than the wBrowser. That’s because I was experimenting with changing its height in code to see whether it would make any...

@isladogs I just tested your database, and I honestly couldn’t believe my eyes. It’s perfect. Aactually, more than perfect. Because of my monitor size and testing through AnyDesk, I couldn’t dig into the code to see the magic behind it. But the result is exactly what I was hoping to achieve...

One of the greatest advantages Access had over its competitors, beyond its ease of us, was its consistency. You could build a database and expect it to run flawlessly through multiple generations of Windows and Office updates, performing just as it did on day one. Lately, however, that...