Search results

  1. B

    Invalid Call or Procedure - Error 5

    CurrentDate = Date CurrentTime = Time() CurrentDate = Replace(CurrentDate, "/", "_") CurrentDateandTime = "_" & CurrentDate & " at " + CurrentTime & ".pdf" Operations = "cat output" OutputFilePath = OutputPath & "Search_Report.pdf" ' xxxxxxxxxxxx ArgumentString = FirstFilePath...
  2. B

    Invalid Call or Procedure - Error 5

    Full Code Posting Dim SearchName As String Dim SearchArea As String Dim Sql As String Dim StrCommand As String Dim Response As String Dim Report1 As String Dim Report2 As String Dim Report3 As String Dim Report4 As String Dim Report5 As String Dim Report6 As String Dim Report7 As String Dim...
  3. B

    Invalid Call or Procedure - Error 5

    I am trying to rename a file in my procedure, my code has stopped working recently and I cannot work out why. I am running Windows 10 and Access 2019, I have posted my code below Any help would be most appreciated. RenameInput = Environ("userprofile") &...
  4. B

    Printing a barcode on a Label

    I am using an Ean13 code
  5. B

    Printing a barcode on a Label

    do you thinkthat the rest of the code looks ok?, if I print a label without the barcode it all prints ok
  6. B

    Printing a barcode on a Label

    I highlighted the error in bold in the code
  7. B

    Printing a barcode on a Label

    with that I get the error againt filedata at the end method or data member not found
  8. B

    Printing a barcode on a Label

    I thought that this would be simple but! I have a field in a table defined as an attachment, in the field i have attached an image of a barcode. All i want to do is retreive the picture from the table and print it on a label. All my code to select the record works, but when I try to retreive...
  9. B

    Receive emails using vba in thunderbird as client

    Hi I need some code to receive emails into my thunderbird client. I have the code to send which I have used successfully for quite a while. Any help would be much appreciated. Thanks in anticipation Regards Ian
  10. B

    Access 2007 VBa using Thunderbird Mail

    I replaced the wait statement with a counter to 10000 For counter1 = 1 To 10000 Next That worked for me Regards
  11. B

    Access 2007 VBa using Thunderbird Mail

    Thanks for All the help The solution I used was the excel example, however the wait statement was not recognised so I substituted a counter loop to 10000 and that fixed it. I need to work out how to add 4 sometimes 5 attachments automatically. Thanks again Ian
  12. B

    Access 2007 VBa using Thunderbird Mail

    I havn't got a problem, but my email hoster TSHosts has updated the encryption settings for my email service. Outlook 2007 does not recognise them and they recommended using Thunderbird as a solution. The enquiry and email system that we use has been working fine for the last 10 years with no...
  13. B

    Access 2007 VBa using Thunderbird Mail

    Hi I am wanting some code for sending email using thunderbird as my mail client instead of outlook currently used. My hosting provider suggests I use Thunderbird to overcome a problem. My current system works ok, I just need to change the settings to Thunderbird Thanks in anticipation Best...
Top Bottom