Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Run Saved Import from Command button

Status
Not open for further replies.
ksaab2002

ksaab2002

MIS
Jan 6, 2005
66
0
0
US
Hi,

It had been about 8 years since I have developed i Access. Rather rusty!
Could someone assist in showing me how I could pull run a saved import using a command button in a form?

Using Access 2007 and Excel 2007. thanks,
 
Sort by date Sort by votes
You may use the DoCmd.TransferSpreadsheet method in the Click event procedure of the button.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

PrimoSteve
  • Locked
  • Question
Cannot add Image to Command Button?
Replies
9
Views
165
PrimoSteve
PrimoSteve
PrimoSteve
  • Question
Grid From 1
2
Replies
21
Views
745
PrimoSteve
PrimoSteve
PrimoSteve
  • Locked
  • Question
Fill in 2nd Textbox2 from Textbox1
Replies
3
Views
119
PrimoSteve
PrimoSteve
TrekBiker
  • Locked
  • Question
Running query with parameter from Inputbox 2
Replies
8
Views
154
TrekBiker
TrekBiker
TomSalvato
  • Locked
  • Question
Getting the Monday date from a week number 1
Replies
2
Views
121
TomSalvato
TomSalvato

Part and Inventory Search

Sponsor

Back
Top