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!

Register Log in
  • Congratulations derfloh 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: HezMac
  • Order by date
  1. HezMac

    Negative Number Issue

    Hi I'm trying to populate a payment field. I have a list of all 12 months, and the report is based on a date range. The report is based on fiscal year, April 1 - March 31. If the payment is within the date range and is not zero, I want the number value to show, either negative or positive...
  2. HezMac

    Round Page Number

    Nice! Perfect! Thanks, LBass!
  3. HezMac

    Round Page Number

    Hello I'm trying to put the PageNumber function in a formula, and it's coming back "Page 3.00 of 4.00". I've tried the Round function but doesn't seem to be working. Is there something else I should try? Here's the function: If {V_CRYSTAL_EL_RENEWAL_NOTICE.OPTOUT} = 'NO' THEN 'Page '...
  4. HezMac

    Rounding decimal to a whole number

    AlreadyLost: You should put how you fixed it!
  5. HezMac

    Date format in formula

    Thanks, dgillz! That worked! What is that '0, "") ' anyway?
  6. HezMac

    Date format in formula

    Hi I would like a column heading to read: April - 2005 Where the year is dependant on the parameter entered. I'm using the following formula: If month({?StartDate}) in 4 to 12 then 'April - ' & Year({?StartDate}) Else If month({?StartDate}) in 1 to 3 then 'April - ' &...
  7. HezMac

    Date in future formula

    Oh no.... just realized that fiscal year is going to screw up the month(currentdate) part of the formula....
  8. HezMac

    Date in future formula

    Awesome, thanks. That seems to work great. One more question: the dash is showing, but for some reason, there's a '$' in front of it. I don't have $ set up for any other values... wonder what's going on. Thanks very much.
  9. HezMac

    Date in future formula

    Hi I'm creating a report that lists payments for a fiscal year (April 1 - March 31). I have a column for each month. I'm not using a cross tab query, as the report will be exported into an excel spreadsheet. The user inputs start and end date parameters. Say the user enters the date range...
  10. HezMac

    Runtime error 429 (ActiveX can't create object) on PrintData

    Hey Matt Thanks. This was the problem. Actually, what happened was this: I uninstalled an older version of the application I was working on, and when I did, some SSUltraGrid files were deleted. So, the next time I re-compiled, the files were not on my computer to get packaged up. Your...
  11. HezMac

    Loop in batches

    I'm not sure what you mean. Test if the row is selected? What will that do? Thanks.
  12. HezMac

    Loop in batches

    Hi I would like to send a string of numbers to a PL/SQL procedure from VB6. The string of numbers represents unique IDs concatenated together. The string can only be 2000 characters, approximately the unique IDs of 200 records. If the string is 3000, I'd like to send the first 2000 along...
  13. HezMac

    Runtime error 429 (ActiveX can't create object) on PrintData

    Hi I'm getting a runtime error 429 on the following code. Private Sub cmdPrintGrid_Click() gridPending.PrintData False, True End Sub I'm printing the information from an SSUltraGrid. This started after I created an exe using Wise Installer, and it worked fine before that! I...
  14. HezMac

    HAVING clause

    ...in PL/SQL it works fine, but when I call it from VB, I get an ORA-06512 error "Not a GROUP BY expression". Here's the procedure: SELECT COUNT (*) INTO out_TestCount FROM (SELECT MAX (FolderRSN) AS FolderRSN, TRUNC(MAX(PaymentDate)) AS LastPmtDate FROM (SELECT F.FolderRSN...
  15. HezMac

    Outer Join in 'Not Exists'

    That worked!!! How'd you know that? I've been looking at this for hours... Thank you so much.
  16. HezMac

    Outer Join in 'Not Exists'

    Hello I'm trying to run a query checks for existing rows in a 'queue' table (Batch_Reassign). If a row is already in the Batch_Reassign table, don't return it in subsequent queries. Here's the code, when I run it without any records in the Batch_Reassign table, nothing is returned. When...
  17. HezMac

    Number rows in grid

    If anybody else is looking for this, here's what worked for me. Private Sub NumberRows() Dim Row As SSRow Dim RowNum As Integer If gridPending.HasRows = True Then RowNum = 0 Set Row = gridPending.GetRow(ssChildRowFirst) RowNum = RowNum + 1...
  18. HezMac

    Number rows in grid

    vladk: What returns Row property? I'm not sure what you mean...
  19. HezMac

    Number rows in grid

    Hey I was wondering if there's an easy way to number the rows in a grid. I'm using SSultragrid, and would just like to have a number next to each row. Seems simple enough, but can't find a "number" property to turn on for the grid... Thanks for any suggestions.
  20. HezMac

    Loop through selected rows in ultragrid

    Got it figured out. Here is what works for me, if anyone else is interested. Golom: you were right, I needed to reference '0' where I wasn't referencing anything. Private Sub cmdRemovePending_Click() Dim aRow As SSRow Dim cellCount As SSRow Dim FolderRSN As String Dim...

Part and Inventory Search

Back
Top