Solved

Accessing Data Submitted by Form

Posted on 2007-03-23
3
167 Views
Last Modified: 2010-04-30
After submitting a form that is writing to a database and sending an email, how do I program the form to generate some type of link that when accessed will retrieve the data entered and allow the viewer to enter more information and resubmit the form thereby sending another email.  This process could happen multiple times.  
0
Comment
Question by:contesa
  • 2
3 Comments
 
LVL 11

Expert Comment

by:Dany Balian
Comment Utility
are u talking about web (asp/vbscript) or vb6?
0
 

Author Comment

by:contesa
Comment Utility
ASP/VBScript using an Access database...

I know how to write to the database and generate an email when clicking submit.  But the problem I'm facing is that the recipients of the email need the opportunity to input information, which needs to also be written to the database and another email needs to be generated.  It's an ongoing process.  

I need to continually write to the same record in the database and ensure that an email is generated everytime the record is updated.
0
 
LVL 11

Accepted Solution

by:
Dany Balian earned 500 total points
Comment Utility
well the way you would do it, is u post to the same page all over again... here's a short example:

page.asp:
<%
dim t1
t1=request.form("t1")
if request.form("sending")="true" then%>
'send the email here... and update the database
'then below, load the form (but filled with the posted data) if any!
end if
%>
<html><head></head><body>
<form action="page.asp" method="post">
<input type="hidden" name="sending" value="true">
<input type="text" name="t1" value="<%=t1%>">
<input type="submit" value="Save">
</body></html>

something like this, if u need further clarifications, let me know!!

cheers, dan
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now