To insert a bound object frame(picture) for each record to be stored in table

[Kitana]

Hello guys...

I hope some of you guys can help me with this problem. (My first language is not ENglish, so here goes....)

I'm trying to insert a picture for each employee to be stored in an Employees table from a form.

What I want to do is for the user of this database to insert a picture using a form (that has an additional button to insert the picture) to be stored in a table.

I would like this additional command button to pop-up a dialog box asking the user to browse the picture for the Employee, and as soon as the user has select the picture file (e.g: jpg, bmp, gif) and click OK, then the form will store the picture in the Employees table.

Does anyone know any other way to do this, besides using a command button? Or does anyone know the code to make this particular command button to function like what i wanted to do.

p/s: I don't have any background of using vb, so my knowledge in VB is limited.

Hope you can understand what I'm explaining here. Please feel free to ask me any other information for the database that I'm working on.

 

[ColinEssex]

There are examples of employee pictures in the Northwind database that should have been loaded with your Access software. That may help you.

Col

 

[Kitana]

I didn't realise what I was looking for is right there staring in front of me. Thanks Col...

What I had in mind is actually a command button that the user can click to insert the picture instead of right-clicking in the OLE object box (like what is shown in the Northwind database).

I guess right-clicking is enough though. I can just make a note somewhere to tell the user to right-click in the box and not looking for any other buttons that he needs to click to put the picture in.

Thanks for the help. I didn't expect someone would response to this topic so quickly.
This is actually my first time using a message board to ask help for my project.

 

[GJT]

this link may help you further.....