I have a device connected and captured data strings from serial port. The device has its own application that display the data. I could also use hyperterminal to display the data as well. But I really need to capture and save the string data in a text file automatically, then close the text file. Th...

Hello Marcus!
Do you ever sleep?
Thanks greatly. This is a big help.

. . . . Call doc.REPLACEITEMVALUE("Subject", "Credit Notes for Month") Call doc.REPLACEITEMVALUE("Body", "See attached PDF file") sAttachment = "C:\attachereport.pdf" . . . . VBEND VBRun>SendNotesMail Hi, thanks for the tips. Wishfull thinking: How to use variable in sAttachment, and in Subject & B...

Wow! That [Date] did it. Much appreciated. Sorry for the late response. I decided to install 8.0.3 then logged off and logged back in as a client. msch would not compile, giving 'cannot compile due to incomplete installation'. I got to log back in as administrator to test. Thanks again for the great...

Thanks for the tip, Marcus, I tested 'INSERT INTO table_tblMain (Cell, ESN, FailCode, Description, Date) VALUES ('Cell2','46605485','Passed','Passed','20060512');' and I got 'Syntax error in INSERT INTO statement'. After clicking OK, Date is highlighted. The Date field is tex property, so I am not s...

Thanks Marcus,
I will check again and again. perhaps from scratch.
Since you are confident about the SQL syntax, then I can work on the table and input file.
Sincerely,

Hi, It was a typo error with respect to table def (Date, not Data). With 'MsgBox SQLString' added, when the script ran, it displayed: INSERT INTO table_tblMain (Cell, ESN, FailCode, Description, Date) VALUES ('Cell2','46605485','Passed','Passed','20060512'); the bottom of the message has an OK promp...

Marcus, need help, please ! ! ! Input table: Cell2,46605485,Passed,Passed,20060512 Cell2,46605070, 731, EPS #2 MECHANICAL MISALIGNMENT BETWEEN CAMSHAFT AN,20060518 Cell2,46605069, NONE, NONE,20060510 Database, tblMain: ID - AutoNumber Cell - Text ESN - Text FailCode - Text Description - Text Data - ...

I got it! LOL

Mov>file_names_%k%,d:\FaultCodes\WithFault\
Goto>Done
Label>jump
Let>i=i+1
Goto>start
Label>DoneFileRead
Mov>file_names_%k%,d:\FaultCodes\NoFault\
Label>Done
End>FileRead

Thanks

Let>APP_TITLE=Evaluate ECM Codes Let>RP_WAIT=1 IfDirExists>d:\FaultCodes,CREFault Cre>d:\FaultCodes Label>CREFault IfDirExists>d:\FaultCodes\Result,CREResult Cre>d:\FaultCodes\Result Label>CREResult IfDirExists>d:\FaultCodes\Input,CREInput Cre>d:\FaultCodes\Input Label>CREInput IfDirExists>d:\Fault...

That looks good, lol.
Thanks, I get started with that.
Cheers

Hi again, I got to come up with a solution for tomorrow, and still not able to figure it out. The task is to read all files (lot of) in a folder, and select files that meet a criteria. Files have many lines. Lines are coma delimited. Both files and lines have different length. Example: xxxx,xxxx,xxx...

Marcus, Yes, yes, yes, yes, yes . . . . . . yes! Most clear and defined. I tried the 'upload' and it worked just as expected. I can build my app from here, I think, and with the better way. I most rather use msScheduler to do the task than to use Access queries in command line, because msScheduler i...

Thanks Marcus, I am reading the instructions now.
Also thanks for reminding me about using append queries in Access.
Hope that by the end of the day, I'll could get my way out.

I tried the link, but dont know what I should look for in that link. Anyway, this topic is the one I've been looking for the answer for sometimes. And now, it is most urgent. SkunkWorks, have you get your script done yet? Assuming that I have a text file, with coma delimeters, as follows: FirstName,...