opening "my pictures" folder

[drshahriyar]

dear users. is it possible that i can open "my pictures" folder on double clicking (bound object frame) in my form. after opening "my pictures" folder i want to double click the picture i want and it should appear on my (bound object frame) on my form. thanks

 

[freakazeud]

re:

Hi,
check the attached. This is one way of dealing with this.
Keep in mind that this requires a Microsoft Office Object library reference (VBA Editor--Tools--References...). I normally like to avoid controls like this because of their version and reference dependency but in this particular scenario it is good to show the previews of the images. If you don't care so much about that then I would definitely suggest using this API code instead.
HTH
Good luck

 

[drshahriyar]

getting error with your sample file

thanks for the nice database sample. this is exactly what i need. but there is a problem. when i copy and paste it in my database it gives an error. "compile error. user type not defined." it highlights the (Dim dlg As FileDialog). it runs fine with your sample.

 

[freakazeud]

re:

Keep in mind that this requires a Microsoft Office Object library reference (VBA Editor--Tools--References...).

HTH
Good luck

 

[drshahriyar]

thanks a million

thank you so much for all your help.

kind regards