Search results

  1. D

    Creating a report range

    Hi all, I'm using Access 2010. I'm looking to build a report that summarises the number of completed tasks, calculates the % complete for a given Name then groups them into a percentage range, ordered highest to lowest. Query fields: Date, Locality, Name, Task, TaskStatus (Criteria of...
  2. D

    Question Recording an email has been sent (time & date, subject and body)

    Hi all, Apologies if this is in the wrong forum, wasn't confident which it would fall under so plumped for general. My problem I don't know how to record emails that are being sent from Access. My database sends emails using Outlook with no problem. The form has two text boxes, txtSubject...
  3. D

    Attachments in Outlook

    Hi, I have contacts database that is going to be used to send emails (using Outlook) using VBA, occasionally there will be the need to add attachments. The form has a textbox in which the path to the document to be sent is entered. All is well whenever an email is sent with an attachment, but...
  4. D

    Print attachment content in report

    Hi all, I've a database on which files can be attached to records - these could be pdf, doc, xls files. Is it possible in an access report, to show the detail of the record and the content of the attachment in the access report so when it is physically printed all details of the record and...
  5. D

    Question Replace a record value with a pre-determined comment?

    Hi, I'm hoping for some help, I am working on what is a small and fairly straightforward database but am having trouble with one aspect of it. Apologies for the title of the thread but i didn't know how to phrase it! This is in Access 2010. The database is required because we now have forms...
  6. D

    GoTo last record of subform - some blank records

    Hi, I've tried searching but haven't come across what i need (might be my poor searching skills) Basically, i need a subform to default to the latest record. I have OnCurrent set as [SubFormName].Form.Recordset.MoveLast which works fine when the subform has a record to display. However...
Back
Top Bottom