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 Chriss Miller 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: *

  1. jsaliers

    Delete Multiple Records with Same ID

    Worked like a champ. Thanks very much for such prompt help!!! Jon
  2. jsaliers

    Delete Multiple Records with Same ID

    That sounds bad, doesn't it? I have a database with a table named Transactions. This table contains records containing transaction information. For example, some records might be: ID type amount 3456 A 25 1864 A 35 3456 B 10 3456 C 20...
  3. jsaliers

    Get Statement to Input from Binary File

    The cr was actually something defined globally to be a carriage return ( Chr(10) and Chr(13) ). I ended up using Line Input. Sorry for the non-clarity on the cr. Jon
  4. jsaliers

    Get Statement to Input from Binary File

    It was not my choice to use binary output. I had inherited the application from another engineer that had half-completed it, and had no time to work on it, so they left it to me to finish. Not my choice by any means. At any rate, the project has been completed, and I am no longer associated...
  5. jsaliers

    Formula to Detect 3rd Shift Change

    I am writing a datalog program that tracks counts on a test stand. At each shift or model change, the program should append the counts file to a historical file, then zero the counts and overwrite the existing current file. I can detect when the model changes, or when the shift number changes...
  6. jsaliers

    Fill Down a Pattern

    Thank you much. Works wonderful! Happy Holidays!! Jon
  7. jsaliers

    Fill Down a Pattern

    Got a dumb question. I have a spreadsheet filled with data, and I have a column I need to fill down with three values. 120 215 40 I want to be able to fill down so that these three values repeat. However, when I fill down, I get: 120 215 40 45 5 -35 -75 ... There are so many cells to fill...
  8. jsaliers

    Excess Characters Put to File (Date Format)

    Alright, I have solved a few of my problems. I have gotten rid of the excess characters at the beginning of my date line, and have formatted the date correctly. In addition, I have read in the date line. However, I am still not reading in the shift and model, and I am pretty sure that I know...
  9. jsaliers

    Excess Characters Put to File (Date Format)

    Maybe I am going about this wrong. Let me provide some background. I am collecting data serially from a test stand, and printing the counts to file. Each time results come in for a part, the file is read in, to verify that date, shift, or part model has not changed. If it has not, then it...
  10. jsaliers

    Excess Characters Put to File (Date Format)

    I am having a stupid problem, and I don't quite know why. I am tryin to write data to a file, and read it back later. The problem is that when I write the formatted date, it prints extra characters to the front of the string, that screw up reading the lines back in. The characters are...
  11. jsaliers

    UPDATE Query with ReplicationID's

    Well... here goes... tblDrawings drawingID (AutoNumber, length=RepID) partNumber (text) relDrawingComponents partNumber (text) componentPartNumber (text) componentCount (Number) The database is just a regular Access 2000 database. Any ideas? Jon
  12. jsaliers

    UPDATE Query with ReplicationID's

    I am not good with SQL, so I am pretty well stuck. This is what I have: tblDrawings: drawingID - serves as unique identifier (Replication ID) partNumber - actual part number misc fields that aren't important relDrawingComponents: partNumber componentPartNumber componentCount I...
  13. jsaliers

    Excel from VB, formatting cells

    Try this: .Range("E1:E5").NumberFormat = "$#,##0.00" Hope this helps you! Jon
  14. jsaliers

    Get Statement to Input from Binary File

    Maybe I have been making this too difficult on myself??? Is it possible that each line is a record, if not otherwise specified when put to the file? If this is the case, could I not do something like: For i=1 to LineNum get hLogFile, i, tempVar Next i Anyone have any ideas/experience...
  15. jsaliers

    Get Statement to Input from Binary File

    I have been stuck with a program that needs to read in (line by line, so as to match strings) a binary file created using the Put Statement. The person who began the program did not write to the log files using record numbers. They simply did the following: ***CODE*** Dim cr As String Dim...
  16. jsaliers

    Excel Macro?

    Yeah, my fault. ShowSave is a CommonDialog method. That is, you have to have CommonDialog controls. Then you would have the following line of code: CommonDialog1.ShowSave Sorry about the confusion. Jon
  17. jsaliers

    Excel Macro?

    This is how it should look: Sub Macro3() ' ' Macro3 Macro ' Macro recorded 12/11/2003 by CRHamilton ' ' Keyboard Shortcut: Ctrl+z ' ActiveWorkbook.ShowSave End Sub Hope this helps! Jon
  18. jsaliers

    Excel Macro?

    Use the ShowSave Command. object.ShowSave This should open the SaveAs dialog box. Hope this helps! Jon
  19. jsaliers

    Calling a Macro From a Cell

    Got a quick question for you about this again. The excel sheet is being updated using DDE. Depending on the state of a PLC, the target cell(A2) will either be a 0 or a 1. However, the user will not be keying the change. When the change is made using DDE, will this trigger the...
  20. jsaliers

    Stopping Background Processes -> E-Stop Button

    Thank you, you have been very helpful! Jon

Part and Inventory Search

Back
Top