The code below is very persistent in producing the run- time error 3027.: ************************** Private Sub Command1_Click() DoCmd.TransferText acExportMerge, , "qrymailshot", "c:\mailshot.doc"
End Sub ********************* I use Office XP home edition and Access 2000 SR-1 Neither table Or DB is read only. Any help will be greatly appriciated.
regards Henning Birkeslund
Tue, 30 Nov 2004 02:44:48 GMT
<SteveT> #2 / 2
Run-time Error 3027 when doing AcExportMerge
Ms Kb Q245407, just change the extension to .txt or .csv then use the Name/As command to change the file
Steve
Quote:
> The code below is very persistent in producing the run- > time error 3027.: > ************************** > Private Sub Command1_Click() > DoCmd.TransferText > acExportMerge, , "qrymailshot", "c:\mailshot.doc"
> End Sub > ********************* > I use Office XP home edition and Access 2000 SR-1 > Neither table Or DB is read only. > Any help will be greatly appriciated.
Run-time Error 3027 when doing AcExportMerge