By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,445 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 IT Pros & Developers. It's quick & easy.

Show on Access form the last modified date of an Excel workbook

P: n/a
***From previous post***
Is it possible to have an Access form that displays in a text box the
last modified date of c:\myworkbook.xls?

try setting the data property of the text box to ...
= FileDateTime("c:\myworkbook.xls")
My Question

FileDateTime works great for me, but the database I put it in is on a
shared drive.

When other people try to use the database they will get an error on
startup of bad expression on the filedatetime. and they are unable to
use the database.

we set the security to everyone full rights and did not help
unsure the issue

Aug 30 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
....leave the record source blank ...in code check to see if the file exists
first ...if it does, enable the text box, make it visible, and set its
record source.

....hth

William Hindman

<li****@charter.netwrote in message
news:11**********************@74g2000cwt.googlegro ups.com...
***From previous post***
Is it possible to have an Access form that displays in a text box the
last modified date of c:\myworkbook.xls?

try setting the data property of the text box to ...
= FileDateTime("c:\myworkbook.xls")
My Question

FileDateTime works great for me, but the database I put it in is on a
shared drive.

When other people try to use the database they will get an error on
startup of bad expression on the filedatetime. and they are unable to
use the database.

we set the security to everyone full rights and did not help
unsure the issue

Aug 30 '06 #2

P: n/a
Maybe the file can not be found ??

When I understand you correctly it means that you are using a shared FE??
This is a BAD idea!!
This has been told here like every day or so ...

Maybe only put the xls-file on a shared drive ??
Maybe use UNC-Naming ??

Arno R
<li****@charter.netschreef in bericht news:11**********************@74g2000cwt.googlegro ups.com...
***From previous post***
Is it possible to have an Access form that displays in a text box the
last modified date of c:\myworkbook.xls?

try setting the data property of the text box to ...
= FileDateTime("c:\myworkbook.xls")
My Question

FileDateTime works great for me, but the database I put it in is on a
shared drive.

When other people try to use the database they will get an error on
startup of bad expression on the filedatetime. and they are unable to
use the database.

we set the security to everyone full rights and did not help
unsure the issue
Aug 30 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.