Use buttons to navigate and open current attachment

[mr_right]

Hello.
Good day!
i am new here and beginner in microsoft access.
Just want to ask if it is possible to use buttons to navigate/open attachment?
I have two tables (itemTbl and ItemcomponentTbl) and a form.
Inside formare itemtbl field names (w/c include the attachment) and a componenttbl subform.
Hopefully someone will help me on this.
Thanks in advance.
Captured DB attached.

[rpeare]

Are you storing a path to the picture of the part in your database?

Here's an example that's a bit easier to use:

Mr_Right.zip

Make sure the database and all the jpgs (they're really small for the purposes of this example) are in the same folder

[June7]

You have images stored in database? Access has a 2gb size limit. Unless images are very small they will chew up this limit.

The images are displayed in a subform? The subform is linked to the main form? Are you using an Image control to display images? The attachment field is a multi-value field. Are there multiple images in the attachment field? If so, is the subform RecordSource a query that expands the attachment field entries to multiple records?

[mr_right]

Hello rpeare,
This is great.
This is what i want to to do. Could it be possible to to have a button or can double click the image to open in picture manager?
Because sometimes i send those photo as an attachment to email.

[mr_right]

Hello june7,
Good day!
My images are stored in database. (i use attachment method not link and it is a multiple images).
I use componentstbl as subform.
Thank you for the "2GB size limit" info. I still don't know that.
Thank you guys.
This is a link for my database.
https://www.box.com/s/989yvgsiin9bdfwfu0cn

[June7]

Clicking on the image triggers a little button menu above the image with Forward and Back buttons and a button to open attachment manager. Right click opens a shortcut menu with the same options.

Not sure this behavior can be programmed on custom buttons. Can't find anything.

[mr_right]

I will figure it out.
BTW, thanks for your help.

[rpeare]

As far as email goes, are you mailing more than one image per email? Or are you just emailing one image at a time. Do you want to email all images related to a specific construction? if so you can do that with code as well, you don't need to open any other application other than Access.

[June7]

I don't think opening the image in external app will aid in emailing the image. I have doubts can include image from attachment field in email with the SendObject method unless the image is in a report. Then if you want all the images for each record to show the report RecordSource must be a query that expands the attachments to individual records.

[rpeare]

I wasn't thinking of SENDOBJECT to do the emailing (http://www.granite.ab.ca/access/email/sendobject.htm see this for sendobject's limitations). I was thinking more of using OUTLOOK commands to build the email, I was just assuming since he's using access he's also using OUTLOOK.

[June7]

I think the issue with emailing the attachment images is the same. Can't be just table or query, must be report with attachment field expanded to multiple records.

[rpeare]

Oh I think we're thinking about how to send the email differently. I am thinking that he wants to send an email to a client with a picture, say, of the final product and all the component pieces. You can do that by sending multiple attachments rather than trying to send a query/table. I wasn't even considering that he might want to send a copy of the form (for instance) to someone.