I also have free code to automatically resize forms. This is based on open source code originally written by Jamie Czernik back in 2003. However it has been extensively updated since to allow for different monitor form factors, tabbed documents as well as overlapping windows and now also includes a zoom form feature.
For a full explanation, sample database and all necessary code, see my automatic form resizing tutorial at http://www.mendipdatasystems.co.uk/automatic-form-resizing-1/4594554784isladogs supported this idea ·
Yes of course there are many legitimate uses for importing/exporting data using VBA.
However, when an FE is distributed as an ACCDE, I think it less likely that end users will be doing that. What I'm requesting is an option to prevent tables/queries being copied/ exported /imported to/from ACCDE files when these are created
I am in no way disagreeing that for higher level security SQL Server should be usedisladogs shared this idea ·
98 votes6 comments · Access (Desktop Application) » External Data Connectivity · Flag idea as inappropriate… · Admin →
I've previously voted for similar suggestions:
a) add a JSON.dll
b) add an Access equivalent of Excel Power Query (Get & Transform)
However, its done, the important thing is that it is done.
In the meantime, I will continue / developing using my JATFA (JSON Analyse & Transform for Access) app which is available from http://www.mendipdatasystems.co.uk/json-analyse-transform/4594138310
Of course, if MS adds this functionality, my app may well become redundant