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 TouchToneTommy 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: paulmtl
  • Content: Threads
  • Order by date
  1. paulmtl

    Compile error,can't find project or library

    Hi all, I try to run a sample.mdb program and get an error message compile error, can't find project or library ? in the VBA editor Please explain what went wrong ? Thanks in advance,
  2. paulmtl

    VFP to VB codes help

    Hi all, This is my codes in Visual Foxpro, can someone who had knowledge of VFP and VB, helps me to convert to VB. Thanks in advance, CREATE CURSOR crsResult (account C(10),amount N(15,2), percentage N(6,2), ClassCode C(5)) SELECT MyTable INDEX ON Account+ClassCode TAG MyTable && With proper...
  3. paulmtl

    Calculate a percentage

    Hi all, How to create the formula to calculate the percentage out of the total in general format can be used all along ? from myExcel.xls account amount classcode percentage 11111 100 AAAAA 0.16 11111 200 AAAAA 0.34 11111 300 AAAAA 0.50 --------------- subtotal 600 11111 100 BBBBB...
  4. paulmtl

    Percent calculation in VBA codes

    Hi all, How to create the formula to calculate the percentage out of the total in general format can be used all along ? from myExcel.xls account amount classcode percentage 11111 100 AAAAA 0.16 11111 200 AAAAA 0.34 11111 300 AAAAA 0.50 --------------- subtotal 600 11111 100 BBBBB...
  5. paulmtl

    Percent of total

    Hi all, How to create the formula to calculate the percentage out of the total in general format can be used all along ? from mytable.dbf account amount percentage 11111 100 0.16 11111 200 0.34 11111 300 0.50 --------------- subtotal 600 22222 200 0.25 22222 200 0.25 22222 400 0.50...
  6. paulmtl

    Macro help copy&paste

    Hi all, I created a macro16() to copy and paste as you can see below but always copied to the same row means the first row How to correct this macro to copy to second row and so on...? row1 john doe row1 brian die to get : row1 john doe row2 brian die Thanks in advance, the codes by...
  7. paulmtl

    Percent of total

    Hi all, How to create the formula to calculate the percentage out of the total in general format can be used all along ? account amount percentage 11111 100 0.16 11111 200 0.34 11111 300 0.50 --------------- 600 22222 200 0.25 22222...
  8. paulmtl

    Combo box how to

    Hi all, How to use combo box in the Excel workboot ? empno: 11111 22222 33333 44444 in order to select empno from combo box Thanks in advance
  9. paulmtl

    Array in workbook

    Hi all, I am very new to VBA and Excel workbook, someone told me to use an array would be very advantage instead of using macro. Please give me some advices and tips to start with an array. TIA
  10. paulmtl

    Data from scratch for test

    Hi all, I have several vfp programs that needed to redo the complete test for each module. I need advices how to create test data from scratch, either from an existing tables or from the sources codes for each module OR both ? means to have the maximum scenarios possible during the test of...
  11. paulmtl

    Alias 'oApp' is not found error

    Hi all, I always have this error : Alias 'oApp' is not found error in my code here: If oApp.lQuit Return ENDIF Please help to explain. TIA
  12. paulmtl

    HTML inside the program

    Hi all, I know we can save myreport.frx as myreport.html while opening it. How to do it inside the program and to call the browser to view immmediately ? Any help or advice would be reallly appreciated ? Tia
  13. paulmtl

    Crystal Web Component Server HOW ?

    Hi all, Please provide some advices how to use the Crystal Web Component Server (CWCS) in order to deploy reports on an Intranet so that users can view them in their browsers ? Tia
  14. paulmtl

    Transform can't do all my rules

    Hi all, I used this code to transform my output but it is not always right, transform(iif(netamount<0,Query.cusfax,Query.trstfax),'@R (999) 999-9999 9999') because I get : (123) 456-7890 good for the input as 1234567890 (456) 789-0 wrong for the input as 4567890, supposed to have ( )...
  15. paulmtl

    Menu.spr did change after rebuit main.exe

    Hi all, I made a change to my menu.spr and then rebuilt my main.exe I run main.exe but did not follow my change in menu.spr at all, in addition in my main.pjx , open again menu.spr seems to keep unchanged codes.( means new codes are not in at all ) Why ? please help explain to me asap. TIA
  16. paulmtl

    Upgraded to CR11 problem with VFP.

    Hi all, This procedure is to print a crystal report version 7 without any problems at all, but I ugraded to version to version 11, I have this error message : Crystal report error ! Error number 20525 Error message : Unable to load report exactly from the codes trapping error section as ...
  17. paulmtl

    CR7 upgraded to CR11 problem

    Hi all, I upgraded myreportcr7.rpt to become myreportcr11.rpt and seemed to have a problem about OLE with Visual Foxpro 5.0 ? Can someone helps me to explain what went wrong because I am new to both CR7 & CR11 ? But when I run myportcr11.rpt directly without VFP5.0 interface with OLE objects...

Part and Inventory Search

Back
Top