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 Mike Lewis 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. dotolee

    converting a string to date

    can you give me an example of what you mean when you say to include the function in the list of columns? do you mean something like: objRS.Open "SELECT DISTINCT TOP 5 SearchText, SearchType, Convert([SearchDateTime]) FROM " & logfileName & " WHERE USERNAME='" & Session("username") & "' AND...
  2. dotolee

    converting a string to date

    i have records that i need to select for a specific user by date. The problem is that the date field is actually just a text field. here's my code so far: set objCnn = Server.CreateObject("ADODB.Connection") set objRS = Server.CreateObject("ADODB.Recordset") set last5RS =...
  3. dotolee

    how to refresh main page and the contents of a iframe in one shot.

    chris, i tried removing them. but that didn't resolve my problem. I also tried using the ID that gets passed in to the tabOnClick function as the iframe ID name... (a value from 0-4 because I actually have 5 tabs) but that didn't work either. function tabOnClick(ID){ var oElement = null...
  4. dotolee

    how to refresh main page and the contents of a iframe in one shot.

    Also tried contentWindow instead of contentLocation...because I'm using IE8. document.getElementById("divTabFrame").contentWindow.location.reload(true); still doesn't work. same error message
  5. dotolee

    how to refresh main page and the contents of a iframe in one shot.

    One additional comment: I also tried doing the reload after i do the document body focus call - see below: document.body.focus(); document.getElementById("Tab 1 Title").contentDocument.location.reload(true); But that didn't work. And then I also tried reloading the DIV instead of the...
  6. dotolee

    how to refresh main page and the contents of a iframe in one shot.

    Chris, thanks for your reply. last night, i found some similar code elsewhere and tried it but i'm getting error about object not found when i run my code. My code isn't too complex, but not straightforward either where the IFRAME is concerned. I have a div wrapped around the iframe as...
  7. dotolee

    how to refresh main page and the contents of a iframe in one shot.

    hi there. i have an asp page that is using the winhttprequest object to get the contents of an "external" website (just a page from another department here.. but a different server). Then i modify the html i get to suit my needs.. save it to a file, and then finally, i display this stuff in an...
  8. dotolee

    how to create a report with links to more detail

    i have a table that has a lot of fields on it. the user would like to be able to run a report by date. the initial results will show just a few fields... and then if the user clicks on a record, they want me to display another report with more info on it. i'm not quite sure how to do this...
  9. dotolee

    built in search function not working properly

    hi there. i've created a little button on my form that launches the default find/replace dialogue box in access. i've noticed some odd behavior (ms access version 2000). sometimes, when i search for a word, it highlights the entire sentence instead of just the word that it found. and then...
  10. dotolee

    tab order not saving

    hi there. i have a tab control with 2 tabs. on the second tab, i have 15 different textboxes & buttons. i've tried to set up the tab order by changing the tab index on my controls... but it keeps changing. i've tried to change all the 'tab stop' settings to NO first. and then one by one...
  11. dotolee

    find button no longer working

    hi there. i have a button that calls a macro. this macro uses the runcommand to execute a "find". but when i click on this button, i'm now getting the message that the control the macros is attempting to search can't be searched. how do i include all fields on the form in the find command...
  12. dotolee

    using msxml2.serverxmlhttp to get list data from sharepoint

    i had an on error resume next statement at the top. after removing it, now i'm getting the error "msxml3.dll error: a connection with the server could not be established" This happens on the .send method
  13. dotolee

    using msxml2.serverxmlhttp to get list data from sharepoint

    hi there. i have a list on our sharepoint website that my ASP web app needs access to. I am trying to use msxml2.serverXMLhttp to get the contents of the page. i'm getting the following error message: err.number = -2147483638 err.description = the necessary data to complete this operation is...
  14. dotolee

    selecting top 5 searches

    hi there. i'm trying to write some sql code that will search for the top 5 most frequently appearing items in a log file. The field I'm looking for is the top 5 "searchText" values. Right now, my code looks like this: set objCnn = Server.CreateObject("ADODB.Connection") objCnn.Open...
  15. dotolee

    vbs file - using adodb rs to read a csv file

    btw i've checked both the good and bad csv files to compare white space, newlines, tabs etc and i cannot see anything wrong with the "bad" file. thanks.
  16. dotolee

    vbs file - using adodb rs to read a csv file

    i have a vbs file where i'm trying to read in a csv file. my code (in part) looks like: set cnn = server.createobject("adodb.connection") set rs = server.createobject("adodb.recordset") cnn.open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & csvfilepath & "Extended...
  17. dotolee

    iterating through unknown number of subdirectories

    thanks, i'll give this a try.
  18. dotolee

    iterating through unknown number of subdirectories

    i did find this article, which i'm planning on trying out. if you have any comments about it, i'd be interested. thanks. http://www.devx.com/getHelpOn/10MinuteSolution/20406/1763
  19. dotolee

    iterating through unknown number of subdirectories

    hi there. i have to write some script that will accept a path and then search through that path and all subdirectories for specific file types. So far, to test my logic, I just assumed that we'll only have 2 levels of subdirectories. the pseudocode looks like: set fso = file system object...
  20. dotolee

    javascript to automatically open the IE 7 favorites on page launch

    the client feels that this would be an ideal solution because it would lessen the learning curve for their end users. (and therefore gain more acceptance overall) they prefer this option over us creating them a custom menu. ?? i've never seen this done myself. but i have to ask because that's...

Part and Inventory Search

Back
Top