Yep! J Have fun!
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@roadsysinc.com
Sent: Wednesday, October 30, 2013 8: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.
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.
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (6) |
Tidak ada komentar:
Posting Komentar