Is there a way to preset the folder and file name using the DoCmd.RunCommnad acCmdLinkTables syntax.
Currently using a msgbox "Navigate Desktop\thisfolder\filename" Click Select All then OK
The user then must navigate to the correct file, click the Select All button, then OK.
********start code snipet
MsgBox "Navigate to > Desktop\Drug Dealers\DrugDealers.mdb"
********End Code Snipet
OK, its kluegee but it does work. Hope to make it better with EE help.
If that wont or can't work, any ideas to accomplish the same will be considered.
You guys and gals are the best.