Images on SharePoint Drive

[TCF]

In access 97, i was able to have a table with the path of an image that i
would put into a report. We are now converting our file shares to share
point drives. I now get an error when it tries to open the image from the
sharepoint drive. I have tried it in Access 97 and 2003. The location of
the image was stored as a text field in the table. For the report, the code
was as follows

If Not IsNull(Me!txtfilename) Then
Me!Image0.Picture = Me!txtfilename
End If

Where the me!txtfilename is the location and name of the image. Does this
feature not work with sharepoint drives?

thanks

 

[Alex Dybenko]

Hi,
no, you can't use sharepoint address like this. What you can do - copy
required image files to local drive on report open and use them from there
then delete them

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[TCF]

Thanks Alex,
I tried this and got the following error (bad file name or number). I was
using the "filecopy" command. I think the issue is with the file name being
on a share point drive. I copied the file name from the properties field of
the file, but i am not sure if the "filecopy" command is the best method for
doing this. Do you have a better suggestion?

thanks

 

[dymondjack]

I've never used a sharepoint drive, but if the problem is arising from trying
to get VBA to recognize the drive, then FileCopy wouldn't work either.

This may or may not work, but you could attempt this from 'outside' vba by
shelling a commandline to cmd.exe to copy the files. I don't know if you
would run into the same issue with cmd.exe as vba, but it may be worth a shot.

Dim sCmd As String
sCmd = "cmd.exe Copy <sharepointdrive>\*.* C:\<yourfolder>"
Shell sCmd


hth
--
Jack Leach
www.tristatemachine.com

- "Success is the ability to go from one failure to another with no loss of
enthusiasm." - Sir Winston Churchill