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: *

  • Users: datras
  • Content: Threads
  • Order by date
  1. datras

    How to call a HTTP page when clicking a button?

    Hi I hope some one can help me with this small piece of code. I have a button on a ASP page and when the user click the button the code have to open another page. However, nothing happens when I click on the button. I have tested the hyperlink by creating a ordinary hyperlink to the page at...
  2. datras

    Test server name

    Do someone know how I test what SQL server I am connected to in vd.net? I am working on both a production server and a development server and the code will be slightly different depending on what SQL server the vb.net code is linked to. So I would like to be able to test the SQL server name or...
  3. datras

    Error: "Execution was cancelled by user" when running DTS

    I keep getting the error: “Execution was cancelled by user” when running my DTS package from VBA or VB. This has only been a problem on my PC and not on the person who use the application for import of data. Now she has got her PC upgraded and now she has the problem as well. The DTS package...
  4. datras

    problem with creating object when running DTS package from VB

    The import module to my SQL-server based database is developed as a DTS package and it is called from the ACCESS front-end with the following code: (my test in VB) Private Sub Command1_Click() Dim dtsChdPkg As DTS.Package2 'initialise child package Set dtsChdPkg = New Package2...
  5. datras

    Pivottables and web access

    I am creating a database for scientist from a number of countries. They have asked for web access with pivottables to the database. So fare I have created a data warehouse with cubes in SQL server analysis services 2000 and now I have tried to create a pivottable. I have just taken the web...
  6. datras

    Calling a dll from a DTS ActiveX Script

    Hi Out There I have tried to call a dll from a DTS ActiveX Script without any success. I have not been able to find an example on how to do it so this is my pure guess – and it is not good enough. Could anybody enlighten me please? DATRAS:-) The error is: Class not defined: fitALK ' Visual...
  7. datras

    Temporary table variable

    Hi We have tried to use Temporary table variable with a select statement in a stored procedure but not been able to make it work. Does anyone have a small example we can see, as the SQL help book is not providing any? :-)
  8. datras

    How to retrieve a recordset from a stored procedure using sp_executes

    I want to call my stored procedure at the SQL server from VB with a new table name each time and get a recordset back. My stored procedure look something like this: CREATE procedure upSU_CrossCheck @tbl nvarchar(10) as declare @sqlstring nvarchar(500) declare @paradef nvarchar(500) declare...
  9. datras

    How to retrieve a recordset from a stored procedure using sp_executes

    I want to call my stored procedure from VB with a new table name each time and get a recordset back. My stored procedure look something like this: CREATE procedure upSU_CrossCheck @tbl nvarchar(10) as declare @sqlstring nvarchar(500) declare @paradef nvarchar(500) declare @paratbl...
  10. datras

    Running Access 2000 runtime in windows95???

    Hi I have developed my database in Access 2000 (English) and at a NT platform and made a runtime version and an .exe file with the WinZip self-extractor. I have then tested the runtime version in Window 95 and Offices 97 (Danish) with no ACCESS. The installation went fine with both the Access...
  11. datras

    How to close Excel from Access using VBA?

    Hi All I have tried to use automation between Access and Excel for creating charts. It works all right until I close the Excel application. I close Excel with .quit as described in Help and Excel disappears from applications in the task manager, however, it continues to run under processes...
  12. datras

    How to close Excel from Access using VBA?

    Hi All I have tried to use automation between Access and Excel for creating charts. It works all right until I close the Excel application. I close Excel with .quit as described in Help and Excel disappears from applications in the task manager, however, it continues to run under processes...

Part and Inventory Search

Back
Top