Recent content by josephbupe

  1. josephbupe

    Error - data type mismatch in criteria expression

    Indeed. I missed that too. Now it works. Thanks a lot
  2. josephbupe

    Error - data type mismatch in criteria expression

    Hi, Thanks. I am trying to incorporate your code in mine, but I am getting an error: too few parameters, as attached.
  3. josephbupe

    Error - data type mismatch in criteria expression

    Just one last thing. How can i format this part of the code to search multiple keywords in a row? If Me.txtObjectTags <> "" Then varWhere = varWhere & "[ObjectTags] Like '*" & Me.txtObjectTags & "*' AND " End If
  4. josephbupe

    Error - data type mismatch in criteria expression

    I really appreciate it
  5. josephbupe

    Error - data type mismatch in criteria expression

    Ah yes. Thank you so much
  6. josephbupe

    Error - data type mismatch in criteria expression

    Hello, I am trying to implement a multiple criteria options to query my database, but I am getting the error "data type mismatch in criteria expression". I have checked through the code for syntax errors but can't spot any issue that I know of. What I want is any combination of the criteria...
  7. josephbupe

    Automatically re-link tables in a back-end file

    Indeed, Allen's code is super easy to implement. I followed your tips and achieved what I wanted. Thank you so much to you all for the help. Best regards.
  8. josephbupe

    Automatically re-link tables in a back-end file

    Thanks for sharing. In fact there is also this other code I found, which who suit my scenario, unfortunately it's giving some errors. I hope someone can update it: https://accessdeveloper.net/relinking-back-end-to-front-end-database-automatically-using-vba-code/
  9. josephbupe

    Automatically re-link tables in a back-end file

    The folder contaning my BE and FE is on a movable drive which I carry along with me.
  10. josephbupe

    Automatically re-link tables in a back-end file

    Hello, I am looking for a code to automatically re-link ms access tables. My front-end and back-end are both in the same folder, but the folder location ma changing machine locations. Google search found me this link links http://allenbrowne.com/ser-13.html but it's for old versions of ms...
  11. josephbupe

    Copy and rename image files and return the relativepath of the images and back-end file

    Hello bastanu. Thank you for your advise and the module you just posted for me. However, let me confess to you that I have limited knowledge of VB programming. Please, see the attached copy of the the accdb file for your perusal.
  12. josephbupe

    Copy and rename image files and return the relativepath of the images and back-end file

    Ah, sorry for not including more information earlier. I meant to say that the database would be mobile on a thumb drive, and so I would like to have all its folders and files in them to stay linked to the front-end within the same folder. The first time i tried to move the database on a thumb...
  13. josephbupe

    Copy and rename image files and return the relativepath of the images and back-end file

    Ok that has been corrected and now images can be uploaded, What i need now is to only populate the table with a relative path contaning the images, not the full path. Right now i can only scratch my head wondering how to achieve that.
  14. josephbupe

    Copy and rename image files and return the relativepath of the images and back-end file

    OK, please, I have attached the databse file for expert perusal, if you don't mind to look. Sorry i am a total amateur.
  15. josephbupe

    Copy and rename image files and return the relativepath of the images and back-end file

    Actually, the error is pointing me to this part of the code:
See more
Top Bottom