Question savefiledialog to new directory with auto hyperlinked in listbox

[KBJ911]

Hello, I'm access noob and this is my first post .

I need help in my form so I click on button to open file dialog to choose a file (JPG only)* from any directory in my pc
And to copy it to a new default directory with an option to rename it
And to put the new directory link in the listbox with a hypered link to that new renamed picture in the new directory.



Command742

Listbox743

New directory :* \\ehaf-ned61919\kbj911\pic\





Thank you for this great forum.

a stripped db attached.

 

[sneuberg]

You will need to look at the FileDialog for the file picker, the File System Object (FSO for copying files, and FollowHyperlink might be useful in your endevour.

I've attached a database that puts some of this together

 

[KBJ911]

Hi sneuberg

the hyperlink box shows all pic links for all records

can help to recode as:

ONE click button And one link
so, that button to open save and show the link.. in one click proccess.

thas's all what I need

Thanks for help

 

[sneuberg]

If you just want the button that saves the link to open it then add the line shown in red to the SaveImage_Click code

CopyImage Me.ImagePath, Me.OutputHyperLink
DoCmd.RunCommand acCmdSaveRecord
Me.HyperLinkList.Requery
[COLOR="Red"]Application.FollowHyperLink Me.OutputHyperLink[/COLOR]

If you don't want the listbox then just delete it and the line:

Me.HyperLinkList.Requery

from the SaveImage_Click code shown above and delete the Follow HyperLink button and its code