Prev: Access 2007 pivot - how to calculate eg P/L marings both in curr &
Next: Access Report
From: Ashland78 on 18 May 2010 08:54
OK, I am relatively familiar with Access 2003, but I have been asked to
figure out why the data in that is entered into the database shows it when
looking on the database but it is not generating it to the list of updated
documents. Here is a bit of the background...I just started working at this
company 2 days ago, well the file is an excel file but the path for the file
is generated to a person's C: drive who no longer is employed here. I am
trying to change that path...and am having no luck. Any help would be so
appreciated. Thanks!
From: Arvin Meyer [MVP] on 18 May 2010 09:24
Is the file even on their machine? You cannot link to files on machines that
either aren't open, or files that have been deleted.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"Ashland78" <Ashland78(a)discussions.microsoft.com> wrote in message
news:952596C6-98BE-40B1-B62F-517AE48146DB(a)microsoft.com...
> OK, I am relatively familiar with Access 2003, but I have been asked to
> figure out why the data in that is entered into the database shows it when
> looking on the database but it is not generating it to the list of updated
> documents. Here is a bit of the background...I just started working at
> this
> company 2 days ago, well the file is an excel file but the path for the
> file
> is generated to a person's C: drive who no longer is employed here. I am
> trying to change that path...and am having no luck. Any help would be so
> appreciated. Thanks!


From: Alan on 18 May 2010 09:59
i had this problem before,

if you look at your code you may have something like a "CoPath"
which gives you the directory to where the file is being saved, i'm not sure
how to change that, but what i did was create a new sheet in excel and
create a link to the new work book and update the values from there.

"Ashland78" wrote:

> OK, I am relatively familiar with Access 2003, but I have been asked to
> figure out why the data in that is entered into the database shows it when
> looking on the database but it is not generating it to the list of updated
> documents. Here is a bit of the background...I just started working at this
> company 2 days ago, well the file is an excel file but the path for the file
> is generated to a person's C: drive who no longer is employed here. I am
> trying to change that path...and am having no luck. Any help would be so
> appreciated. Thanks!
 | 
Pages: 1
Prev: Access 2007 pivot - how to calculate eg P/L marings both in curr &
Next: Access Report