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

  • Users: Flupke
  • Order by date
  1. Flupke

    Adjusting formulas after sorting

    Thank you for your help. Can you please tell me how I can add a tag and how I can refer to that tag in a formula on another tabpage? Many thanks, Michel
  2. Flupke

    Adjusting formulas after sorting

    In an Excel file, I have 13 tabpages, for each month one tabpage + one tabpage for the totals. On each tabpage, I have a list of people, sorted by number. On the total page, I have formula's that add the figures on the monthly pages for each person. When I sort the people on a month-page in...
  3. Flupke

    Calculate per 15 minutes

    I use a formula to calculate sales per half hour. It goes like this: time(hour({tblTV_Acties.TVAC_Tijdstip}), (if minute({tblTV_Acties.TVAC_Tijdstip}) < 30 then 0 else 30),0) Now I would like to calculate per 15 minutes. I tried to modify that formula, but it does not...
  4. Flupke

    Left join and Right join

    In a Crystal 8.5 report, I go to Database => Visual linking expert. I right-click on a link and choose Options. I want to make a left join or right join link, but the "SQL join type"-frame is greyed. I cannot change anything. How can I make a left or right join between two tables? My report is...
  5. Flupke

    Sorting on a group-field

    Hello, In my report, I want data grouped on a Person_id. However, I want the data sorted on the Person_name. How can I achieve grouping on an ID and still sort on the NAME? Many thanks and greetings from Bruge (Bruges - Belgium), Michel
  6. Flupke

    Data as parameter

    Thank you for your answer. You wrote: "Try changing your viewer to Active-X or Java." How can I do this? I view the reports in Crystal Reports itself, not through a program. Michel
  7. Flupke

    Data as parameter

    In Crystal Reports XI release 2, I set a parameter as type Date. When prompting for that date, I get a calendar, through which I can browse. Sunday is set as first day. Is it possible to let the week begin with Monday? The calender also appears as a page of my Internet Explorer. In Crystal...
  8. Flupke

    Comparing values in reports with values in subreports

    I'm almost getting there, but not quite. You were right about the currency! Now I have no error, the colon is there and when I preview the subreport only, the correct values are displayed on the subreport. So far so good! But when I view the main report, the shared variable does not have the...
  9. Flupke

    Comparing values in reports with values in subreports

    Thank you very much for your kind help. However, I did not manage to achieve my goal, because I'm not so familiar with programming in Crystal Reports. Am I right in supposing that "subamt" is the name of the variable? In the formula in the subreport, I get an error message "A number is required...
  10. Flupke

    Comparing values in reports with values in subreports

    I have a report with a value that is a sum in a group footer. In that report is a subreport with also a value that is a sum in a group footer. How can I make a formula that compares these two values. When I make a formula in the main report, I can of course access the value in the main report...
  11. Flupke

    Subreports and OCX

    In Crystal Reports 8.5, I have a report with a subreport that run fine in Crystal Reports itself. When I invoke the report from Visual Basic 6 through OCX, the report (and all others) run fine only if I remove the subreport. This is my code: crpt.ReportFileName = "rptInkomstenStortingen.rpt"...
  12. Flupke

    Making of .exe not possible

    Indeed! That helped! Thank you very much for your quick answer. Can you please tell me what was going wrong en what could possibly be the reason of that problem? Many, many thanks, Michel
  13. Flupke

    Making of .exe not possible

    Hello, In my Visual Basic 6, when I want to make an exe, the item File => Make Project1.exe is no longer highlighted, so it is not possible for me to make an exe of my program any more. Can anyone tell me what's going on and how I can fis this? Many thanks and greetings from Brugge (Bruges -...
  14. Flupke

    Copy and Paste

    Hello, Thank you for replying. My goal is indeed to assemble all the different bits in one document. When I copy a very large Excel spreadsheet and paste it into Word, only the amount that can be put in one Word-page is copied. The rest seems to have vanished. Unless I do something wrong...
  15. Flupke

    Copy and Paste

    Hello, I want to copy several items (spreadsheets, graphics, text, ...) from different Excel-sheets, along with other items (images, ...) into one file, so it can be printed and presented as one bundle of pages. When I choose copy and paste (special) into Microsoft Word, it never gives me the...
  16. Flupke

    Flashing colors in MSFlexgrid

    Hello, In a VB6 MSFlexgrid, I would like to give a particular row a flashing color. Is that possible and how can I achieve this? Many thanks and greetings from Brugge (Bruges - Belgium), Michel
  17. Flupke

    Default properties for Forms in VB.NET 2005

    Can you please add a bit more information on how I can create a template? Or point my in the direction where I can find more help on the subject? Many thanks and greetings from Brugge (Bruges - Belgium), Michel
  18. Flupke

    DoEvents in VB.NET 2005

    Multi-threading. Can you please enlighten me on how I can use it to achieve my goal? Many thanks and greetings from Brugge (Bruges - Belgium), Michel
  19. Flupke

    Default properties for Forms in VB.NET 2005

    In VB.NET 2005, I want that every time I create a solution / project and every time I create a new form, certain properties are set as defaults. E.g. I want the default Fontsize to be 12 or I want the Controlbox set to False. How can I achieve that? Many thanks and greetings from Brugge...
  20. Flupke

    DoEvents in VB.NET 2005

    I want a program to halt until a certain code of variable lenght is terminated. In VB6 I used DoEvents. What is the way in VB.NET 2005 to achieve this? Many thanks and greetings from Brugge (Bruges - Belgium), Michel

Part and Inventory Search

Back
Top