D
Dale Fye
I have a command button in the footer of a continuous form that lists files
that pertain to a particular study. These files are all stored in a common
location on my LAN.
In the forms current event, I set the HyperlinkAddress property of the
command button to the path and file name of the document (it works great 99%
of the time). I am having problems with one of the documents that has some
special characters imbedded in the file name (not my naming convention, but I
could probably strip these characters out and change the file names if I
must).
The file in question is named:
Briefing for the 12 13 Oct Workshop #2 (06 Oct).ppt
When I try to follow this hyperlink, I get an error message:
Run-time error '432'
File name or class name not found during automation operation
If I click "End" in this error dialog, I get another dialog message:
"Unable to open ....\Briefing for the 12 13 Oct Workshop. Cannot open the
specified file." It looks like it is dropping all the characters in the
hyperlink address after the pound sign (#), but when I select "Debug", I can
print the hyperlink address in the immediate window, and it prints out
correctly.
Is this a particular problem with the pound sign? Are there other special
characters I need to check for as I store these files on my network and their
names in my database?
that pertain to a particular study. These files are all stored in a common
location on my LAN.
In the forms current event, I set the HyperlinkAddress property of the
command button to the path and file name of the document (it works great 99%
of the time). I am having problems with one of the documents that has some
special characters imbedded in the file name (not my naming convention, but I
could probably strip these characters out and change the file names if I
must).
The file in question is named:
Briefing for the 12 13 Oct Workshop #2 (06 Oct).ppt
When I try to follow this hyperlink, I get an error message:
Run-time error '432'
File name or class name not found during automation operation
If I click "End" in this error dialog, I get another dialog message:
"Unable to open ....\Briefing for the 12 13 Oct Workshop. Cannot open the
specified file." It looks like it is dropping all the characters in the
hyperlink address after the pound sign (#), but when I select "Debug", I can
print the hyperlink address in the immediate window, and it prints out
correctly.
Is this a particular problem with the pound sign? Are there other special
characters I need to check for as I store these files on my network and their
names in my database?