Recent content by PeteB

  1. P

    Invisible Query

    Hi GP I haven't yet done the full mail merge but the temp table is visible in the Word record source list and the 'Preview Results' toggles OK, so I'm guessing it will work when the time comes. Thanks a lot for your help and all the best. PeteB PS - when I run a make-table query from a select...
  2. P

    Invisible Query

    Hi GP Thanks for swift response. Yes, from the word side. PeteB
  3. P

    Invisible Query

    Dear Experts I have just created a new query in Access (copied & pasted an existing query, renamed & set different criteria) with the intention of using it as a Word mail merge data source but, when selecting the recipients > ‘use existing list’, the new query does not show in the list of...
  4. P

    Sub-form within a sub-form

    This might be a crazy question but, Sub-form within a sub-form - is this possible? If so, how?
  5. P

    Email completed form (active Word document) by pressing 'Submit' command button

    Thanks Gasman I've looked at the site you suggest but am not sure how it relates to what I'm trying to achieve. I couldn't find any relevant code. PeteB
  6. P

    Email completed form (active Word document) by pressing 'Submit' command button

    Hi Isaac Thanks for your advice. When looking for CDO code, I came across Microsoft Visual Studio which apparently covers various coding systems. Who new there were so many? Still haven't found a solution that I can make work. Thanks again. PeteB
  7. P

    Email completed form (active Word document) by pressing 'Submit' command button

    Thanks for explanation - that should keep me busy for a while. PeteB
  8. P

    Email completed form (active Word document) by pressing 'Submit' command button

    Thank you for above response. I think you are reading my words correctly. Your response however does lead me to further queries. Why would Microsoft build into Word the functionality of Developer field controls if a form created using them was not then apprpriate to be on a web server? I am...
  9. P

    Email completed form (active Word document) by pressing 'Submit' command button

    I've created a single page Word form using Developer text controls which is to be put on to our website and serve as a membership application form but, not being code-savvy, I'm finding picking through the different sets of VB code offered to get the job done to be a nightmare. The code will be...
  10. P

    Hyperlink in Access to Word Document

    Thanks Ranman, I'll give it a try. PeteB
  11. P

    Hyperlink in Access to Word Document

    Hi All I have an Access database within which two of its forms, apart from the fields you would expect to see, each have a multitude of hyperlinks, some linked to items within the database and some to either Word documents or templates. Two of the Word templates contain fill-in fields, and...
  12. P

    Mail Merge Headache

    Thanks guys. I'll see what I can make of all of the responses. PeteB
  13. P

    Mail Merge Headache

    Hi Guys Can anyone help with my mail merge headache? I had planned to do a mail merge starting with a Word main document and an Access database query as the data source, then moving into Outlook as the mail handler. In preparation, I created the Access query which filtered out all but the...
  14. P

    Chart Colours

    I've tried stripping a copy of the database, just leaving a couple of records but, in the procees, the chart becomes nonsense. So, many thanks for your time and effort but I will pursue a solution through other channels. Thanks again.
  15. P

    Chart Colours

    The latter (2016).
Top Bottom