Search results

  1. F

    Load attachments via VBA

    That other problem got solved mate. Thanks but now when the file dialog pop opens and you chose the files i got error in this line, i tryed add the me.prefix but didnt solve. "Set rsAttach = .Fields("Me.Anexo412").Value" The mensage is item not found in collection Maybe i have to say what is the...
  2. F

    Load attachments via VBA

    If i leave the DAO i cant add the 14.0 Access database, i can only use the existing 15.0
  3. F

    Load attachments via VBA

    I cant compile because of the error i talked about
  4. F

    Load attachments via VBA

    Somewhow the problem is a conflict with DAO 3.6 and it cant coexist dao 3.6 with 14.0 access database. I deleted the DAO 3.6 and now the error is more down in line 4 "Dim dlgOpen As Office.FileDialog" Say type not defined by user....
  5. F

    Load attachments via VBA

    I cant choose 14.0. The system is telling me that name is in conflict.:banghead::banghead::banghead:
  6. F

    Load attachments via VBA

    When i have a error when i try to add a reference to the project saying that i have a name in conflict, with module, project or library already existing. And didn't add the reference Right now I have this references: Visual basic for applications, Microsoft access 15.0 Access database engine...
  7. F

    Load attachments via VBA

    But its supposed to have to open a blank project to add the reference? I dont know if it is normal. Im gonna test.
  8. F

    Load attachments via VBA

    I cant add the reference with this project open, only when a blank project is open. Its supposed to be like that? It pop ups a error in form view saying "Compilation Error: The defined type by user was not defined" I allready add microsoft DAO 3.6 Object Library.:banghead: Maybe I´ve misspelled...
  9. F

    Load attachments via VBA

    I noticed now that DAO360.dll was missing. I download it but now the error is in line Dim rsAttach As DAO.Recordset2 Im scratching my head figure it out..... I will have white hair very soon because of access
  10. F

    Load attachments via VBA

    Well I put your code but it give me an error on the beginning of the code. :banghead::banghead: In this part: Dim rsRecord As DAO.Recordset" I compiled the code this way. Private Sub SaveToAttachmentField() Dim rsRecord As DAO.Recordset Dim rsAttach As DAO.Recordset2 Dim fldAttach...
  11. F

    Load attachments via VBA

    Well i have the x.14 object library and i can open the filedialog but i cant find the code you talked about in access. Well listening to your advice i need it to do a few things upon attachement. 1º Rename the file as same as the number of the auto parts. Ex.part1_1;part1_2 (This number have to...
  12. F

    Load attachments via VBA

    Im quite new in VBA programming. Do you have an idea how to compile the code? I think you´re right concerning the SelItem, but even with only one picture i cant attach it directly, how can i do it? I think i could have the path but i need then the photos to be renamed and copyed to a specified...
  13. F

    Load attachments via VBA

    I I'm trying to load the max of 8 attachements on the specified form. I've this code so far? 'FILE DIALOG OPENS UPLOAD PANEL Private Sub Comando715_Click() Call Selectfile End Sub 'FUNÇÃO CAIXA DE SELEÇÃO Public Function Selectfile() As String Dim Fd As FileDialog Dim Filtro As...
Back
Top Bottom