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

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?

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 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 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 have a huge table that has thousands of records. I only need to look at 3 fields from the table. I have another table that has 100 records with 1 field I need. I have a JOIN between the two tables with the field that has the same data. It is a standard JOIN that I have used in hundreds of...

I need to execute a macro everytime the mdb application opens. What function can I call to make this happen?

I have a query that has fields qProduct, qSize, and qAmount. I have a table that has fields tProduct, tSize, and tAmount. The query will crank and depending on the situation will produce different numbers in the size and amount field, but the product will stay the same. I need to update the...

I have a control button that shows information only when something occurs. This is almost like having a task and all of the sudden it is over due. I want the control button's label to flash a certain color. I have a query that either returns data (when task is overdue) or returns no data...

Most of my forms use the below RUNSQL command to log what data they are viewing in order for me to serve them better. My concern is the "environ('username')". About 1% of the log table show the user name as blank whne the user has a domain account and is currently logged in the domain. What...

I have an IPAQ pocket pc I am trying to install. I place the CD in the drive and when it loads up it says 'unable to load xml file.' I am prompted to click OK and then I get a scripting error. I am then unable to continue installing the companion CD from Hewlett Packard. What settings on XP...

Is there an easy way to create an Access application into a checkbook for record keeping? Or does anyone have a sample application that already does this?

We are a company that is thinking about using Lighthammer to pull all aspects of data collection into an easy web service to report. We use SAP, CIM, MS Access, SQL, ORACLE, XRF systems, OEE's, OEM systems, Maint PM's, etc... We need the most minimal programming system to create these reports...