Search results

The problem is that the application is a bit complex and an extensive test suite is needed before releasing it. This requires quite a lot of time time which frankly I would rather spend in developing the new version which is already under way but not completed. So, the best case scenario for me...

The truth is that I am afraid of new bugs that may occur due to this change. So far, the application has been adequately tested as is and introducing such an extended change requires thorough testing not to break things that work well at this moment

Yes, that is correct...the code works with the newer OLEDB.12.0 provider However, since as I already mentioned it is a rather large codebase, I would like to defer having to perform this change to the newer provider at least right now

Hello, I just found that even the following piece of code causes the application to crash in the same manner: Set cnn = New ADODB.Connection cnn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=<path-tofile>" Set rs = New ADODB.Recordset rs.open "SELECT aCol FROM tbl", cnn...

Hello, Forgive me for the late reply to your posts! I didn't mean to be rude! I have replaced Microsoft.Jet.OLEDB.4.0 with Microsoft.ACE.OLEDB.12.0 and it is working fine Please see the modified code and a screenshot of code execution I have one more question: do I need to include additional...

Since this seems to be a problem that occurred due to Windows update (particularly msjtes40.dll), is there a way to report it directly to Microsoft so that -hopefully :)- a fix could be released in future updates?

Unfortunately I cannot switch to DAO or DDL because the code that I posted is only part of a rather large project and frankly I was hoping for a more general fix -if possible- without having to perform extended changes to the code base Thank you very much!

Hello, Same thing happens when using DDL for setting default values Thank you very much for your suggestion!

Hello, After installing windows update KB5064081 on Windows 11 machine, the following piece of code crashes on Access 2016: Public Sub CreateTable(strPath As String) Dim cat As ADOX.Catalog Dim tbl As ADOX.Table Dim idx As ADOX.Index Dim flag As Boolean Set cat = New ADOX.Catalog cat.Create...

Hello, I apologize for the late response but I was away for a few days and could not see your posts. Thank you all very much for your suggestions! I tend to believe that the problem has something to do with different Office versions that Ranman256 pointed out. As I mentioned in my previous...

Hello, I have an accdb file created with Access 2016 which contains some custom functions in standard modules. This file is converted to accde format and used as a reference to a second accdb file also created with Access 2016 which contains forms,reports, tables etc. For clarity, let's assume...

Your solution is very interesting but I think that it causes some flickering when the form is being resized by dragging one of its edges or corners. Looking at your code I guess that this happens because the resize event occurs constantly during this operation and the form is being maximized and...

I agree with sonic8 that the solution posted by Nixversteher works very well: the application does not freeze and the form gets maximized as intended. Thanks a lot! However, I too would like some more information (if possible) regarding the implementation Best regards

Thank you all for your answers! The problem is that the application hangs even if the VBA Editor window is closed I am posting two images: 1.jpg and 2.jpg. The first one depicts what I am actually trying to achieve. That is the form is maximized to the extents of the client area of the...

Hello, I am trying to subclass a form in order to catch the event that occurs when the caption bar of the form is double clicked. The reason for this is that I want to maximize the form when double clicking the caption bar but within the confines of the client area of the main Access window...