Thanks once again, John. That was the name of the folder so I added the name of the file including .xls. WooHoo! Thankful that you happened to be online so quickly!
Connie
--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Connie-
>
> Is the name of the file " Listed Statistics--Copy last one to begin" ?? If so,
> try adding ".xls" on the end. Also, are you sure you have full privileges to
> Backup\Susie ??
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Nashua, NH)
>
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of mrsgoudge
> Sent: Tuesday, March 06, 2012 1:03 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Error 3051
>
> I am exporting a query using vb. I went to the folder that I'd like it exported
> to and cut and pasted the address. The Access program that I'm using is in
> C:\Documents and Settings\AGENT\My Documents\Backup\Connie\Access\DatabaseData.
>
>
> The description of the code: "...cannot open or write to the file 'C:\Documents
> And Settings\AGENT\My Documents\Backup\Susie\Listed Statistics--Copy last one to
> begin'. It is opened exclusively by another user, or you need permission to
> view or write its data."
>
> My code is:
> DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, _
> "qListingsRawData", _
> "C:\Documents and Settings\AGENT\My Documents\Backup\Susie\Listed
> Statistics--Copy last one to begin"
>
> Thanks!
> Connie
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
Tidak ada komentar:
Posting Komentar