Search results for query: *

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

I have a chart in MS Access XP that is set to a certain size. I would like to be able to leave the size of the chart up to the end user. The window box can be modified by the user, but can the chart be modified so the chart and the data gets bigger or smaller?

I have a bunch of computers that have a data acquisition program and the program uses a file (.qma this is a text file format) to determine whether or not data records need to be submitted to a database. At the top of the file shows the KEY field. Below the key field, it will be blank (all...

I think I would rather prefer this method. Can you help on showing if the file is present and larger than one line of data? I then need to report this in a table.

I have tested your msgbox function and it works fine. I have placed this on form_open. I am not understanding how to create the query to interact with this function. How can I make the function update the table if I do not know how to apply the function in the query? **** Public Function...

Can you give me a sample subroutine on how to do this?