how to set the path

[rexb]

I tried to run your example that you posted but it gets lots of missing reference errors.

I am modifying my example for you. I will post it when it it ready.

Thank you very much. I will be waiting.....

 

[HiTechCoach]

Thank you very much. I will be waiting.....

See the link in the post #19

 

[rexb]

See the link in the post #19

hello,

I will try to incorporate this on my form. Thank you very much HiTechCoach, you're really Hi Tech!

 

[Max D]

... And then again this would be placed on a flash drive so assigning a drive would not be reasonable becuase as i've said it is on a flash drive and once it is moved to another computer the drive path could be different. I'm really at a lost on the coding so if you/anybody could help out I would very much appreciate it.

You can try AccessImagine addon, it handles external storage (even with relative path to database) without any programming - so Flash drive wount be a problem.

The bad news is it works only with images - but not with other document types :-(

 

[rexb]

hello,

I will try to incorporate this on my form. Thank you very much HiTechCoach, you're really Hi Tech!

hello again,

looking at it it works fine and I was able to incorporate it on my database. Is there a way when I try to pull up a picture it will instantly show the image and no need to click view. only for images.

 

[HiTechCoach]

You could modify the VBA code in the "view" command button to load the image into a control on the form.

change

    retval = bimShellOpenFile(Replace(Me.DocPath, "%dir%", Me.txtFolder), vbNormalFocus) ' vbNormalFocus  True

to something like:

    Me![ImageFrame].Picture = Replace(Me.DocPath, "%dir%", Me.txtFolder)

*********>>>>> WARNING <<<<<***************
This will NOT work with a form in continuous view mode!
*********************************************

That is why my example, which is a form in continuous view mode, opens the image in the associated application and NOT on the form. You coudl use a pop-up form to show the image.

There are third party controls that you can purchase to all ow you to display an image in a unbound image control. Max D provided a link to onew that may be his. Also check out the one here http://www.ammara.com/

 

[Max D]

You could modify the VBA code in the "view" command button to load the image into a control on the form.

There is an innovation in Access 2007 - regular Image control can be bound to a field/query with a picture path and filename. It works in continuous forms too.

Max D provided a link to one that may be his. Also check out the one here http://www.ammara.com/

I know my judges can't be independent because I'm one of the AccessImagine developers. But if you like Ammara DBPix, it will be usefull to look at http://access.bukrek.net to compare.

 

[HiTechCoach]

There is an innovation in Access 2007 - regular Image control can be bound to a field/query with a picture path and filename. It works in continuous forms too.

Thanks for the tip about 2007.

I know my judges can't be independent because I'm one of the AccessImagine developers. But if you like Ammara DBPix, it will be usefull to look at http://access.bukrek.net to compare.

Thanks for the link. I will definitely check it out and give it a good test drive!

 

[rexb]

Thank you very much for you patience I now this has been a very long thread hopefully it would be done soon.

Max D,

Thank you very much but I am only using access 2003

HiTechCoach,

My add form is a single form. Why do I get "Microsoft Office Access can't open the file '%dir%\AHSEMSFacilities\buildingimages\untitiled.bmp'. ?

 

[HiTechCoach]

Thank you very much for you patience I now this has been a very long thread hopefully it would be done soon.

Max D,

Thank you very much but I am only using access 2003

HiTechCoach,

My add form is a single form. Why do I get "Microsoft Office Access can't open the file '%dir%\AHSEMSFacilities\buildingimages\untitiled.bmp'. ?

You will need to use something like:

Replace("%dir%\AHSEMSFacilities\buildingimages\untitiled.bmp", "%dir%", "c:\myfolder")