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

    Executing a SQL Stored Procedure from MS Access

    Yes I want to update (replace) a table in Access from the data retrieved from the stored procedure.
  2. johnve

    Executing a SQL Stored Procedure from MS Access

    Thanks dhookom, I'm still learning but would I replace the "SELECT statement" with "EXEC sp_FinanceExecData1" strSQL = "SELECT field1, field2, field3 FROM tblMyTable " & _ "WHERE OrderDate BETWEEN #" & Me.txtStart & "# AND #" & _ Me.txtEnd & "# " & _ "ORDER BY field2, field1 DESC" Thanks John
  3. johnve

    Executing a SQL Stored Procedure from MS Access

    Hi, I have created a stored procedure in SQL Server and now I want to update a table within Access using the Stored Procedure. I have searching the web and found this but I get a 3065 runtime error. Dim qdef As DAO.QueryDef Set qdef = CurrentDb.CreateQueryDef("") qdef.Connect =...
  4. johnve

    Run-time error '3065' Cannot execute a select query.

    Hi All, Thank you for your posts. After reviewing the code again I noticed I missed the "e" against a table alias. Thank you again
  5. johnve

    Run-time error '3065' Cannot execute a select query.

    Hi PHV, Thank you but now I get Run-time error 3061 "Too few parameters. Expecting 1. Set rs = db.OpenRecordset(sqlstring, dbOpenSnapshot) Thanks John
  6. johnve

    Run-time error '3065' Cannot execute a select query.

    Hi, I have written lots of the queries but I'm struggling with this one. I get the run-time error 3065 when I run the following sql. Dim db As DAO.Database Dim sqlstring As String Set db = DBEngine(0).Databases(0) sqlstring = "SELECT ebk.hr_leav_amnt AS hr_clia_hour, ebk.hr_leav_type...
  7. johnve

    Passing Variables through Frames

    I have a webpage with two frames. Top frame has list box which stores a variable Bottom frame has a report from which it uses a variable in the topframe. I have search the net but cannot get it working. Can anyone help.
  8. johnve

    Create a SUM Ytd and ThisPeriod Column

    Hi I'm trying to create a This Period and Year to Date fields. Current Table has: Item, Amount, Period (month of transaction), RPeriod (Current Month) What I want to do is have the following fields: This Period: Sum of Amount where Period = RPeriod YTD: Sum of Amount where Period >= 1 and <=...
  9. johnve

    Retrive Last 3 Actions by Project

    dhookom, Thank you very much for your assistance.
  10. johnve

    Retrive Last 3 Actions by Project

    Hi , I have a database where in one table I have a list of my projects and in the second table I a list of actions which are linked to the project. I want to run a query then report on the last 3 actions for each project. I have tried SELECT TOP 3 but it only gives my top 3 in that table not...

Part and Inventory Search

Back
Top