472,127 Members | 1,871 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,127 software developers and data experts.

How do I make an attachment name appear while working in a form (Access 2007)?

Hi all - I have created a form to describe digital photographs (JPGs) attached to my database. Along with the attachment image, I've also added a field that displays attachment name.

However, this field is not populated until I close and reopen the database.

How can I have the form display the attachment name as soon as the attachment is added?

Thanks in advance for your help...
Mar 23 '11 #1
5 1979
32,497 Expert Mod 16PB
What is it that you are referring to as an attachment in Access? I know of no such object. Perhaps if you could tell us the actual name of the object type you're using we could help.
Mar 23 '11 #2
Hi NeoPa - thanks for such a quick reply! The data type I selected for the relevant field in my table is "Attachment". On the form, I added this field to display the attached file, which in this case is a JPG. There is also an option to display the name of the attached file in a separate field, control is source PHOT_ATT.FileName, where PHOT_ATT is the field name. Does this clarify?
Mar 23 '11 #3
32,497 Expert Mod 16PB
Not entirely, but it was enough to enable me to find that the Attachment data type was introduced in Access 2007. I'm afraid I can't help you there as I have no experience with that yet.

I can at least update the title of the thread to make it clear to anyone looking to help, which version you are dealing with. Good luck.
Mar 23 '11 #4
Ah, I should have mentioned which version of the program I'm using. Thanks for checking, and helping me clarify!
Mar 23 '11 #5
32,497 Expert Mod 16PB
No worries Ruth. I'll see if anyone else can help.
Mar 23 '11 #6

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

12 posts views Thread by CJ | last post: by
1 post views Thread by Ray | last post: by
reply views Thread by Ghafran Abbas | last post: by
1 post views Thread by Tyler | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.