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 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...
  4. 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...
  5. 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