Picture File

[aziz rasul]

Using VBA, how do I dynamically find the filepath and filename of a picture on a command button. I want to change the picture when cmdGo is pressed. The pictures are the ones that appear on the list when you create the button and can be accessed by the Picture property.

Note each user may have a different path to the file, hence the reason why I want to do this on the fly.

 

[Minty]

I think the pictures you can get to via the drop down picker are embedded in a DLL with the Access install, so I'm not sure you can do much with them?

Happy to be proved wrong as always

 

[Grumm]

The pictures are indeed the same for all users that use Access. So you shouldn't need to find the path to that file. It is loaded when you launch the program.
Why not just change the picture of the control and that is it ?

 

[aziz rasul]

Why not just change the picture of the control and that is it ?

I don't want the user to go into design view and do this.

Is the filepath the same in each computer when it's installed? How do I obtain this filepath?

 

[Minty]

Is the filepath the same in each computer when it's installed? How do I obtain this filepath?

I think you're not understanding - there is no file in a file path to get to. So there's no point in getting the path.

And a user should never get to design view - save your DB as as ACCDE, and or install the runtime.

 

[aziz rasul]

Hmm a bit confused. On some websites they show a file path, e.g.

Me.cmdGo.Picture = "C:\some_filepath\somefilename.png"

as if the files are stored in a specific location? Apologies if I seem a bit dumb on this.

 

[Minty]

No apology required, it is a bit confusing - There is a path if you specify an external picture to use.
However the "in-built" button images are not listed like that, as they are stored differently.

 

[aziz rasul]

Ah OK I understand now. Thanks.