Search results

  1. P

    Getting email address from form field for macro

    Working now. The form was opening with no records in it, not sure why! Thanks all so much for your help. Pino
  2. P

    Getting email address from form field for macro

    Hi, Thanks for the suggestion. Unfortunately that also throws an error, please see below:
  3. P

    Getting email address from form field for macro

    With a form based on a query that retrieves only one record. The form has a field called email, see screenshot below:
  4. P

    Getting email address from form field for macro

    Hi, Good call. I had it set to not edit the email, so I had not seen it. It is not retrieving the email address from the open form field, just entering what I thought was a parameter. Screenshots of the form that selects the person and provides the email address, and of the actual email with...
  5. P

    Getting email address from form field for macro

    This is the macro and the message I get:
  6. P

    Getting email address from form field for macro

    The field is not blank and the email is not invalid, but Access does not seem to be able to recognise it. That is the message it gives me.
  7. 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...
  8. P

    Question How to stop users from ever seeing database window

    Thanks all of you for your replies. I think I may try a customised ribbon and see what happens. Disabling F11 also sounds good. Thanks again!
  9. 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...
  10. 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...
  11. P

    How to create a string from a query

    Well, that worked a treat! Thanks so much, one more trick for the bag :)
  12. P

    How to create a string from a query

    I only have it in access 2010, I am not sure if it can be converted back to 2003. I'll have a look tomorrow and will let you know. Anyway, I am thinking of trying to create a function. Thanks, Pino
  13. P

    How to create a string from a query

    Thanks, Bob. The 52 fields are not on a table but on a query. Basically I am working on a timetable programme. I have a table with subjects, three fields. A table with periods, another one with teachers and another with classes. I then have a timetable table with a field for each of the above...
  14. P

    How to create a string from a query

    Thanks Bob. I have tried that but I end up with lots of //// joining the empty fields. I am doing a timetable program and the 52 fields is the number of subjects on offer, so each year group may end up doing more than one subject on each period (splitting the year group, of course).
  15. 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