Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: pxw
  • Content: Threads
  • Order by date
  1. pxw

    A new VFP contractor needs HELP!

    Hi All, Recently, the company I am F/T working for wants me to work as a contractor. The job is still the same, VFP programming for the software I have been working on in the past 8 years. I need helps regarding this matter; - Copyright. The company doesn't want to claim the copyrights for...
  2. pxw

    move to VFP7 now or wait for VFP8?

    Hi, I am using VFP6 which is okay for my applications. Currenlty, the company I am working for has a fund to purchase a new version of VFP. Should I move VFP 7 now or wait a while for VFP8. Someone said even VFP9 is on the way(?!). The point is I don't want to buy something which needs to...
  3. pxw

    how to insert a page break in a Excel sheet ?

    Could someone tell me how to insert a page break in a Excel sheet using VFP, please? Following is my codes, sfile=Fullpath('EST.xls') oExcel=CreateObject("Excel.Application") oExcel.visible=.T. oExcel.Workbooks.Open(sfile) WITH oExcel oSheet = oExcel.ActiveSheet...
  4. pxw

    Text of diary can't be coped/pasted in some computers?

    Hi, Can someone tell me why the texts of diary can't be coped/pasted in some computers by using Window's default hop keys, Ctrl+C and Ctrl+V? The texts can be high lighted. However, they will be deleted if the users use the keys of Ctrl+C and Ctrl+V. Note that there are no troubles at all...
  5. pxw

    Free VFP Get-together seminars in Australia

    Just to let the VFP Aussies know that there are two coming VFP Get-togethers seminars in Australia next month. Both seminars are free charges: The get-together sessions will consist of two technical presentations by Andrew Coates, director of Civil Solutions. There will also be presentations...
  6. pxw

    Attach a .dbf file into a LN document programmatically?

    Hi All, Is it possible to attach a .dbf into a LN R4.6 document using VFP programmatically? I am a VFP prorammer with some Notesscript knowledge. My case is; - an existing LN database TEST.NSF, - an form named TESTFORM in TEST.NSF, - a date/time field, named D_date, and an attachment in...
  7. pxw

    Attach a .dbf file into a Lotus Notes document programmatically?

    Hi All, Is it possible to attach a .dbf into a Lotus notes document using VFP6 programmatically? Any help would be appreciated. Peter
  8. pxw

    Calendar: Foxuser resource file is unavaiable ?

    When running the following codes, Activate window Calendar I got an error message, "Foxuser resource file is unavaiable. Diary disabled". Note that the calendar still appears on the screen after the error message. However, it doesn't work. Any help would be appreciated. Peter
  9. pxw

    data security ?

    is there any way to make the data, in VFP tables, can ONLY be accessed properly by using a specified VFP program? That means the data will be useless without the program, even those tables can be copied. Any help would be appreciate. Peter
  10. pxw

    can data be appended from a cursor?

    I tested the following codes. It doesn't work, select * from table1 into cursor cTemp select 0 use table2 append from cTemp Am I doing something wrong or VFP6 doesn't like so? The codes work very well if I use "table", insead of "cursor". Peter
  11. pxw

    VFP as a Web Search Engine?

    I has a VFP6 app running in a NT server for LAN users. Now, the users want to access to those data via Internet. My questions are: - is VFP good enough as a Web search engine? - if yes,what I need and how to do? - if no,what I should do to access to those VFP .dbf? The company has a...
  12. pxw

    Help: check box and grid ?

    I added a check box, named CHECK1, into COLUMN1 of a grid manualy. I can see the check box in design time. However, I can't see it in run time. When I placed the code into the init() of the grid, thisform.grid.column1.check1.visible=.t. I got an error message "unknown member...
  13. pxw

    How to update an worksheet in a general field programatically ?

    I am using the following code to create and save an Excel worksheet programatically. It works fine. oExcel=CreateObject("Excel.Application") oExcel.visible=.T. oExcel.Workbooks.Open("TempWorksheet") .Range("F3").Value =thisform.Txtclientname.value...
  14. pxw

    how to detect a form and release it ?

    I have two forms, FORM1 and FORM2, in an app. When activating FORM2, I need to detect FORM1 if it is activated. If yes, FORM1 should be released. I don't know, -how to detect FORM1 from FORM2 ? -how to release the activated FORM1 from FORM2 ? Any help would be greatly appreciated...
  15. pxw

    How to disable or hide an item in a .mnx file?

    Is there any programable way to disable or hide an item in a .mnx menu file? For instance, menu TEST.mnx has two items, INVOICE procedure SETUP submenu What I want is, - The INVOICE section can be accessed by every user. - The SETUP submenu can be accessed only by the authorized...
  16. pxw

    how to export a meno field to Excel together with other fields ?

    Following is the codes I want to export the contents of a memory field to a Excel file together with other fields. It doesn't work. select service COPY TO &gcExcelFile TYPE XLS FIELDS JobNo,comments &&comment is a memo field of service.dbf Any help would be appreciated. Peter
  17. pxw

    how to display a memo field in a grid ?

    Following is the codes I want to display a memory field in a grid. It doesn't work. select service thisform.gridserv.column2.width =400 thisform.gridserv.column2.HEADER1.CAPTION="Service comment" thisform.gridserv.column2.controlSource ="service.comment&quot...
  18. pxw

    Speed up SELECT using inedx?

    Hi, I want to speed up the select process by using an index. I have tried the following two programs. It seems that there is no improvement in program2. Actually, Program2 is slower than Program1 as it needs to generate the index on line. Could someone please tell me how to use the index...
  19. pxw

    gathering updated records ?

    hi, Is there any way to gather all the updated records from a table easier? I am working on an existing VFP system. I need to gather all the updated records from a large number of tables daily. The way I am using is to create a new field named UPDATE in a table. The default value is .F...
  20. pxw

    WHERE IS THE CURSOR?

    I have a VFP app in a NT server. The app is shared by a number of PCs with a mapped network driver. Some of the PCs are located thousands KM away physically. Followings are two SQL statements of the app called by a user from a PC: select * from stock where state="WA" into cursor...

Part and Inventory Search

Back
Top