May 13, 2003 #1 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
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
May 13, 2003 Thread starter #2 RamziSaab MIS May 7, 2003 522 GB 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 Upvote 0 Downvote
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