Recent content by carpeneda

Hello Is there any possibility to run a vba procedure when opening my database? This should run before any form is loaded. Thanks for any help E.Glaser

Hello everybody My Access version is ACC 2007. I tried to use the methode 'refreshLink' from the TableDef object in the DAO Libary in order to link my data base type 'accdb'. But my version of 'refreshLink' works only with the old type of database type 'mdb' from Access 2003 versions. 'accdb'...

I found out that the RefreshLink methode is working well, in case that I use a database file type 'mdb' instead of 'accdb'. It seems to me that my DAO libary is an old version from e.g. Access 2003, but My Access version is from 2007. How can I update my Access DAO? Is there any update service...

I have split the access file to front-end and back-end. My tables (back-end) are linked to a file called "MyData.accdb". The directory for this file to be stored has to be flexible. The new location is defined by the .connect property. But this seems not to be correct, because when executing...

Hello all, I'm trying to redirect the tables in my backend file to another path by using the .connect property and .RefreshLink method. When executing .RefreshLink , error #3031 (no valid argument) occures, but I don't find any wrong expression in my code. This is my code: Dim objTb As...

Hello, when my mainform is active form, I need to know if there is a subform existing and how to refer to the subform object if there is one. This is used for reformatting of all controls in the main + subform. Is there any function available, I can use to get this information? Thank you for...

Hello, thank you for this quick reply. But your proposition with screen.activeControl returns the control object that currently has the focus. I need the name of the control, that has sent the MouseMove Event without having the focus. For instance: - Focus is at contr1. - I move the mouse to...

Hi, After releasing a 'MouseMove' event, I'd like to read out the name or ID of the control or section, the cursor is in. Thank you for any idea how to solve this problem. E.G.

Hi I have found some different mouse pointers in the screen.mousepointer object. Is there any possibility to extend the choice of mousepointers, because there are just some few? Thank you for any idea.