dialog box to choose linked table

  • Thread starter Thread starter Daryl
  • Start date Start date
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!
 
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
(e-mail address removed)
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!
 
PC Datasheet said:
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.
Click to expand...

These 1000 (if at all a real figure..) is only the result of
-- 4 years abusing the newsgroups.
-- 4 years blatantly advertising and job hunting.

You only care about making money, and you act as if the groups are your private hunting ground.
So why would ANYBODY ever trust a person like you and hire you?
********************************************************
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!
Click to expand...

Need a psychiatrist ...Contact me!

Arno R
 
Back
Top