Text Box in Access 2003

[ddoblank]

I have a database that I created for our company that is used by a number of
people on differenct computers. There are text boxes that show the File Date
& Time using that "=FileDateTime("C:\Documents and Settings\file.txt"
command. On two computers, this works fine, but on a third computer we get a
#NAME error. Any ideas as to why this would happen? All computers are running
windows XP and the same version of Access, as far as I know.

 

[Daniel Pineault]

1. You are missing the closing bracket.
=FileDateTime("C:\Documents and Settings\file.txt")

2. Are you sure the file is present? In that location?
3. Have you validated that you have no issues with reference libraries?

Also, this is an odd place to locate a file that you need to work with.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Tom van Stiphout]

On Mon, 8 Feb 2010 16:51:01 -0800, ddoblank

Could be a security issue. Change the path temporarily to one that
everyone has access to. Or login as one of the successful users and
see if it still fails.

Perhaps also check in the Immediate window:
?vbe.Version
and see if all have the same version.

-Tom.
Microsoft Access MVP

 

[ddoblank]

Hi Daniel,

thank you for your response. The text boxes update correctly on two out of
the three computers on the network, so the information has to be correct. All
three computers connect to the server in the same manner and all users have
the same security access to that directory, or at least I would think they
would if they can all open the database with a shortcut on thier desktop. It
is just the one computer that seems to be having the problem.

Darren

 

[ddoblank]

Hi Tom,

thank you too for your response. Changing the path won't work, at least I
don't think it will, for the same reasons that I posted on Daniel's. All the
users have the same access and only one of the computers is displaying the
error.

The vbe version is another story though. How do I check that to see what
each computer is running?

Thanks
Darren

 

[John W. Vinson]

The vbe version is another story though. How do I check that to see what
each computer is running?

Open each database; type Ctrl-G to open the VBA editor. On the menu select
Tools... References. All three should have the same version selected - look at
the file mentioned in the window when you select the VBA Object Library
reference.

I just (with the help of some good folks who frequent this group!) solved a
baffling problem in this way - one computer had VBA 12.0 (A2007 version) and
another correctly had 11.0 (A2003). This can apparently happen if someone has
one version running; starts to run the other version; and interrupts Access
during the (sometimes quite timeconsuming!) "Installing..." process. The
solution is to let the installing process run to completion; close Access;
open the desired version; and let Installing run to completion again.

 

[ddoblank]

Hi John,

Thanks for your response, however, we took a look and we can't find this VBA
Object Library on any of the computers. We checked 4 systems using the steps
you listed below and not one of them shows VBA Object Library in the
Reference box under tools. Any other suggestions that we can try?

 

[John W. Vinson]

Hi John,

Thanks for your response, however, we took a look and we can't find this VBA
Object Library on any of the computers. We checked 4 systems using the steps
you listed below and not one of them shows VBA Object Library in the
Reference box under tools. Any other suggestions that we can try?

The first two critical libraries are "Visual Basic for Applications"
(C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL, version
6.5.10.24) and "Microsoft Access 11.0 Object Library" (C:\Program
Files\Microsoft Office\OFFICE11\MSACC.OLB) on my A2003 instance. If you have a
different version you will of course have different files. The critical thing
is that they should be the same on all of your computers. Sorry about the
incomplete instructions!

 

[ddoblank]

Hi John,

Sorry for the delay in responding to this posting. I have been away for a
few days. I finally had a chance to look at various computers that have
access to this database and they are all running the same version of the
files you have listed below. I just can't figure out why one computer will
not show the file data while all the others will.

Any more ideas?

Thanks
Darren