problem in editing records with visual basic

[davidvhp]

Thank you orange.
Can I ask you another question ?
I have a table T_user, where one of the fields is "photo" . This fields is of "attachment" type. I am having troubles in saving the foto from a imagebox into this field. I have tried thios way :
CurrentDb.Execute "update T_utilizador " & " set ", photo=" & Me.image42 & "" & _


" where usernameID=" & 1

But this way is not working. Do you know how can I do it ?

Regards and thank you very much again.

[orange]

I have AC2003 which does not have attachment type fields.
I would recommend that you use a text field to record the location and name of the "Photo", and store the photo in the general file system ---- something like
C:\MyPhotos or whatever. Then use a hyperlink to go to the photo when you need it, or use an image control.

There are links on the net with examples.
Here's one http://www.jamiessoftware.tk/article...ingimages.html