Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: techsupport3977
  • Content: Threads
  • Order by date
  1. techsupport3977

    creating variables from a table

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

    reading text files in Access

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

    ping computers, extracting data from text files

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

    using SQL to ping computers

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

    use access to ping computers

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

    controlling how users close forms

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

    Changing the size of the pop up window of a 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...
  8. techsupport3977

    which reference file needs to be installed for Access 97

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

    Browser sizing

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

    re-sizing charts

    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?
  11. techsupport3977

    Using Access to make decisions based on a text file

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

    Access to review contents of text files

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

    simple JOIN, huge table

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

    macro on startup

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

    Update Queries and modifying records in a table

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

    Making Control Buttons change color when a condition occurs

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

    environ() in RUNSQL command causing glitch

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

    can not load xml file

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

    check book application

    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?
  20. techsupport3977

    Lighthammer

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

Part and Inventory Search

Back
Top