Search results for query: *

Dear Ramani, Thanks for your info. Yes, I can now control it by adjust the footer bar. But I have to print a label "P.T.O" if more info print on second page. I put the "P.T.O" label inside the footer and mark the check box of When detail overflow to new page. It print...

Dear all, I need to print information on a pre-printed A4 size statement. The bottom of statement got almost 3 inches of pre-printed sentenses. Therefore, I need to force the printer to print on next page when it reach the last 3 inch of the statement. But I can't find any command about bottom...

Don, wqcs, Ramani, Thanks for all of your information. The problem have already solved. Now, I am interesting in the SQL command where Ramani had post for me at the begining. Do anyone know how I can avoid the error? The information from help of VFP also say that if the table is open, it will...

Don, Those variables were set to public variable in Init procedure of the form. FYI. Wanderaround.

Don, Although I store the dw_client to ws_client again, it is after the statement of Set Filter command. Therefore, it won't change the content of the ws_client. Anyway, I remove the line but with the same result. Wanderaround

Ramani, Thanks for your fast response, I did try your suggestion. But it run with error. The error message is something like 'temp_cn.dbf is already a table of database.' Sorry for this stupid question because I am not familiar with SQL command. Wanderaround

I have a form with a Command Button which going to collect data from varous tables and append to a temp table. The problem is the Set filter To command not work in the form of Command Button. I have another form with the same command but it work fine. Anyone can tell me what setting will affect...

Is it possible to find the IP address of remote workstation with the static MAC over the internet? The remote workstation will have dynamic IP address everytime a user connect to the internet. Thanks Wanderaround

I try the rebuilt function, but there are problem with the key generated. The index of origianl table is set to Primary key type, after the rebuilt function, it change to Regular type. Any solution to it? Also, anyone can tell me why the index file always have problem after doing a modification...

Some other issues on listbox. During the data entry, if user click on the exit button from the entry form, it won't exit from entry mode but the cursor just move to next listbox.(If I have more than one listbox inside the form.) I solve this problem by issuing a setfocus command again and again...

Ramani, I didn't try the command you provided but not successful because of my weakness in VFP programming. To made the thing clear, I provide the following detail so that you may detail me on how to do: database name: WS Table1 name: TRANSACT INDEX NAME: TR_CLIENT ( INDEX BY TR_CLIENT ) TABLE...

Ramani, Thanks a lot. Should I define it inside the form before calling the report? Wanderaround

I have problem in creating a daily report with detail inventory information for specific client. The report have 2 tables. 1. Transaction table which store daily transaction for client. 2. Inventory tables which store inventory information for client. Both table have a key field of Client code...

Thank you. It works fine inside the client maintenance program. But when I run this program from Master Menu, it won't work. Do you know why? Wanderaround

With VFP7, I have create a TextBox for user to input client code in a form. Also, I have create a ListBox of client database and it work as a lookup table for user to amend client record. But only Tab key can select the data and copy it to TextBox, is it possible made it the same if user press...

Mike, Thanks for your fast response. The client code is somewhat the shortcut of a client name. So that it is easier for end-user to guess the client code easier. According to your answer to me, how can user to terminate the entry by pressing ESC key? Thanks Wanderaround

With VFP 7, I'm writing a maintenance problem of a client database. The form consist many entry fields, the first field is the client code which should be unique. Therefore, after user enter the client code, the program will check the code to find if the code is exist in the client database. If...

Rgbean, Thank you very much. The problem have been solved by removing that line. Please let me know if I have to change it for every new project? The line is generate the VFP automatically. Any way to set it once only?

Thanks for your fast response. I checked the CONFIG.FPW and find a line screen = off Should I remove this line from config.fpw?

I have installed VFP 7 under Win 2000, also I have upgrade the patch file for VFP. I have write a main program as follows: SET EXCLUSIVE ON SET MULTILOCKS ON SET CARRY OFF SET NEAR OFF SET EXACT ON DO FORM ati READ EVENTS The form ATI include two buttons. One for reading a text file and...