Search results

  1. S

    Search HTML for words

    Hello, Yes we do still use IE as its an internet webpage it only accepts IE, yes it does need to open :)
  2. S

    Search HTML for words

    Hi all I have the below code that opens up Internet explorer and I want it to search the HTML for a certain word. when I run the code its coming back with an error Run-time error: '-2147023170 (800706be) automation error The remote procedure call failed. then highlights While .Busy Or...
  3. S

    Rich Text into Word document

    Hi Doc, I have managed to get plain text to go into a word document and insert to the correct bookmark location that isnt the issue (as shown in my first post with the code), my issue is trying to get rich text in bold ect from an access form to word as when I do it shows the <B> etc
  4. S

    Rich Text into Word document

    Sorry I don't really understand :\
  5. S

    Rich Text into Word document

    Morning Josh Thank you for the below, the issue is I have multiple bookmarks so not sure how this would work?
  6. S

    Rich Text into Word document

    Hi chow could I do that do a bookmark location on word though?
  7. S

    Rich Text into Word document

    I have just tried it doing a simple CTRL+V to CTRL+P and works
  8. S

    Rich Text into Word document

    Hi all I use the below code (with a lot more fields) that converts from an access form into a word template using bookmarks. I have decided to use Rich Tech in the text box so we can bold stuff but I am having issues when it converts it now as the shows all the <DIV>, <strong> tags etc how can I...
  9. S

    VBA Code for Bold Text & Hyperlink

    still not much luck :(
  10. S

    VBA Code for Bold Text & Hyperlink

    Hello its highlighting myItem.BodyFormat = olFormatHTML I have removed the myItem.HMTLbody = _ still showing the same error
  11. S

    VBA Code for Bold Text & Hyperlink

    Hi Minty thank you again for your help, seems to be showing the error message message Run-time 5, invalid call argument : Set myOlApp = CreateObject("Outlook.Application") Set myitem = myOlApp.CreateItemFromTemplate(CurrentProject.Path & "\TemplateFiles\EmailToHR.oft") myitem.Subject =...
  12. S

    VBA Code for Bold Text & Hyperlink

    Hi Minty I tried the following code Set myOlApp = CreateObject("Outlook.Application") Set myitem = myOlApp.CreateItemFromTemplate(CurrentProject.Path & "\TemplateFiles\EmailToHR.oft") myitem.Subject = UCase("HR REPORT COMPLETED - " & "[" & [Forms]![FRM_TBLALL_FullDetails].[Form]![LblRef] &...
  13. S

    VBA Code for Bold Text & Hyperlink

    hello I know not having much luck to be honest :( 150 myitem.body = owoFormatHTML 160 myitem.HTMLBody = _ <B>"The HR Report has now been completed. USBs containing the download report will now be placed in HR Secure storage for your collection under the Ref numbers below"</B> 'End With 260...
  14. S

    VBA Code for Bold Text & Hyperlink

    Thank you, do i simply just change it to myitem.HTMLbody?
  15. S

    VBA Code for Bold Text & Hyperlink

    Hi all I have got some VBA code that opens up outlook, inputs all the subject, To, and body of the email etc I ideally trying to do it so certain text is bold how would I do this? also I want a CLICK HERE link that is a hyper link rather than showing the whole website address any ideas? the...
  16. S

    Opening Website - looking for error

    This is the Only HTML code I can see? <html> <head> <meta http-equiv="Content-Language" content="en-gb"> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <title>New Page 1</title> <link rel="stylesheet" type="text/css" href="CPR.css"> <link rel="stylesheet"...
  17. S

    Password Generator

    Hello Thank you I was able to implement into my form!, I am just having a play about to understand how it works etc, When I delete all the dict text and input my own words it comes up with a run time error '62' input past end file then highlights "Line Input #i, strLine" could you explain why...
  18. S

    Opening Website - looking for error

    Hello, Thank you for the below, I have decided to put it into a button which probably is going to be a bit less annoying for the user, the page opens up but then I get an error of Run-time error '-2147467259 (80004005) automation error unspecified error. it then highlights While .Busy Or...
  19. S

    Password Generator

    I found an Excel website that does it when loaded so wonder if I could grab it from there but would be better to do it within Access if I could :)
  20. S

    Password Generator

    Hi all I have a form with a button that I want to be able to create a random password with 3 English spelt words, random numbers (1 or 2 long) and capitalization and automatically insert it into a textbox any suggestions on how to do this? do I need to create a table with all words or can it be...
Back
Top Bottom