Search results

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...

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...

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...