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 Rhinorhino 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. Lokoono

    Need help - Excel Automation - Find Non Date Cell & Delete Entire Row

    lameid - In regards to your last post, the timing of my followup to my own question was typed up before I read your original answer. Your first answer did help in some aspects of what I need to do. I'm sorry if I implied that I was confused about how to automate Excel through Access. I do...
  2. Lokoono

    Need help - Excel Automation - Find Non Date Cell & Delete Entire Row

    kjv1611 - Your code worked perfectly. I don't know why I didn't try something similar (my brain shuts down on Friday apparently). The ScreenUpdating piece isn't required in normal function (where Excel wouldn't be visible when this code runs), but it does come in handy for testing purposes...
  3. Lokoono

    Need help - Excel Automation - Find Non Date Cell & Delete Entire Row

    Addition to my question above: I meant to also say that I can't save the spreadsheet with the macro inside it. It's not my spreadsheet to change. I could save it as a new sheet and use a .bas file to run the code, but there's no guarantee that the date column will always be Column A, so I...
  4. Lokoono

    Need help - Excel Automation - Find Non Date Cell & Delete Entire Row

    Hi all, I can get the code below to work as an Excel Macro, but I'm at a loss with trying to do the same from Access VBA by using Excel automation (it's part of an import procedure I'm working on). Can anyone help? I'd like to just use Access VBA and don't want to use any external files (such...
  5. Lokoono

    Need help printing HTML files from database

    Perfecto HarleyQuinn. Worked like a charm. Thanks! And thanks big time for looking through Experts-Exchange. I had to trim my budget earlier this year, so I wasn't able to look there (and last I checked, my company isn't one of the 900+ that's a member of it).
  6. Lokoono

    Need help printing HTML files from database

    I'm using the following line in my Access form, behind a command button, to open a web page in Internet Explorer (the page is located on a local server). dRetVal = Shell("C:\Program Files\Internet Explorer\iexplore.exe " & "\\server\file_to_print.htm", 1) Opening the file is fine, but telling...
  7. Lokoono

    .VBS equivalent of a .HTA countdown timer

    Actually, nevermind my question. I found a good workaround. I don't know how many resources having a continual looping script would use anyway, so I guess this new way is safer. What I did was create a custom HTA dialog box (that looks like a fancy message box) and have it called up via the...
  8. Lokoono

    .VBS equivalent of a .HTA countdown timer

    Hi PHV, thanks for the response. I did originally look at WScript.Sleep, but didn't think that worked for looping. I haven't gotten it to work. I've seen examples elsewhere on the net, but WScript.Sleep doesn't seem to do anything with the code I used. Below is the code I had typed for my...
  9. Lokoono

    .VBS equivalent of a .HTA countdown timer

    I'm trying to create an equivalent of a HTA timer I found some months back. I've revised the code below to fit my needs with HTA (though the 10 seconds part is only to show that it works in a quick fashion). Here's my question: Is it possible to get a .vbs equivalent? I don't need a GUI (so...
  10. Lokoono

    Can I dynamically navigate my recordset in VBScript?

    ...' Connect to the database strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='c:\Lists.mdb'" conn.Open strConnect StrSQL = "SELECT * from [tblLists] WHERE EmployeeID = " & document.getElementById("IDNum").value Set rs = conn.Execute(StrSQL) StrSQL2 = "SELECT Count(*) FROM...
  11. Lokoono

    Count number of rows in table that start with a certain letter

    Hmmm, good question. There's something I forgot to mention at the beginning. The table isn't the only table or listbox in the document. This table is part of a larger data entry form that I'm designing for my office's intranet (the rest of the form I've had no problem with since its in...
  12. Lokoono

    Count number of rows in table that start with a certain letter

    Hi feherke, Your code works in getting to the next letter. Thanks very much for that. I'm going to see if I can tweak it because if, for instance, I hit the "S" key and it scrolls through all the "S" names, it will cause the table to lose focus and it won't go back to the start of where the...
  13. Lokoono

    Count number of rows in table that start with a certain letter

    I'm almost done with my quest to make a simulated Access listbox in hta by using javascript and a table. The code below works to have the table scroll to and highlight the first row where that letter shows up. In other words, if there's "Sam" and "Susan" in the column, it will always go to...
  14. Lokoono

    Go to a particular row in an html table based on the letter typed

    Okay, I think I lucked out (with feherke and Dan's help of course).... I changed: for (var i=0,l=t.rows.length;i<l;i++) { to for (var i=1,l=t.rows.length;i<l;i++) { And then with this line, I added two lines underneath: t.rows[i].scrollIntoView() t.rows[i].style.backgroundColor =...
  15. Lokoono

    Go to a particular row in an html table based on the letter typed

    Hi Dan, Thanks for the response. #1. The innerHTML line was mispelled, but wasn't the solution to the problem #2. The alert(t) code did return an object (it would've been null otherwise I'm guessing) #3. The alert(t.rows.length) returned the number 43 (which is the number of rows in my...
  16. Lokoono

    Go to a particular row in an html table based on the letter typed

    Feherke, I'm not trying to get you to do all the work for me here and I'm sorry if it's turning out to be that way. My area of expertise is VB Script and not Javascript. I couldn't find anything on how to do a scrollIntoView type of routine for VB Script, so I tried Javascript. I'll give...
  17. Lokoono

    Go to a particular row in an html table based on the letter typed

    Thanks for the tips Feherke Although I'm now able to trap A through Z when those keys are pressed when the table has focus, I can't get the scrollIntoView feature to work. I've been trying for the last few hours to get it to work, but I've had no luck. I've found an example that works if my...
  18. Lokoono

    Go to a particular row in an html table based on the letter typed

    Below is the code I have which simulates an Access list box by using Javascript and "faking" the listbox by using an html table instead. My Questions: Is there a way I can further simulate the Access listbox feature by having the html table scroll to a cell (the first cell, which is the name...
  19. Lokoono

    Javascript function

    Could be one of the issues to the latest builds to the web browsers. I know they're doing a lot of changes that affect web developers (IE7 for example has several builds and each one seems to change some rule that affects HTML/Javascript coding). I wish I could tell you for sure what was going...
  20. Lokoono

    Javascript function

    Change your form name to something other than signup and it should work. I'm no pro at Javascript, but I think its because you're declaring both the form name and your function name with the same "signup" declaration. I took your code, changed the form name, and it worked for me (I got a...

Part and Inventory Search

Back
Top