Right now I am using this to send an email from a form:
Private Sub Command76_Click()
Dim strToWhom As String
Dim strMsgBody As String
Dim strSubject As String
strSubject = Me.Title
strToWhom = "Email Address"
strMsgBody = Me.Commentary
DoCmd.SendObject , , , strToWhom, strToCCWhom, ...
Ok I have created my stored procedure and tested it. It does exactly what I need it to do. So I guess all I need to know now is how on my page where I have the query string value (permitid) pass that value as the parameter and run the stored procedure. Thanks Again.
I am using SQL2005.. I am still learning it as well as asp.net. I have seen people talk about using stored procedures but still haven't grasp the concept of setting one up and calling it from the aspx page.
I have it where a user inserts a record. Then the page gets redirected and passes the newly created PK to the new page as a query string. What I want to do is take that newly created PK and combine it with a list of default records from a table and insert that string into a different table...
Can anyone help me, I would like to open a db that has the code or macro to run on start up. I would like to have this code delete a query on C:\Program Files\database1\database.mdb and insert a query from C:\Program Files\database2\database.mdb into C:\Program Files\database1\database.mdb. In...
Here is the code of what I have so far as you can see i get the info from a query based on which department user is logged in by their department ID.
<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="Connections/time.asp" -->
<%
Dim rsemployeelist__MMColParam
rsemployeelist__MMColParam = "1"
If...
I am trying to do a batch insert from a detail page. I have a department table, employee table, and a employee financial table. On the detail page I can bring over the employeeid, departmentid, and the financialid and populate the page with all employees and their different accounts:
Example...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.