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...
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...
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...
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...
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).
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...
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...
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...
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...
In the VBSCript code below (its a fully functional .hta code), I can't figure out how to use the arrow buttons on the form in the HTA to go from record to record without manually telling it. Right now, I have it figured for 3 records per each associate, but what if there are 20 records...I...
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...
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...
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...
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 =...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.