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 Chriss Miller 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. 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...
  16. MatsHulten

    accessing a database

    Sounds to me like you have the path to the DB in a string, like this: connection.open &quot;C: & Path & Name&quot; To correct a mistake like this all you would have to do is this: connection.open &quot;C:&quot; & Path & Name This may not at all be whats wrong, but it would be consistent with...
  17. MatsHulten

    How do u extract a specific column from an excel worksheet??

    It was a hipshot, I admit. Still check out the ADO connection to excel thread in VB - Databases forum, it may give you something to start with. Good Luck -Mats Hulten
  18. MatsHulten

    Long SQL transactions in ADO client app not comitting fully.

    Then I suggest you migrate a sample object to transaction server. The transaction handling there should be superior to that of the ADO built in. -Mats
  19. MatsHulten

    How do u extract a specific column from an excel worksheet??

    Try something like this: Select A1:B8 From... Select A* From... Select [DefinedArea$] From... Haven't tried it though... Good Luck! -Mats Hulten
  20. MatsHulten

    How do I determine what field I am

    Jumping right in... If I understand you correctly you want to return the field index for the current field as in: oRs.Fields(x)... where 'x' would be your index. As far as I know there is no way of returning the index variable directly from the field object. If you truly need an integer index...

Part and Inventory Search

Back
Top