You don't need to rename it and then move it to another location. You can move it to the new location when you rename the file. Just enter the final path location in the new path name argument.
Darrell
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of winberry.doyce@roadsysinc.com
Sent: Wednesday, October 30, 2013 11:06 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: RE: RE: [MS_AccessPros] Export Spec and file extension
Liz,
That seems like the best solution. I'm working on that now but keep getting disturbed by people in the plant needing something. Job security right? LOL
Thank You!
Doyce
---In MS_Access_Professionals@yahoogroups.com, <ms_access_professionals@yahoogroups.com> wrote:
Can you export to a local h: drive and then rename it and copy the renamed version over to the share?
Respectfully,
Liz Ravenwood
Programmer / Analyst
B/E Aerospace | Super First Class Environments
1851 S Pantano Road | Tucson, Arizona 85710
Office +1.520.239.4808 |
beaerospace.com
Passion to Innovate. Power to Deliver
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of winberry.doyce@...
Sent: Wednesday, October 30, 2013 6:14 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: RE: [MS_AccessPros] Export Spec and file extension
Duane,
I thought about doing just that, However if I do, I'm going to have to save it local first then rename and then copy it to the network share. Corporate IT has some kind of new procedure where within seconds after a file has been uploaded to a share, it is swept off to the "cloud". It's not there long enough to rename. I guess I'll search for some code examples for Name and how to move a file from one location to another.
Thanks for your help!
Doyce
---In MS_Access_Professionals@yahoogroups.com, <ms_access_professionals@yahoogroups.com> wrote:
Doyce,
You may need to use the Name statement to rename the file after it is exported.
From Help:
Name oldpathname As newpathname
Duane Hookom MVP
MS Access
________________________________
> To:
MS_Access_Professionals@yahoogroups.com
> From: winberry.doyce@...
> Date: Wed, 30 Oct 2013 05:54:15 -0700
> Subject: [MS_AccessPros] Export Spec and file extension
>
>
>
>
> Hello friends,
>
>
>
> Need some help today. I have a procedure where I export a table to a
> CSV file with an export spec. My corporate IT who gets the file changed
> the procedure on their end and they want the file extension changed to
> RSH instead of CSV. Now the procedure won't run. It gives me an error
> that it can't update because the database is read only. Well I change
> the file extension back to CSV and it runs fine. How can I change my
> export spec to allow a file extension of RSH?
>
>
>
> Doyce
>
>
>
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
The information contained in this communication is highly confidential and is intended solely for the use of the individual(s) to whom this communication is directed. If you are not the intended recipient, you are hereby notified that any viewing, copying, disclosure or distribution of this information is prohibited. Please notify the sender, by electronic mail or telephone, of any unintended receipt and delete the original message without making any copies.
Blue Cross Blue Shield of Michigan and Blue Care Network of Michigan are nonprofit corporations and independent licensees of the Blue Cross and Blue Shield Association.
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (7) |
Tidak ada komentar:
Posting Komentar