Linking table in VBA

  • Thread starter Thread starter Paul Hammond
  • Start date Start date
P

Paul Hammond

I want to set the linked property of a table in VBA. I
am getting nothing from my online help on this. I am
using a toggle button. Based on that value, either 1 or
2, I want to link tblReport to either Report1.txt or
Report2.txt.

Any help is appreciated.

Thanks,

Paul Hammond
Richmond, VA
 
On my website (see sig below) is a small sample database called
"LinkTables.mdb", which illustrates how to allow the user to choose which
*database* a table is linked from. Linking to a text file is a little
different, but the idea is the same. I also have a sample called
"LinkTextFiles.mdb". Between the two, they should give you what you need.
 
Back
Top