Recent content by Stephanpls

With DoCmd.TransferDatabase acLink,.... I link a table to my database. But how to remove such links from the database with VBA?

For my Access application I need a simple image viewer, that can show pictures, zoom and pan. No more frills needed! The Microsoft Forms 2.0 Image ActiveX that comes with MS Access is TOO simple (it only shows pictures). Since there is a zillion options offered on the net, I turn to you. Thank...

Thanks for all very useful answers!

Other question. Is it possible to compact a database in VBA?

It worked! I keep learning. Thanks!

I want to delete a table X in a database Y while the current database is another one. What I do is: ** Dim Dbase as Database Set DBase = OpenDatabase("Y.mdb") DoCmd.DeleteObject acTable, "X" ** There is a message then that table X is not found (though it exists!). I think Docmd only works in...

Thank you. So it's not possible to change such settings in VBA, then?

I am writing code in which I create a table and fill it with data. At the end of the code I open the table. All works fine. The nuisance is that the table fields with real numbers are shown with many decimals. I know how to set the number of decimals in the table design window, but I did not...