Search results for query: *

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...

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...

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...

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

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...

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...

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"...

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 -...

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...

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

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...

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

Why is the icon of the Internet Favorites folder (c:\documents and settings\MyName\Favorites\) on one of my PC's a star like it was original and on another PC a common folder icon, just the same like all the other folder icons? Both machines run Windows XP Professional Service Pack 2 with all...

In VB.NET 2005 code, I changed the BackColor of a label using lblTest.BackColor = Color.Red Now I want to restore the initial BackColor of that label. In the properties-window of the label, the BackColor is defined as Control. It seems I can not use this through code. How can I set the...

I wrote a VB6 program that uses an Access database. I install the program as an Administrator under Windows 2000 or Windows XP with a setup. The program works fine when logged in as an Administrator. When logged in with an account that has no Administrator rights, the database is not...

In a cross-tab, I want to display the count of a field as a percentage. The percentages are displayed with no decimals. So very small values are shown as 0%. I would like to display them with two decimals, but when I format the values, it doesn't work and the percentages are still displayed...

Hello, In a VB.NET 2005 project, I created a control of my own which contains buttons, panels and textboxes. When I put that control on a form, how can I be sure that all the controls will be resized correctly to the size of the control? I did put some code in the resize-event of the control...

Is it possible to hide some tabpages of a tabcontrol through code in VB.NET 2005? The property visible or enabled (true or false) doensn't seem to exist. How can I achieve to hide some tabpages? Many thanks and greetings from Brugge (Bruges - Belgium), Michel

Hi everyone! In a VB6 application, I want to disable the menu-item "Close form" when there are no child-forms left to close. How can I do that? I thought by counting the open child forms and when the result is 1 or zero, then set the menu-item.disabled to true. Can you help me with a routine...

Hello everyone, Firstof all, my very best wishes to all of you. In a project with a MDI-form and several child-forms, the Windowstate of both MDI-form and child-forms is set to Maximized. However, the first time I open a child-form, it is never displayed Maximized. The second and third are...