Recent content by Guillem

I need to convert some huge db from access 2003 to 2019 and i want to apply themes and colors and shapes and everything that is fine to apply in an .accdb copy. I prefer to do it from an external base. Yes, including them in the references is a very good idea. Thanks!

I don’t understand that there is no similar way to manage objects in the current database than in an external database. For example .AllForms I can't find a similar way to handle it in both cases. I apologize for my bad English. I try to do my best but it scares me to stay confused. Thanks!!

Thanks! I was wondering if it was possible to use the current database in the same way as another open database. Anyway , Thanks

Hello, can someone help with this confusing(for me) things? Is it possible to have a list of Forms, choosing both from the local database or another selected database. I tried many combinations but unsuccessfully. The code that follows works fine from local db, but fail trying with an...

still looking for time to build a new fresh VM with W10/64 + Access2019/32 to make further test... I will keep the thread informed. thanks.

Intel Core i7 CPU 870 @ 2.93 GHz 2.94 RAM 4.10 GB 64bits O.S., x64 based processor OfficeProf Plus 2019 64bits / Access 16.0.12730.20144)32 bits VM running over ESX 5.5 / i7, 8GbRAM, SSD + SATA disks

Thanks for testing, Yes, smoothproc is quicker, because run over a local form, faultyProc() run over the same form but on testControlProp2. Accdb database , a copy of testControlProp1. Only for that purpose, not to be executed. Maybe the problem resides in my machine... But I wait a test over...

Tried with w7/64, office2016/32 also work fine...

The new test db

Thanks again! strange thinks..... Also, to further narrow the problem, I make a common routine for both procedures. one called from a small local form ("frmMessages"), and the other from the external database to the same form. the same behavior.... maybe a problem with 2019? it is fresh...

Just applied. the problem remains the same... . Anyway, Thanks

After sleeping some hours, my head is a little better. The accdb comes from OF2003, also last 2 references I used the same. maybe this is the problem? what are the correct ones?

Also I prepared 2 small db's to demonstrate the problem

Sorry, my english is not very good, I means that i revised the code and corrected, but the problem remains de same. Help still needed, after many more hours, still in same place. I resumed the code to its minimum to clarify the problem. Sub FaultlyProc(FullDBName As String) 'any accdb...

Thanks to all!! @cheekybuddha , Yes. This was the error I corrected. Only 2 parameters was necessary. The old version used consistently 4 parameters. Now is already corrected in #1. Thanks.