Search results

Change source of linked tables - Solved! I have a db (mydb.mdb) with a linked table ("tbl_one"), currently pointing to a table with the same name in an access db called "sourcedb-feb". I'd like to use vba to open a dialog box for the user to select a new source (like "sourcedb-mar") and to...

I've tried searching the forum for an answer for this but no luck, so posting it... All I want to do is start by selecting a cell, say A1, then selecting a cell say three down and five along. I've tried using: Range("A1").Select Range("R[3]C[5]").Select and swapping out or round the...

Hi again - today's problem: At a given point in a script I am left with an excel document that is linked to data in another excel document; I would like to remove the links and leave only values and to do this from my Access module. I've tried using: objXLApp.ActiveWorkbook.BreakLink _...

{1st post} Many thanks to all of you who have helped me in the past, however no amount of searching has given me a solution to this one, so I'm posting in the hope that someone can point out where I'm going wrong... I need a module in Access which: 1- runs a few queries, placing the outputs...