Search results

  1. P

    Getting email address from form field for macro

    Hi, I am trying to send an individualised report pdf to a number of people in my organisation using a macro. It is all working well and I have got a working loop that selects each individual one at a time and sends the email with the pdf attachment. The To field in the macro is set to retrieve...
  2. P

    Question How to stop users from ever seeing database window

    Hi All, I have included some code (borrowed from a kind poster) to disable the access PassKey (holding shift down as you open the database so that the database window appears). It is password protected and it works pretty well for normal users. However, I have realised that even in this...
  3. P

    emailing report pages individually

    Hi all, I have a report with one page per student (grouped by studentID). It has over 200 students/pages. I would like to email each student their relevant page (I have email addresses linked to the studentID), without having to create an individual query/report manually for each of them. Is...
  4. P

    How to create a string from a query

    Hi all, I am having some trouble retrieving data from a query in the format I want it. I have a query where for each record there are 52 fields. Only three or four of those 52 fields actually have some data in them, the rest are empty. I need to set up a calculated field that will join the...
Top Bottom