Recent content by miramax

I have a really weird table that looks like that:I have one value in the 1:1, nothing in 1:2 (column:row). I have one value in 2:2 (nothing in 2:1 or 2:3). In fact this is the descrition of the records that are in 3:3 to 3:14. Given this I can not perform a search within the table. Because the...

CommonDialogBox does not exists in Acess. You can use it only in Word or Excel.

Hi Rich! Thanks very much for the advice! I've tried it and it works! Great! Have a nice day/evening!

You can write this: filename= .Foundfiles(i) newfilename=Left(filename,n) Where n is the number of characters that you want to keep. Then you use newfilename to display the info to the user.

Rich, I do not think that it is possible to cover the Access close button with a forme...How can you do this? Regarding the code that I can write..can you be more precise... Thanks!

The problem is that If the user closes the databse by clicking on the highest Close button (the one for Access), the Close event for the open objects do not trigger....Thanks however

Work out the result as a string. Use the Left/Right functions to cut the part that you need...

Hi guys, Could someone tell me if there is a Close Application EVENT for Access. I just want to execute a numer of things via VBA when the user tries to close the application. There is one for Start Up, but I still have not found an equivalent when the user Closes the Application. Any comments...