Hi everyone, is it possible to add/edit/save picture in MS Access DB using ADO, I have this code
If (MsgBox("Are you sure you entered correct data?" & vbNewLine & "Save now?", vbYesNo + vbQuestion, "Confirm Save") = vbYes) Then
squery = "": squery = "SELECT * FROM tblEmp"
Set rs = New ADODB.Recordset
.Open squery, conn, adOpenStatic, adLockPessimistic
.Fields("EmpID") = txtEmpID.Text
.Fields("LName") = txtLast.Text
.Fields("FName") = txtFirst.Text
.Fields("MName") = txtMiddle.Text
.Fields("Pos") = txtPos.Text
I want also to add/save picture together with this data, using Image or PictureBox.
Then I want to retrieve it later on and display the picture within the Form based on the user's QUERY. then is it also possible to display this picture in Data Report when the user click the command PREVIEW.
Thank you very much for your help.
I will highly appreciate it.