Recent content by BobK4UVT

Thank you very much, PHV! I'll give it a try and see how it works. I have several test cases in mind to be sure I can retrieve the info I need. Will let you know how it goes.....

I need to develop a function that will tell me what regional setting the PC is set to - and if possible the default date/time formats for that setting; i.e., English (United States) or German (Germany), etc. I expect it will require a system API call to do so. Can anyone suggest how I might...

Reinier, Works like a charm!! Recorded the macro first & tweake it a little. I notice the generated code from the macro does an awful lot of ActiveWindow.ScrollRow = xxx. I'm curious why, so I'll have to dig into the Excel API a bit more to understand what it is doing. At the end of my sub...

Wow!! That was a quick reply!! Thanks for the tip! I'll play with it and then let you know how it went. I had planned to record a macro in Excel & use that as a baseline. Bob

My client likes to have their "reports" exported as Excel spreadsheets. I do the analysis in Access and then export the table to Excel. The resulting spreadsheet needs to have some formatting done on it before the client receives it. Fairly simple stuff --- Things like centering and/or...

PS ..... will also get into Metalink & see what Ifind there.....

Mufasa, Well, it is primarily an HTML limitation. I'm just trying to find a clean way to do it without leaving extraneous form elements on the form to confuse the user. It's messy, but may be my only choice. Actually < 1% of the records in the current Access DB even use this feature. So I'm...

I am building a web-based app with 10g AS (via PL/SQL packages) and am trying to mimic the MS Access hyperlink datatype. Specifically, I need to implement a <input type="file"...> functionality on a web form and plop a followable hyperlink in that text box. Thus far I have not succeeded & the...

OOppsss ... sorry about that .... Clear RecSet is one of my functions too. Code be low .... Maybe not the best way, but it works OK if the recordset is not too large. I like to ensure all the old records are gone before I start doing AddNew. Hope this helps..... Code for function: Public...

Hi, Aqif, Thanks for your reply! Since my original post, I discovered that the code was failing to pick up over half of the links that were actually in my Favorites folder. Upon further tinkering, I finally arrived at a good solution. The key is the function GetURLFromShortcut() ---- that...

PH ------- That helped out great!!! Now I see the shortcut files as .url files. Now all I need to do is figure out how to follow the links best. The FollowHyperlink method opens the link in a window --- with 1500+ links, that could swamp me, so got to find a way to do that without a glut of...

Hmmmmmmmmm ....... upon further tinkering, it looks like maybe FileSearch doesn't recognize internet shortcuts. So how does one handle that?? Am I perhaps barking up the wrong tree?

PH --- sorry for omitting the code --- too sleepy I guess :=) Public Sub ScanFav() Dim Jdx As Long Dim NumFiles As Long Dim DirName As String Dim FullFileName As String DirName = "C:\Documents and Settings\Daniel R. Dorsey Jr\Favorites\" With...

I have a bunch of hyperlinks in the Favorites folder in C"\Documents and Settings\. Via VBA, I would like to scan thru all the links and have it shell out to the link to test it. If the link is no good (dead, broken, 404, etc.), I'd like to populate a table with the bad URLs. That way I can...

Clean install seems to have gone well. Did &quot;quick&quot; format on drive. OS install took just under an hour. It found all hardware except for sound card, but was able to get an XP driver for it from mfr web site. So far I really like XP!!! I think I'll really enjoy it & it will be good...