Email form and update record with reply

deb

Active Member
Joined
Feb 1, 2003
Messages
400
Access 2013
I have a form (fReqWBS) I need a button to email the form to BAnalyst field.
Also include the one field (WBS) that the BAnalyst must input.

Is there a way to update the data record with the email response?

User pushes button
Email is sent to BAnalyst with request to supply WBS
Email also contains image of form so they can see the pertinent data
BAnalyst replies with the WBS entry
Database updates record with WBS reply.

Need this really bad.
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Normally you dont email a 'form', do you mean, email the data in the form??
emailing a form would just be a picture.

Now you COULD export the data to an Excel wb,
then THAT wb would have ADO vb code in it to post their reply back to the database.
 
Upvote 0
How would I do what you said...Now you COULD export the data to an Excel wb

I need to email recipient to be able to see all fields on the form and send back the response to one field.

Thank you in advance
 
Upvote 0
In the Access program you'd run a macro to send that person the data via email.
sendTO person, query

But if you dont have Access program, then the user would get the data in spread sheet
select the answer,
click a button, that runs a macro that sends the data back to the access db via ADO

Code:
Dim con As ADODB.Connection
Dim rs As ADODB.Recordset
Dim DB
Dim vProvid


Set con = New ADODB.Connection
Set rs = New ADODB.Recordset
 
 uid = "HomerJSimpson"
 pwd = ""
 DB = "\\myserver\production\Generic104J.mdb"
 vProvid = "Microsoft.Jet.OLEDB.4.0"     '  "SQLOLEDB"
 
  
With con
    .Provider = "Microsoft.Jet.OLEDB.4.0"
    .Properties("User ID").Value = uid
    .Properties("Password").Value = pwd
    
    .Open "Data Source=" & DB 
End With
 
Set rs = con.Execute("quUpdateQuery")
 
Upvote 0
I am not that great with vba so I am not sure this is doing, or what to do that it...
Where does it go and how is it used
 
Upvote 0

Forum statistics

Threads
1,213,565
Messages
6,114,338
Members
448,570
Latest member
rik81h

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top