dialog box to choose linked table

D

Daryl

I have an access database called "stale dated checks" and what I want is a
user to be promptd at startup of the database to choose what Excel
spreadsheet they want to use as the linked table then once they have chosen
that spreadsheet then change the name of the link to "tbl_original'. I am
new working with access so any help you can give me would be much
appreciated!
 
P

PC Datasheet

Look in the Help file at the TransferSpreadsheet function. In this function
you specify the Excel spreadsheet you want to link to as a string parameter.
So you could programatically specify which spreadsheet you want to link to
in this function.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!
 
Top