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!

Recent content by joseprez

  1. joseprez

    How I get SubTotals?

    In my report in section Details I use a formula field like this: NumberVar A := A + ..Any Calculate.. it work great and another formula field in Report Footer with this: WhilePrintingRecords; NumberVar A; and it work's! How I get SubTotals in my Group Footer #1 from formula field in section...
  2. joseprez

    Saving and Reading picture

    with DAO, I want to save and read pictures. I use this CommonDialog1.Filter = "Bitmap (*.bmp)|*.bmp|Jpeg (*.jpg)|*.jpg|" CommonDialog1.Action = 1 Image1.Picture = LoadPicture(CommonDialog1.FileName) << this work great >> ....... << but, when run this >> MyDS.AddNew MyDS!YourPic =...
  3. joseprez

    The matching &quot; for this string is mising.

    Public rChkNum as double Public rChkMSG, rLineMSG as string rChkNum = CHK0!ChkNum rChkMSG = Trim(CHK0!Memo) rLineMSG = "This Check#: " & cStr(rChkNum) & " (" & rChkMSG & ")" .... crxReport.FormulaFields.Item(19).Text = Chr(34) & rLineMSG & Chr(34) after this line, send me the message: "The...
  4. joseprez

    The matching &quot; for this string is mising.

    Public rChkNum as double Public rChkMSG, rLineMSG as string rChkNum = CHK0!ChkNum rChkMSG = Trim(CHK0!Memo) rLineMSG = "This Check#: " & cStr(rChkNum) & " (" & rChkMSG & ")" .... crxReport.FormulaFields.Item(19).Text = Chr(34) & rLineMSG & Chr(34) after this line, send me the message: "The...
  5. joseprez

    The matching &quot; for this string is mising.

    I send a variable string from VB6 to a report made in Crystal 8.5 when I do this send me this message "The matching " for this string is mising." help me to fixed!!!
  6. joseprez

    NewsGroup Page . . .

    How I do a newsgroup page?
  7. joseprez

    NewsGroup Page . . .

    How I do a newsgroup webpage?
  8. joseprez

    Custom PaperSize for Printer?

    I have Win2000 and Panasonic Printer KX-P1150. I'll have to print a voucher with this dimension: width = 9 inches or 22.86 cm heigth = 5.5 inches or 13.97 cm I create a custom papersize in &quot;Settings\Printers&quot; on Windows, but, when I use in VB6 Printer.PaperSize = vbPRPSUser...
  9. joseprez

    How I print to printer?

    How in VB6, print my file &quot;Receives.txt&quot; to the printer.
  10. joseprez

    Don't display data. . .

    I use CRW 8.5 I have 2 tables in my report TABLE 1 TABLE 2 ID ID DATE DATE ORDER ORDER NAME AMOUNT ... ... Links are (ID, DATE and ORDER), my report use all fields from Table2 and field NAME from Table1, when I do a preview, field NAME is blank. How...
  11. joseprez

    How Summarize and use other Fields

    When I do &quot;SELECT SUM(Table1.Field1) as VariableSumField1 &quot; _ & &quot;FROM Table1, Table2 WHERE Criteria&quot; this work great! Now I want use other fields from both tables. I try this &quot;SELECT SUM(Table1.Field1) as VariableSumField1, &quot; _ & &quot;Table1.Field2...
  12. joseprez

    HOW I SUMARIZE A FORMULA FIELD?

    Your Sample work's!, I have a Syntax problem and I fixed. Thank's for your help!!!
  13. joseprez

    HOW I SUMARIZE A FORMULA FIELD?

    the error message is for the variable Total
  14. joseprez

    HOW I SUMARIZE A FORMULA FIELD?

    When I do this: WhilePrintingRecords; Numbervar Total:=Total + sum({field},{Group})* if sum({field},{Group})>120 then .01 else .02 Send me the follow error message after asignation &quot;A number is requiere here&quot;
  15. joseprez

    HOW I SUMARIZE A FORMULA FIELD?

    My formula simply multiply a sumarize field for 0.01 if sumarize field greater than 120 and multiply for 0.02 if sumarize field less or equal than 120. I want totalize this formula field. How I do?

Part and Inventory Search

Back
Top