Search results

  1. T

    Trying to do a mail merge via MS Word - why not working?

    Total VBA newbie here, but I've been able to piece together a code with varying degrees of help. I'm trying to make a button that uses a Word-document to perform a mail merge direct to the printer, and then close. The code below opens the document that contains the mail merge data, but merges...
  2. T

    Sendobject macro: populate message with field from database?

    I have created a button to send a form as a PDF attachment in Outlook, using the Sendobject macro. Is it possible to populate the subject line and message text with values from a form or table? I tried inserting !Forms![Example] into the subject line, but it simply puts that as text into the...
  3. T

    Query: counting certain values

    I did that before posting this, it somehow doesn't do what I want it to. I want to be able to count the number of Yesses in columns A, C and E of row 1; the number of Yesses across multiple columns/fields for just one record, basically. If these all contain Yes, the result should be 3. I can't...
  4. T

    Query: counting certain values

    I have a pretty big main table, with lots of colums, containing mostly Yes/No fields. Is it possible to make a query that simply counts the number of Yesses or Nos in multiple columns? For example, I want to get the number of Yesses in columns A, C, and E. I don't know any VBA, so if it is...
  5. T

    Printing forms, differently coloured pages?

    I found it, thank you. It was buried deep inside some right-mouse-click windows :)
  6. T

    Printing forms, differently coloured pages?

    I only need to print a specific record, not sets of records. And it needs to be a very specific layout. Can reports be used for that? Besides the point, anyway.
  7. T

    Printing forms, differently coloured pages?

    Where do I find this? Bear in mind that I have absolutely no knowledge of VBA code...
  8. T

    Printing forms, differently coloured pages?

    I've created a form which stretches across multiple pages. I've noticed that, when I print the form, the odd pages have a white background (as intended), the even pages have a grey/purplish background (which is not as intended, obviously). My form will use 2 pages max, but when I stretch the...
  9. T

    Macro: PrintOut function not available?

    Oh dear, it was that simple :o Thanks!
  10. T

    Macro: PrintOut function not available?

    How come the option PrintOut is not available in the building tool for macros in Access 2007? I know the option is not available when your database is not trusted, but it is (I'm pretty sure). Any other reasons for this? My Access is not in English, but I still can't find it.
Back
Top Bottom