Search results

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

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

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

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

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

Trying to analyse different sets of data in a normal distribution way. Want to show the result in an Excel sheet. (more sets per excel sheet) However I want to deliver the data + the set Bell curve for that data to excel so that I can draw an XY scatter chart showing the "set value" Bell curve...

Can any body point me in the right direction? I'm completely out of ideas.:( I import an excel sheet with the following command DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "data", root & "tmp_Query_Output.xls", True Works fine but for one issue. I have 6 dates with time in...

Hi, ever run into this problem/challenge? I create some tables in Access, all kind of good calculations etc. Then I link the outcome tables in an excel sheet over differnt pages in differnt pivot tables. From the program I give a refresh as follows. Where I supply the exact location of the...

Can any body lead me in the right direction or pref. show me an existing thread or program code. I need to change a tick list to a 2 column file as below Tick list has the following fields. name-A-B-C-X-F-G JanZ 1 0 1 0 0 0 JanB 0 1 0 1 0 0 Etc DB 2 has to look as follows name-fields...

I'm trying to update a form using the eval function in a program. However there is a part that I can't get to work It will not change the back ground color to white. I use the eval function since I will do this many times and the form automatically add textboxes when more data is available...

I face the following frustrating problem:mad: I made a small program using VBA in access to structure some internet information that I want people to look at and distributed it to differnt (80) people to play with. Now there are about 10 people that get constant error messages. stating that the...

I managed to send Emails from my Access Db using Lotus notes as Email program including attachments etc. However now I would like to create LN "To do list" entries from my Access Db and send them as well still using Lotus notes. Can any body point me in the right direction? I can't find a VBA...

I converted my well working mdb in a mde and now ran into a problem. The sign of for the user is over a view froms and can only be done once. I made this by setting a value in the first form As follows Private Sub Form_Load() 'INIT Dim db As Database Dim rSt As Recordset Dim sql As String...

I made a training database for my company on a memory stick. "plug and use." Since everybody has access 2003 I had no problem doing so. However it's now decided that we'll use the same set up for some of our customers. Meaning some people will have access but who knows what version of access...

Made (a cool:rolleyes:) database where I can simply switch from local html pages to online pages. The pages ref. is called from a table and works fine. The last option I want to put in is that I can also start a procedure from the same table So the procedure instruction that I put in the table...

Hi, I'm trying to fill a drawn matrix on a form. There 50 fields I have to set (text and color) since the amount of fields can change I want to make a program to set the fields. It's the same opperation all the time (just the field name is differnt) This is what I'm trying Dim a As Long Dim jan...