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 bkrike 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 MatsHulten

  1. MatsHulten

    Dell CPXJ screen resolution messed up...

    I connected my machine (a Dell CPXJ running Win2k Advanced Server) to a video cannon, and the resolution was automatically lowered to 640*480. I was forced to leave in a hurry, so instead of shutting windows down properly I killed it using the powerbutton. Now the resolution seems to be set...
  2. MatsHulten

    ADO Recordset...

    Not really familiar with the ado controls, but if I would venture a guess it would be that up to the point where you call the recordset property the underlying ADO-connection need not bee open. Check for a method that opens the ADO and executes your query before referencing the results of that...
  3. MatsHulten

    Dynamic query..?

    "select * from Table1 where Field1 = " & texbox1.text -Mats
  4. MatsHulten

    Can't seem to shake the CodeRed worm

    Thanks for the link, but I managed to solve the problem by myself. As far as I could determine Code red doesnt write any file at all. But instead holds the code in RAM. IIS pointed to defalt.asp the whole time, just as it should. Thanks for the assistanse and the advise. -Mats
  5. MatsHulten

    Can't seem to shake the CodeRed worm

    Hi Got a CodeRed infected NT4 server. I have applied the patch availeble from MS and restarted the system. Problem is that IIS only displays a page containing nothing but <HTML></HTML> I've checked IIS for what pages it should display and everything looks just fine there, and the files look...
  6. MatsHulten

    ADO AND LIKE

    Cutting and pasting the query to my Access gives a syntax error at the 'IS' statement. When I remove it (...TEXT LIKE '*H*'...) the query executes just fine. The fact that you don't get an error when you populate the recordset indicates that the query you run simply does not return any records...
  7. MatsHulten

    The specified provider was not found by ADO

    Sounds like you need to install the latest version of MDAC to this PC. Good Luck -Mats Hulten
  8. MatsHulten

    Index Error

    Don't know if this is it, but the index must be previously defined in the DB, either via ADOX or from within Access. If you are trying to referense a field that is not previosly defined as an index, this will give you a runtime error. Also, I noted you are using Test both as the field name, and...
  9. MatsHulten

    ADO Recordsets

    strQueryBoth = &quot;Select * From <Insert table name>&quot; -Mats
  10. MatsHulten

    ADO Recordsets

    Thats eazy! :) Dim oConnection as New ADODB.Connection Dim orsDebit as New ADODB.Recordset Dim orsCredit as New ADODB.Recordset Dim strQueryDebit as String Dim strQueryCredit as String oConnection.Open <Insert connectionstring to DB here> strQueryDebit = &quot;Select * From <Insert table...
  11. MatsHulten

    ADO Recordsets

    Not that I know of. Remember that a recordset is no more than a reference to a set of data in (usually) a database. You can duplicate the reference (the recordset) to the data, but you would still be left with no more than multiple references to the same data. (Wich is great if this is what you...
  12. MatsHulten

    Getting End of Current Month Date

    dateadd(&quot;d&quot;, -1, dateadd(&quot;m&quot;, 1, dateadd(&quot;d&quot;, -day(date)+1, date))) -Mats Hulten
  13. MatsHulten

    What's the best way...

    You could store each query in a separate file and then program a class that accesses and returns the query stored in the file, based on the file name. -Mats Hulten
  14. MatsHulten

    accessing a database

    Error 2147467259 (0x80004005) is the generic E_FAIL, it means that the underlying component did not have a specific error number for the condition encountered. As to the errors you are recieving, the code you posted looks fine to me, however I don't use the data enviroment very much, so it may...
  15. MatsHulten

    which event is always active???

    Without actually having a clue, I suspect this would depend on the software controlling the smartcard reader, and the OS. What you are looking for is that the smartcard reader detects a card and sends an event to the OS, witch in turn handles it. I suggest you try to get hold of a technical...
See more

Part and Inventory Search

Back
Top