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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stop header/footer appearing in subreport 1
Importing any excel files with any sheet name into different tables in MSAccess using code 0
PowerPoint Change/update links to new source (PPT with charts & objects linked to Excel) 1
Update FROM a Linked Table 2
Combo Box w/ Links Revert to Default Text 3
Linking tables in a query 1
replacing a link to a SQL Server table with VBA 1
Updating table 3

Back
Top