469,090 Members | 1,326 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,090 developers. It's quick & easy.

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 1913
32,159 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,159 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,159 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
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.