Alternatives to Domain Aggregate Functions (AC2007)

[AOB]

Hey Bob

Thanks for those! I have a persistant connection as well, in that I have a hidden form which I use to track who is connected to the BE at any given time. But I did read elsewhere that having one can result in improved performance alright.

Am curious about setting the RecordSource / RowSource properties at the OnLoad event of the parent form? I think I do that in some places but not in others (for different reasons) but certainly something worth doing a quick test on to see if it has a positive impact? I'll have a play this morning...

Thanks again for those suggestions!

Al

 

[CJ_London]

Am curious about setting the RecordSource / RowSource properties at the OnLoad event of the parent form?

then this thread may be of interest - post #4

http://www.access-programmers.co.uk/forums/showthread.php?p=1367320#post1367320

set the db object as a public variable in a module and open when the application opens and close it when the application closes

 

[vbaInet]

set the db object as a public variable in a module and open when the application opens and close it when the application closes

Fyi, using a Class is better for this sort of thing. Create an instance of the class on load and set the instance to nothing when unloading the form. The class will return a connection instance which and the connection should be built (or instantiated) in the constructor (Class_Initialize), and destroyed in the destructor (Class_Terminate).

The connection will persist for the life of the instance and other forms can create new instances from that class.

By the way, I used to live near Paddington on the maida vale high road which is just after edgware road.

 

[CJ_London]

@vbaInet: Create an instance of the class on load and set the instance to nothing when unloading the form.

Won't this result in the connection being made/destroyed every time you open/close a form which has a performance implication?

I used to live near Paddington on the maida vale high road which is just after edgware road

I know the area but actually live in Oxfordshire... But have clients in Paddington, Holborn and the City

 

[vbaInet]

Depends on how persistent you would want the connection. If you want it throughout the life of the session then you declare the same variable as public like you mentioned and instantiate it in the Load event. It was only a side note as it's a neat way of handling connections.

Ah, not far from us then.