Solved How to get the Attachment in the Form:--

[sbaud2003]

Hi Sir.....
I have a form called FrmMain which get loaded after Login by the User --- (from FrmLogin, Using USEID and the Password)
The FrmMain displays the details of the User on Login like name, ID and Address (Through unbound control boxes)
I have access the Values of the variable from the Table Tblusers (Member_ID as Pkey) and TblMember (Member_FK) (User Login) through Global Variable
Is there any possibilities to Show the Photograph of the User which in stored as attachment in the TblMember.

I have not tried anything because I don't know whether this can be done or not

Hope to get some help....

 

[jdraw]

Using Google:

Attach files and graphics to the records in your database - Microsoft Support

Learn how to use the Attachment feature in Access to add one or more files to the records in your database.

support.microsoft.com

 

[Gasman]

You could also look at the MS Northwind DB which also does that.?

 

[theDBguy]

Hi. I think, maybe, the easiest way is to use bound subform for it. You can set AllowEdits = No, if you want it to behave like an unbound control.

 

[isladogs]

Yes you can certainly do so. In fact its one of the common uses for attachment fields.
Have a look at the MS Contacts template database which includes that feature.

Having said that I recommend you store the photos externally to avoid database bloat.
You would then store the file paths in your app and display the photos using an image control

 

[sbaud2003]

Hi. I think, maybe, the easiest way is to use bound subform for it. You can set AllowEdits = No, if you want it to behave like an unbound control.

 

[sbaud2003]

Thanks

 

[theDBguy]

Thanks

You're welcome. We're all happy to assist. Good luck with your project.