Recent content by Access or E

  1. A

    Solved filter adds Lookup_field. to field

    I am referring to the period after [Lookup_Code]. Now I see it is a table name with the period preceding the field name. Thanks for your help, DBG.
  2. A

    Solved filter adds Lookup_field. to field

    I am not sure what the period is for in "Replace(Forms!FormName.Filter,"[Lookup_Code].","")"
  3. A

    Solved Detect through ACCESS if an Excel file is already opened

    How does one find the Excel lock file? It is not like Access which generates an .laccdb or .ldb lock file.
  4. A

    Import Outlook Email Body Without Signature

    Thanks for the response Doc_Man. Is there any way of separating the signature from the email body without using Word? That was just a last ditch effort since I couldn't figure out how to do it with Access vba. Thanks in advance.
  5. A

    Import Outlook Email Body Without Signature

    Does anyone know how to do this? Whenever I import the email body, it includes the signature, which I don't want. The code using the Word bookmark does not work. Dim applOutlook As Outlook.Application Dim nsOutlook As Outlook.NameSpace Dim cfOutlook As Outlook.Folder Dim ifOutlook As...
  6. A

    Copy Linked Access Tables to Local Tables with VBA

    When I try the DoCmd.RunCommand acCmdConvertLinkedTableToLocal it throws a runtime error message 2046.
  7. A

    Copy Linked Access Tables to Local Tables with VBA

    I have an MS Access database with linked network tables that I need to copy to local tables into a new database along with the front end using VBA. How would I go about doing this? Would the TransferDatabase method be the best way? Thanks in advance for advice.
  8. A

    Error Loading Annotations

    That is another likely culprit... I will try to have the user IM me the next time he gets the error but it seems like a "one-off". Running the same backup procedure in Access now doesn't generate the same error.
  9. A

    Error Loading Annotations

    Another possible culprit is Java, although the error message itself is not very useful in that respect.
  10. A

    Error Loading Annotations

    Yes DBG, that is exactly what I thought. I cannot find "loading annotations" online in reference to MS Access. I was thinking SAP or maybe Tableau was generating the error message, but the user insists that those programs are not installed on his pc.
  11. A

    Error Loading Annotations

    Has anyone seen the attached error using MS Access? It came up when a user was doing a backup of the database which uses the TransferSpreadsheet method to copy the contents of two tables to an Excel workbook. Thanks in advance for any guidance.
  12. A

    Convert PDF to Doc

    How would you control the xpdfreader from within Access with vba to convert pdf to txt?
See more
Top Bottom