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 Chris Miller 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. petercav

    Cell Reference to a tab name on Excel

    Hi, Is anyone aware of how to make reference to a tab name on a spreadsheet. ie - I want cell A1 to show me what the tab name is. So if the tab name is June 06, I want this to show up on cell A1. Any help on this is greatly appreciated Regards Petercav
  2. petercav

    Creating User Messages that appears when opening an excel file

    thanks for that! has helped out a lot! Regards Petercav
  3. petercav

    Creating User Messages that appears when opening an excel file

    Hi There, Does anyone know how to create message boxes that pop up when an excel file is open? Similar to when the "read-only" message that comes up sometimes, except that I want to put my own message in there that says "Please remember to do...." Is this possible? Anyones help is greatly...
  4. petercav

    Summarzing subreports in a main report

    Hi dgillz, thanks for the prompt reply. The reason why I am using subreports is because I am using AS400 which does not give me account totals, it only gives me debit and credit values and I have to create formulas to give me account totals. Im not sure I understand what you meant when you...
  5. petercav

    Summarzing subreports in a main report

    Hello.. I am trying to write a financial report in Crystal and have created subreports for each profit centre/account combination I need. Basically I would like to know if it is possible to summarise the data of subreports which have been displayed on the main report. ie - if I have 3 different...
  6. petercav

    Using record selection to display a 'blank'

    Hi everyone, Is it possible to have a record selection which picks up everything without a value in a file? Iam using AS400 and what i want to do is display results when there is no value in table 'LHDES' Any ideas? thanks
  7. petercav

    Message - Failed to open a rowset

    ITS OK - HAVE FIXED IT! THANKS ANYWAY!
  8. petercav

    Message - Failed to open a rowset

    Does anyone know why a little box with "failed to open a rowset" appears at runtime for one of my reports? When I click ok to that another box comes up with e decription saying details: HY000:[IBM][Client Access Express ODBC Driver (32-bit)][DB2/400 SQL] SQL0901 - SQL System Error Any ideas?
  9. petercav

    Subreport Data not appearing on Main Report

    Hello, I am trying to link a subreport to a main report because I needed to change the data type of a field so that I could connect 2 tables. My problem is that I have created a formula to convert a number to a string in the subreport and then I have linked the two string fields together when...
  10. petercav

    Converting a database file from a string to a number

    Hello, I want to be able to convert a field in my database from a string to a number (or the otherway around) so that i am able to link two tables. Is this possible? Anyones help is appreciated Petercav

Part and Inventory Search

Back
Top