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 SkipVought 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: *

  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?
  16. joseprez

    HOW I SUMARIZE A FORMULA FIELD?

    I HAVE A FORMULA FIELD IN A GROUP FOOTER AND I CAN'T SUMARIZE, HOW SOLVE THIS?
  17. joseprez

    Why Recordcount equal to 0?

    I have the follow line in my code: Set SN = DB.OpenRecordset(&quot;SELECT * FROM Sales WHERE ID LIKE &quot; & ID_Temp, dbOpenSnapshot) When Table Sales have 1 record, SN.Recordcount return 0 and my application send error 3021. How solve this?
  18. joseprez

    How I do to Compact and repair a file

    How I do to Compact and repair a file made in Access2000, from an application in VB6
  19. joseprez

    DataGrid Control not show data

    The follow code works, when I search a complete names like &quot;MARK&quot;, but when I search names that begin with letter &quot;M&quot; (for example), DataGrid Control is in blank this is the code: Dim con As ADODB.Connection Set con = New ADODB.Connection Dim rs As ADODB.Recordset...

Part and Inventory Search

Back
Top