Recent content by techsupport3977

I was wondering if it is possible to substitute folder / file locations with variables that do a lookup at a table. In the below code in bold red are C: and the text file (flux ). I have a table that contains roughly 30 records of IP addresses, host names and the file we are looking for. The...

How can I have the attached code read only the second line of the text file. This only seems to read the first line. Dim strTextFromFile As String Open "C:\Program Files\QM\QMD\flux.qma" For Input As #1 Line Input #1, strTextFromFile Close #1

I need to know if I am on the right path to extracting data from this code. I was guided to create the code below, but I am a novice poweruser that is eager to get this done. I need to ping a computer, write the text file and then open the text file, read the text file and insert the data into...

I have gotten this far with the data extraction. Private Sub Form_Open(Cancel As Integer) 'Ping a computer and save it to a text file Shell "cmd.exe /c ping XX.XX.XX.XX > c:\temp\ping\extruder_e.txt" 'Open the file for data extraction Dim myString As String Dim strArray() As String Open...

how do I read from a text file?

I would like to establish a list of computers that I currently have on my network. I then would like a view or a stored procedure to ping those computers every 'X' hours. I would the results of the ping to be logged into a table to show datetime stamp of when the ping occurred, which computer...

I would like to establish a list of computers that I currently have on my network. I then would like a query to ping those computers every 'X' hours. I would the results of the ping to be logged into a table to show datetime stamp of when the ping occurred, which computer and the results. The...

Like always Jeff, you make it simple for the power user!!

I do not have the northwind Db. Your code is a little advanced for me. Can you break it down in layman's terms and where should I place this function?

If I have two forms that pop up. One will float on top the other. If the user closes the form below it will cause an error. Without turning the 'close' feature on the form off, how can I make it so the user will have to close the top form first before closing the bottom form?

Would I be able to have the scroll bars turned on or off with something similar to this?

I have my form as a popup dialog so the user can not modify the window size. However, I need two different sizes to the window based on a simple 'IF' function. If Forms!fm_scrapControl!Shift1 > 0 Then ... Else... The 'Then' part should have a window size 1 (if this is possible) and the...

Is there a certain reference that needs to be installed when I am trying to do a 'DoCmd.RunSQL' on 'openform'. I have an Access 97 application that has this code and it works fine for me, but then I have some one else use it on their computer and it tells me that it doesn't understand...

I do not have this code in my javascript

I have a web page that when initiated it always opens a certain size. I looked at the coding and I am not sure where the sizing information is at. The problem I am seeing is the table that holds my javascript is larger than the browser screen, but not larger than my monitor size. How can I...