Results 1 to 6 of 6
  1. #1
    Voodeux2014 is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Nov 2014
    Location
    Slidell, LA
    Posts
    130

    Exclamation Collecting data from emails


    I am trying to find a way to create a form of sorts that I can send out via email to have user's fill out and automatically will update my access database. I have Access 2013 and I do not see the feature that I saw in 2007/2010.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,549
    Is it possible NOT to use email , but rather give them an access form to open and add the data? (a user entry sceen only)

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    Right, MS mostly eliminated Collect Data from 2013. If you still have 2007/2010 available can build db with Collect Data then open in 2013 and it is supposed to work, cannot build Collect Data in 2013.

    Only alternative I know is lots of VBA code to pull data from email.

    Who are these 'users' - remote clients, customers - not staff connected to your network?
    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.

  4. #4
    Voodeux2014 is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Nov 2014
    Location
    Slidell, LA
    Posts
    130
    All the users would be direct employees of the company. Not everyone has the Microsoft Access program on their systems as all systems were purchased at different times and what not. I see that I could create an excel sheet and have it linked to the database, but then it would cancel out the opportunity to use the actual database to make changes.

  5. #5
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,549
    If not, I built a form in Outlook and on SAVE click:

    (be sure to load ADO library in the VBE menu, TOOLS, REFERENCES..
    Code:
    '---------
    Public Sub SaveRec()
    '---------
    Dim sSql As String
    Dim cn As New ADODB.Connection
      'collect all the text box values to SQL
    sSql = "INSERT INTO tData ( DbtrName, DbtrAddr, DbtrZip ) values(" & _
    "'" & txtName & "'," & _
    "'" & txtAddr & "'," & _
    "'" & txtPhone & "')"
    SaveADO sSql
    End Sub
    '---------
    Public Sub SaveADO(ByVal pvSql As String)
    '---------
    Dim con As ADODB.Connection
    Dim DB
    Dim vProvid
    Set con = New ADODB.Connection
    Set rs = New ADODB.Recordset
     
     vProvid = "Microsoft.Jet.OLEDB.4.0"
     uid = ""
     pwd = ""
     DB = "\\server\folder\MyDatabase.mdb"
         
    With con
        .Provider = vProvid
        .Properties("User ID").Value = uid
        .Properties("Password").Value = pwd
        
        .Open "Data Source=" & DB
    End With
     
    con.Execute pvSql
    con.Close
    End Sub

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    If there are multiple users, should split database. Each user should run their own copy of the frontend. If users do not have full Access, can publish the frontend as a runtime version. I am not sure if each user will need to download the free Runtime app or if it is packaged when you convert the db http://www.microsoft.com/en-us/downl....aspx?id=39358
    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. Checkboxes in Email for Collecting Data
    By pietvoerman in forum Forms
    Replies: 4
    Last Post: 07-04-2014, 12:50 AM
  2. Replies: 1
    Last Post: 09-12-2012, 12:42 PM
  3. Collecting All data
    By Andrias14 in forum Queries
    Replies: 2
    Last Post: 01-30-2012, 06:42 AM
  4. Replies: 1
    Last Post: 12-13-2011, 08:11 AM
  5. Collecting data via email with drop downs
    By tlyons in forum Access
    Replies: 2
    Last Post: 01-19-2011, 10:34 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