Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

...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 hLogFile As Integer Dim Temp As String hLogFile = FreeFile Temp = "c:\" + model + mdy +...

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

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

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

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

Thank you, you have been very helpful! Jon