Recent content by janz

Hi Trying to establish the true download speed for a computer. I'm downloading a 1MB file measure the time to get a mom. speed indication. I'm playing with the program below Dim myURL As String myURL = "https://androidnetworktester.googlecode.com/files/1mb.txt" Dim WinHttpReq As Object Set...

For all people interested this comes pretty close. Function nw() strComputer = "." Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\CIMV2") Set colItems = objWMIService.ExecQuery( _ "SELECT * FROM Win32_PerfFormattedData_Tcpip_NetworkInterface", , 48) ASENT = 0...

Did do some research and believe it should be possible with a WMI function. Also found http://www.microsoft.com/en-us/download/confirmation.aspx?id=8572 to generate WMI code. However I'm lacking the knowledge to find what I need any body that can help me here?:rolleyes:

Hi PuddinPie, I don't think you will find any standard command or wizard to solve this. However with a small VBA function it wouldn't be too hard. Just open the table in that function sorted in DOB and skip through the db line by line creating a string of names if the DOB is the same. If it...

Hi All, I'm trying to monitor my internet line. I can now successfully ping the line (see threat (shell function)and get the milli seconds back in my VBA program and hence in my Db. now the next challenge is that I would like to know how busy the line is at the ping instance. I tried to find a...

Hi Galaxiom It's all working now. Really simple if you know how ;-) I use it as function in a timed program and store the values in a Db. Thanks for your help. I will open a new threat "Local area connection" with a follow up question. Please have a look at that if you can find the time. for...

Hi Galaxiom, Your absolutely correct this is what I need. The base of your (2 programs) seems to run fine. However I run into problems when I run into the "wscript.Echo" section. I never used this type of programming before. It keeps giving me an error 424 Object required. Could it be that I'm...

Hi there I got again a tricky one who can help? Any body an idea how I can get the ping time in ms from the ping command? I tried a=shell("ping 173.194.65.94",vbMaximizedFocus) (pinging the google site) Works very good however I need to know the ping time. So (being older and familiar with...

Found it the program now looks like this DoCmd.OpenQuery "changeboard query", acViewNormal, acEdit DoCmd.SelectObject acQuery, "CHANGEBOARD QUERY" DoCmd.RunCommand acCmdSelectAllRecords RunCommand acCmdCopy DoCmd.Close acQuery, "Changeboard query", acSaveNo Takes...

Hi, I'm trying to copy the outcome of a query to the clipboard. as follows DoCmd.OpenQuery "changeboard query", acViewNormal, acEdit DoCmd.SelectObject acQuery, "CHANGEBOARD QUERY" RunCommand acCmdCopy DoCmd.Close acQuery, "Changeboard query", acSaveNo It doesn't work because...

Thanks. RuralGuy that saved me a lot of headaches. Such a simple solution!

Hi, I created a function that compares 2 tables. If the data of 1 is not found in 2 (wrong spelling of a name) The functions asks for a check in Db 1 opens a form and allows the user to check the spelling in a smart way. So far all is good. However I first query for the mistakes and then one by...

Re: Lotus Notes to display send message minimized code OK maybe I did send a bid too much sloppy code for any body to answer. I deleted all the fluff and here is the basic code. Any body an idea on how to "show" this message in LN instead of sending it. Even good suggestions are welcome...

Hi years ago I found some code, on this super forum, that I have adapted to my needs and are using in some applications. However in my new application I do not want to send the message right away but first display it, for the user to change, if needed. I looked all over the forum to find a...

Did you consider something like "http://www.autohotkey.com/" to create a macro to run the download. You can then start the macro using VBA as soon as your program would open. You could probably also make a macro to open your bank's website but that is all trial and error good luck.