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!

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

DoCmd.RunCommand acCmdImport Specifying file

Status
Not open for further replies.

RamziSaab

MIS
May 7, 2003
522
GB
Is there a way to specify the file u want to import, i.e. so it does not goes straight to the wizard and does not ask you to locate the file.

Private Sub Command0_Click()

DoCmd.RunCommand acCmdImport

End Sub
 
Full Code that i have so far

Private Sub cmdImportWizard_Click()
On Error GoTo Err_cmdImportWizard_Click

DoCmd.RunCommand acCmdImport
RefreshDatabaseWindow

Exit_cmdImportWizard_Click:
Exit Sub

Err_cmdImportWizard_Click:
MsgBox Err.Description
Resume Exit_cmdImportWizard_Click

End Sub
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top