Help with DoCmd.TransferDatabase, acExport...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

Please help me with this
In the import form frm_ImportI have a combo box selFileType with 4 options
(excel, access, csv, xml), a text box selFileName where user can browse for
their file location to be save, and if user pick "access" from combo box
selFileType it will visible and force user to enter a filename called
selTableName.

Case "Access (*.mdb)" 'Access database
If Nz(Me.selTableName) = "" Then
MsgBox "You must enter a table name for an Access Export"
GoTo Done
Else
DoCmd.TransferDatabase acExport, "Microsoft Access",
Me.selFileName, acTable, "qryAddressList", Me.selTableName

I don't know why it doesn't work... It keep tell me it can't find the path
selFileName... The path is work fine with xml, excel and csv format case...

Also, does anyone experience export with apply form's filter
Thank in advance...
Violette
 
Back
Top