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.
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.
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)
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.
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.
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
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.