Email comment field RRS feed

  • Question

  • I use MS Access 2013 and am building a database, where I volunteer, consisting of war veterans.

    The first field I hope to create is one that will allow for the user to send a comment or question about that particular veteran to me. It would need to have an email address and comment box on the report. So how do I sent this up in the design view?

    Another feature I want to add is this: I would like to be able to scan and attach the obituary to the person's record as I find them. Is this possible in MS Access 2013?

    Thank you.

    Thursday, March 23, 2017 7:29 PM

All replies

  • Hi,

    Designing a relational database starts with building a proper table structure. Assuming you have done so, the next part is designing your forms.

    I think you'll need a form for sending a comment or question through email. It can be accomplished using either a macro or VBA. For example, you might add a button on the form for the user to submit the comment and the macro or code will send it out in an email either as an attachment or in the body of the message.

    Adding a scanned image of an obituary to the database can also be accomplished a couple of ways. You might use an Attachment field to attach the scanned image to a veteran's record. If you want Access to control the scanner, it might take some code depending on your scanner hardware and software.

    Hope it helps... 

    • Proposed as answer by Chenchen Li Friday, March 24, 2017 2:28 AM
    Thursday, March 23, 2017 7:35 PM