Search results for query: *

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.

Hi: My friend is working in a firm that uses software written in Fortran 77. He is trying to run a batch script to automate file download on a nightly basis. However the script always stopped and prompt user to hit enter key, i.e. the file dialog shows up waiting for user to hit ok to save the...

Hi: Does anyone has experience in creating a low level file i/O program to open up a btrieve 5.1 btr database file and extract the data to a text delimited or comma delimited format? Chieh

Hi: One of my client is using Btrieve 5.1 in a Dos environment, They need to do some reporting on a data store in a btrieve database, i.e. CusOrder.Btr, I would like to find out if there is anyway where I can access this table directly from Visual Foxpro 9, as far as I know from reading the...

Hello Carl: Thank you for your reply, How can I do it from console? does it meant at the server side? Chieh

Hello Everyone: our client access their app Citrix client to Citrix metaframe server 1.8. when they try to print 2 or 3 copies of the report from their app and want to use collate feature. Even though the printing setting shows collate is check on but when printed, it is not. Our client is...