Search results

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.

Thanks David for your help. - The error comes in sentence "For Each Prop In Ctrl.Properties ", not working with a specific Property. Maybe a DataType problem? . The approach "For Each" work fine inside same database, but give me this error when working in an external...

Hello, I have a trouble trying to do the following it is intended for punctual use to convert some 2003 mdb databases to new look of 2019 templates I will try to explain the scenario I have a accdb that contains a form with a sample of type of controls formatted as desired (i.e. Ion theme with...

You tried the TypeName() function?. it returns the type based on current value.

I make a variation of AllenBrowne routine GetDLLTypeName(FieldType) ( http://allenbrowne.com/ser-49.html) for DLL DataTypes , adapted for VBA DataTypes This returns almost consistent results applied to all From control types Public Function GetVBATypeName(FieldType As VBA.VbVarType) As...

Thanks for this solution. I will keep you all informed about the final solution used.