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!

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

Recent content by jurgen

  1. jurgen

    Send As public folder permission issue

    Hi, I'm trying to figure out what's wrong with the send as right in exchange on a public folder. If I add a user directly into the directory rights and give the user send as permissions, the user can send in name of the public folder. But If (for maintenance reasons) I create a security...
  2. jurgen

    Select & Copy from Datagrid and paste in Excel

    I'm using the default datagrid in winforms. How can I use the copy functionality, when i want different columns and rows to select them, copy them and then paste the content in excel (or word) How can I do this in C#. Thnx !
  3. jurgen

    in memory recordset

    Thnkx works like a charme
  4. jurgen

    in memory recordset

    Can someone give me an example on how i can build a ADO recordset in memory based on a data in a database. I'm trying to read the data into a ADO recordset, put it in memory, disconnect with the database and then using the data in memory through my application without having to go each time to...
  5. jurgen

    Return current Excel row to Access

    Hi, I'm looking for the solution to return rows in access. Can you give some information on how to
  6. jurgen

    Access -> Excel -> Access automation

    Hi, I'm looking for some info about automation access to excel and the changes in excel back into access ... What i'm trying to accomplish is that i create a query with all the data i need that's available in the access application (data is on oracle), export it to excel, the user manipulates...
  7. jurgen

    Create Pivot Table & Export to Excel in VBA

    Hi, This is the way i go .... Dim pPeriod As Date Dim qdf As DAO.QueryDef Dim strSQL As String Dim FileName As String pPeriod = CDate("01/" & Me.cmbMonth & "/" & Me.cmbYear) Set dbs = CurrentDb strSQL = "TRANSFORM statement ... " Set qdf = dbs.CreateQueryDef("TempQry"...
  8. jurgen

    Form Recordset

    Yep, tried it but same result, i'm using Access 2000, i would like tot use 2002/2003 then it worked, but migration is no option here ...
  9. jurgen

    Form Recordset

    That's what I've in my code and works fine, but i m not seeing any records on my form Set me.recordset = rs works fine. The thing i'm trying to find out how can i display this recordset on a form ... Hope you can bare with me ...
  10. jurgen

    Form Recordset

    This code works fine. The item you recall is to add parameters to the call of the storedprocedure on oracle. SO has nothing to do with the problem. THe result of this code is a recordset: rst .This recordset contains all data that has to be displayed on the form ... Jurgen
  11. jurgen

    Form Recordset

    I'm going to try it but for the record, the query is in fact a stored procedure on oracle that i call and receive a cursor back that i put into a recordset. And that recordset is the result i want to show on a form in a datasheet Here's the code i use for the stored procedure tot put it into a...
  12. jurgen

    Form Recordset

    That's what the result should be, i've tried the listview but it's not the way to go unfortunally.
  13. jurgen

    Form Recordset

    Yes that's it.
  14. jurgen

    Form Recordset

    Hi, Tried this one but it doesn't work because of the fact that i've always different fieldnames, because i want to make the form as a datasheet displaying the content, so in content 1 there is a firstname but the content 2 hasn't. Any other ideas

Part and Inventory Search

Back
Top