Search results

Sometimes it happens that an Access procedure is busy for a long time For example, when I export a project of hundreds of forms and reports, using the Vcs procedures, the sequence of operations lasts over ten minutes I'm talking about code that is executed and databases locally, and therefore...

Yes I know MzTools and the possibility of using its functions to create the start and end routines I wanted to understand if it was possible to do it only from Vba code And it seems not to be possible

In order to implement effective error handling, it would be useful if from code you could read the name of the sub/function inside which the code is running A sort of Me.name for forms Then the question is: how to read, via vba, the name of the function/sub inside which the code is running?

One of the most important features in the new version of Access is the Sql editor Monaco I tried to use it, but I can't fully appreciate the improvements made For those who have already had the opportunity to use it, I would like to ask: exactly, why use the new Sql editor?

??? To run an access file with the .accde extension, simply install the Access runtime

How many data tables is the program connected to? It seems to me that the limit for Access 2013 is 2048 tables OPEN AT THE SAME TIME But simply for the connection, it does not seem to me that there is a limit imposed by the programming environment

I currently use Thunderbird, and it has been my local email and news client for over 10 years Outlook is definitely more powerful and has better features But where possible, I always prefer open source programs

Even if it were just an academic interest, the topic would still be of great value to someone who uses Access Even a linked list or a bubble sort, are purely academic interests (unless one builds a db server or similar), but are still of great interest to understand how things work in certain fields

If it is not possible to use the 'number of objects' to understand the technical limit that can be contained in a single Access file, then it means that other conditions will have to be checked, such as the memory used by that single Access file during operation, or other conditions still

What you mean with 'UAT enviroment' ?

My current specific application is of no importance The important thing is how to make a project with a number of objects that exceeds the size of the objects contained in a single Access file

You can understand exactly what I wanted by reading post1

When a person asks for something, I don't think we can talk about 'superior intellect' Otherwise this person wouldn't ask

No Invoices, items, prices, the usual things It grew like this because new features were added to an initial minimal core And having to add more, now I'm trying to understand how to organize things a little better

Sorry but maybe I explained myself badly I wrote this (the number of form/report/modules) You wrote that there is a maximum limit of 1000 forms After that I pointed out to you that the limit of 1000 forms is not real because in my case it was exceeded This observation makes me think that the...

Yes sure, the sum is 1042, i can do it up to three figures Source is CJ_London

Form with moduless are actually 634 Report with modules are actually 299 Modules of code are actually 109 The counting ("..you've got between 10 and 42 months..") needs to be redone This is why I said that one of the first things to do is to actually measure what the technical limits are...

OP is used to listen to other, if other answer to the question :)

It is neither mythical nor unicornIt is a classic project I would dare say simple, but with many objects And it is not just a matter of overcoming the technical limits of a single file but also of reducing the size of the Access files on which you work Instead of working on a single 100Mbyte...

The classic system for business management Which started with the usual parts dedicated to sales, warehouse, accounting and then is expanding In order to avoid reaching a critical point, I want to prevent any "explosions of objects" And therefore I would like to modify the structure of the...