var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I'm using the following code to make sure that a specific file exists.
On Access 2003 it works fine but on Access 2007 I get an error 2455 on the "FileSearch".
Set fs = Application.FileSearch
.LookIn = "C:\Windows"
.FileName = "HebDates.DLL"
If .Execute > 0 Then
MsgBox "File is missing"
Check the references between the two instances of Access via the VBA window > tools > references.
Let us know what you discover
make a reference to the scripting runtime object model in tools/references of the vba project
Dim fs As FileSystemObject
Set fs = New FileSystemObject
mypath = "C:\myfolder\Myfilename.txt"
If fs.FileExists(mypath) Then
Dale Houston, TX
FileSearch is removed in 2007.
If Dir("C:\Windows\HebDates.DLL")="" then
msgbox "oups - missing"
Here are some more info on different methods, with code samples and timing http://advisor.com/doc/16279
Last edited by RoyVidar; 10-08-07 at 18:54.
Reason: Forgot to add the link
Thank you for all contribution. I'v used FileSystemObject.