Results 1 to 5 of 5
  1. #1
    amita is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jul 2014
    Posts
    4

    How to SMS, Email in MsAccess

    Hi,

    I am very new to MsAccess.
    I want to implement following things in my application but not getting how to do that.
    Any comments / links are awaited for this.

    · I want to open POP Up window
    · Want to Add Graph Tool
    · Apply Pagination
    · Add Reports
    · Send Email
    · Send SMS

    Kindly help !

    Thanks & Regards,
    Amita

  2. #2
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    You will need a third party gateway app. Try doing a Google search.

    Send email and reports is a separate issue.

  3. #3
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows 7 32bit Access 2007
    Join Date
    Mar 2012
    Posts
    528
    Here you'll find everything you need
    http://office.microsoft.com/en-us/te...001228997.aspx

  4. #4
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    I use third party Gateways and their API's to get the job done. Having said that, there are features in newer versions of Outlook to manage SMS. So if you already have the service/gateway, I imagine you could use VBA to Automate Outlook and have Outlook manage all SMS traffic. Just guessing here though...

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    1. POP up window
    You want a MsgBox, InputBox, or custom form?

    2. Graph Tool
    What do you mean by that? Access can present data in a graph object on form or report.

    3. apply pagination
    This would be a calculation in textbox on report. http://office.microsoft.com/en-us/ac...010096281.aspx

    4. add reports
    Use report designer.

    5. send Email
    One method is: DoCmd.SendObject

    6. send SMS
    previous posts addressed this
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Learn MSAccess by playing MSAccess Jeopardy
    By pkstormy in forum Sample Databases
    Replies: 4
    Last Post: 11-17-2016, 07:27 AM
  2. Replies: 5
    Last Post: 05-07-2014, 09:25 AM
  3. MSAccess and ADP (web pages)
    By maxcannon in forum Access
    Replies: 0
    Last Post: 01-20-2012, 02:45 PM
  4. Oracle to MSACCESS
    By karankukreja in forum Access
    Replies: 1
    Last Post: 03-24-2011, 08:20 AM
  5. MSACCESS Query
    By saa18 in forum Access
    Replies: 0
    Last Post: 11-14-2008, 05:12 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums