Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ammodog6942

    MS Access 2007 Attachment Field

    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, ...
  2. ammodog6942

    combine PK with Table Records and Insert into other table

    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.
  3. ammodog6942

    combine PK with Table Records and Insert into other table

    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.
  4. ammodog6942

    combine PK with Table Records and Insert into other table

    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...
  5. ammodog6942

    How to replace a query from one DB to another

    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...
  6. ammodog6942

    Batch Insert from a detail page (asp)

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

    Batch Insert from a detail page (asp)

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

Part and Inventory Search

Back
Top