I find a part of the solution with the help of Palvo (http://sites.google.com/site/msaccesscode/). It's Loop within the main Loop,
This is my code to copy a record with a attachment data type :
Dim rstFrom As ADODB.Recordset
Dim rstTo As ADODB.Recordset
Dim rstMVF...
Yes, it's just a query like
INSERT INTO tblFichesEspacesClos ( PhotoGenerale )
SELECT tblFichesEspacesBkup.PhotoGenerale
FROM tblFichesEspacesClos
WHERE (((tblFichesEspacesBkup.NoFicheEspaceClos)=77));
PhotoGenerale is an Attachment data type (and the key field is AutoNumber)
It's not...
Hello,
I'm trying to create one record from another one. One field is attachment data type. I just create a normal query (INSERT INTO) but it' not working (impossible with multiple value field). Do you have a suggestion about inserting or updating an attachment datatype field (with or...