Recent content by chieh

Hi Paul: Thanks for your feedback. Your suggestion of setting up the column heading in Excel first, would be the better solution. I guess I went overboat in trying to making it over genetic. Regards Chieh

Hi Skip: Yes, at this point I am using the .Name property, i.e. oDoc.FormFields(i).Name I may have to stick with this instead. Unless someone have any other methods or ideas. Regards, Chieh

Thanks Skip, I did use the watch window during debug mode and look through almost all word doc object, still no luck. Maybe some object or feature are simply not available. Reards, Chieh

Hi Paul: I agreed, it is confusing, my apology as a newbie in VBA, I guess I didn't quite explain it very well. Here's more detail explaination and example... Let say I have 5 word forms. Each form has the following: test1.doc First Name [Chieh ] Last Name [zh ] Address [ 123 anywhere...

Hi Paul: I got the program working using Excel VBA (I paste the full program code at the end), the info I try to get is the title or label that's on top or beside each textbox field. For Example, in my word form, there are following field: First Name [Chieh ], Last name [Zh ], Address [123...

Hi Andy: No, there is no .Caption property or method, I tried to look through whole word object and still couldn't find it. Regards, Chieh

Hi All: I have multiple word fillable form, I need to retrive all the value filled in by the user on each form and insert the value into Excel sheet row by row, each row represents 1 file. I got the program working using Excel VBA, however I try many ways to get the title or label that's on...

Hi Tamar: I tried the query, it combines the data into one table, if you run my program and see the C_report, it lays out the result of Feb vs Mar in a side-by-side manner, instead of combining them together, Is this still possible to do using SQL only? You need to run the fox program to see...

Thank you Tamar, I will give this a try in T-SQL to see if I can get the same result. Regards, Ch

Hi All: I am working with Visual FoxPro, and I create this Program to compare data between two given month, where some account may or may not be available between the month, the end result will be a report with rows showing data in 2 month side-by-side, if not available, it wil show N/A on the...

HI PH and Andy: Here's my code in Visual FoxPro and the Access code I did so far....: =========== FoxPro Code ============ * CompTest.prg * Compare data between two period, calculate total, etc. and then export the result to Excel * * The challange is to create a report THAT show SIDE-BY-SIDE...

HI PH: Basically, I have two set of data, same structure, (Feb and Mar), some account in Feb may closed in Mar or the amount may be different, or there is a new account open for the client but not present in Feb. The key of my program (which I have done, in Visual FoxPro) is to create report...

Hi PH: I am new to Access, could you explain this with an example. Thanks Ch

The following is a code is in FoxPro, it creates temporary table and insert test data, How can I do this is Access 2003? Thank you in advance. Ch. * * Create test table for February Month, and populate test data * Create Cursor C_FebData ( Month C(3), company C(10), Client C(15), Account C(6)...

Hi Zei: I don't think it will work, they are using a PC but they have to login into a terminal program and run the script. Chieh.