Recent content by HealthyB1

  1. H

    Linked Tables

    V-Tools seems to be a great tool. However is there a user manual for it please? I am trying to figure out how to use the DIB Pictures for controls on my forms.
  2. H

    Solved QueryDefs

    Thanks for your suggestion. I have been busy over the past few days so only just saw your message / suggestion. I would be extremely grateful if you could share your routine with me. Thanks in advance.
  3. H

    Solved QueryDefs

    Thanks Sonic8. Ques:- How do I access the DAO library?
  4. H

    Solved QueryDefs

    Thanks for the explanation Doc Man. I tried to do a compile on the F/E but it is too big. Also the documenter will not work. No matter it will give me a task to do tonight.
  5. H

    Solved QueryDefs

    Just wondering where are the execution plans saved exactly? Or it as simple as, once the query is run the first time it flags somewhere that the particular query has been run/executed before? A supplementary question if you will. All the comments that may be included in a VBA module...
  6. H

    Solved QueryDefs

    G'day, I am coming across references to using querydefs in lots of answers to questions in the "Last week's most popular topics" weekly email. I seem to have missed querydefs in my early days of building a database with a about 120mb front end and also a large back end database. I only use...
  7. H

    Query that returns the column names that have never been used

    Great piece of code Pat. I developed several Access DB's many years ago and upgraded same many times as customer needs changed. Always saying after I sorted out the bugs I'd go back and delete old versions of unnecessary tables and remove unused fields. Your application is fantastic. Thanks for...
  8. H

    Fill word with Ms Access

    Once again a big thank you. How do i mark this post as solved please?
  9. H

    Fill word with Ms Access

    Hi Arnelgp. Apologies for the delay. I have been working on other issues (Friday night drinks). The good news is the problem is solved :) After a lot of checking I eventually found that I had a Folder on Drive C: called 'swshare' and also a legacy share drive called 'swshare'. I was working...
  10. H

    Fill word with Ms Access

    Thanks Arnelgp I commented out quite a few lines as you suggested and also added some Debug.Print statements. If you look in the immediate window you will see that "Doc" does not contain anything??? Hovering over it in debug mode contents are always 'Nothing'
  11. H

    Fill word with Ms Access

    Good morning. I have been using the Function "FillwordForm" for many, many years and it has suddenly stopped working. I have been beating my head against the wall trying find out why. When the routine is run Word opens but with a grayed-out screen but no form. See attachment 1 I have put a...
  12. H

    Solved eMailing an ACCESS report in PDF and opening the new OUTLOOK mail in HTML format

    G'day Ranman, Your solution works a treat. Thank you ever so much. Cheers from Adelaide, South Australia.
  13. H

    Solved eMailing an ACCESS report in PDF and opening the new OUTLOOK mail in HTML format

    Hi Ranman, We have had a severe weather event in my area last Saturday and power is yet to be fully restored. Once I can fire up the PC I shall implement your code. Thanks for the quick response and I shall keep you posted on the outcome. Cheers.
  14. H

    Solved eMailing an ACCESS report in PDF and opening the new OUTLOOK mail in HTML format

    I wrote an invoicing system in Access many years ago. I produce an invoice that i then send to Outlook using the default email button in the ribbon of Usoft Access after specified the format as PDF format. It does this ok and opens the new Outlook mail document (IN PLAIN TEXT Format) with the...
  15. H

    How to normalize contacts in Access

    Hi Crystal, It works perfectly now. Many thanks.
Top Bottom