Search:

Type: Posts; User: Grand

Page 1 of 12 1 2 3 4

Search: Search took 0.06 seconds.

  1. Re: [RESOLVED] VB.net Accessing control on a tabcontrol second tab page on another fo

    Thanks for highlighting that. I also see that this is not the proper way to do it. There will be a clean up.
  2. [RESOLVED] VB.net Accessing control on a tabcontrol second tab page on another form

    Hi
    I have a problem when trying to set the selected index of a combobox that is on a from from a shared/public class. I get no error when I do that for another combobox (called CB_Update_CaseID in...
  3. Re: [RESOLVED] SQL - Query to return sum and 0 if no match is found

    Hi again :)
    I have spent now a few days to tune it to the full purpose but am unable to get it to work. The last bit is this: before this I had a little code that helped me to get an overview of the...
  4. Re: SQL - Query to return sum and 0 if no match is found

    Thanks a lot :)
    Did a bit of modification and it does what I needed:


    SELECT
    HOC.ListItemName,
    SUM(CASE WHEN C.CaseID IS NULL THEN 0 ELSE 1 END) As TotalSum
    FROM DV_ListItems as HOC
    LEFT...
  5. Re: SQL - Query to return sum and 0 if no match is found

    Thanks. Is the SQL code for creating temporary sample sufficient?
  6. Re: SQL - Query to return sum and 0 if no match is found

    Thanks again.

    Edit, now with SQL :)
  7. Re: SQL - Query to return sum and 0 if no match is found

    Thank you for taking time to look into this.
    When I try to upload an Excel file here´, it tells me invalid file thing. Which format shall I upload the tables?
  8. Re: SQL - Query to return sum and 0 if no match is found

    Thank you so much for your tireless effort here.

    I am however getting the same result :(
    just a side question, why those dates are important here adn more specifically why they should be null?...
  9. Re: SQL - Query to return sum and 0 if no match is found

    I got you about the format.
    But, then those dates jsut set the period for the data range I am interested in. It is all good for the rest of the items. Waht I want to see is that there is no "lagging...
  10. Re: SQL - Query to return sum and 0 if no match is found

    Thank you.
    How should I account for those dates; as soon as I use them then the result is messed up.
  11. [RESOLVED] SQL - Query to return sum and 0 if no match is found

    Hi
    I have a table (HOC) containing the list of some items. I need to check another table (DA ) against HOC and sum up the occurrences of items and if no item is found then return 0 for sum.

    My...
  12. Re: [RESOLVED] SQL - Query to list all year-to-date weeks and sum up occurrences of t

    Thanks.
    I think, being lazy, I will just go ahead and create a permanent table containing numbers 1 to 53 :)
  13. Re: [RESOLVED] SQL - Query to list all year-to-date weeks and sum up occurrences of t

    Thanks. How will I produce that master thing. Can I produce that with a query or should be a table by itself.
  14. Re: SQL - Query to list all year-to-date weeks and sum up occurrences of tasks for a

    Thank you so much. It does what I need :) And special thanks for speedy response and explanation. I just had to modify a bit to start with
    Select SUBMITTED.Weeknum,SubmittedMajor,CompletedMajor ...
  15. [RESOLVED] SQL - Query to list all year-to-date weeks and sum up occurrences of tasks for a week

    Hi
    I am not able to construct a query to perform the following:
    - I need to list all week numbers year-to-date; so, 1,2,3,... 34 and
    - Sum up how many tasks were created in each week and how many...
  16. Re: VB.net Datagridview's display order is different than the data source

    Thank you Peter. I just realised that I was not resetting the DGV's data source.
    so, this fixed it:


    With ThisDGV

    .DataSource...
  17. [RESOLVED] VB.net Datagridview's display order is different than the data source

    Hi
    I am having difficulties to fix my issue of display order of a datagridview that is used to display the content of different datatables.
    The exact issue is that when the datasource of the DGV is...
  18. Replies
    0
    Views
    246

    SQL - issue with union and nulls

    Hi,
    I need to to use union to append two tables. I, of course bused null to adjut the column count to be indentical but then I am getting nulls for tht column.
    How is that done correctly?


    ...
  19. Re: vb.net set color of chart columns based on Xvalue (string)

    Thanks. I don't know why I didn't find them useful. Implementing that idea, I got it working:

    Dim PointCounter As Integer = 0
    'Adding values
    If ColumnNames.Length > 0...
  20. [RESOLVED] vb.net set color of chart columns based on Xvalue (string)

    Hi
    I have a chart with some columns on it; all fine. But I need that specific columns have certain color. So, if the Xpoint is called "etc "then the color of the column must be green and so on. How...
  21. Re: Drag&drop multiple items from one listbox to another

    Thank you all. Just deleted everything and added them from scratch and everything works now.
  22. Re: How to detect if an item added or removed from a ListBox

    You are both right. I have overlooked those facts. I have everything I need I just need to use them correctly.
  23. Re: How to detect if an item added or removed from a ListBox

    Thanks a lot for this. I just checked it and it works :) There is a slight "issue" there that if multiple items are added or removed at once, the event is fired multiple times. Is there a way to...
  24. Re: How to detect if an item added or removed from a ListBox

    Thank you jmcilhinney. I will investigate that.
  25. [RESOLVED] How to detect if an item added or removed from a ListBox

    Hi

    Is there an event to be used to detect if the item count of a ListBox is changed? If not, any trick I could use instead?

    Thank in advance.

    Edit. BTW, the items are added manually and not...
  26. Re: Drag&drop multiple items from one listbox to another

    Thank you.
    I just encountered an issue; when the application starts, users cannot D&D (drag and drop) only one item; they can D&D multiple items though. But then if there are items already in the...
  27. Re: Drag&drop multiple items from one listbox to another

    Thank you so much for your simple explanation. Everything works fine now :) Just 2 more questions;
    1- why I cannot combine your code with pouls listbox? I should be able to do that right? It...
  28. Re: Drag&drop multiple items from one listbox to another

    Thanks. :) I have never used custom controls. How will I add this to my project? Will it appear in the tool box just like the other controls? I will google to see if I can manage that.
  29. Re: Drag&drop multiple items from one listbox to another

    Thanks gain. Tested and it beautifully does drag and drop multiple items. My additional requirement which is actually a more refined user experience is still unsolved. I believe I will use the...
  30. Re: Drag&drop multiple items from one listbox to another

    Thnanks for looking into it. Here my code for a single items. I will read jmcihinney reference now and will try to test code in your other post.
    Private Sub ListBox1_MouseDown(sender As Object, e...
  31. [RESOLVED] Drag&drop multiple items from one listbox to another

    Hi,

    I cannot find a a way to drag and drop multiple items at once from one ListBox to another.
    I got is working for one items but then I got stuck for multiple selection. Any working example?...
  32. Re: [RESOLVED] Set row height of Excel rows when exporting from datatable

    Thank you. Issue is solved now :)
  33. Re: [RESOLVED] Set row height of Excel rows when exporting from datatable

    I can find out how many rows there are after exportign the data to the sheet:

    Dim Cells(RowsCount - 1, ColumnsCount - 1) As Object

    For j As Integer = 0 To RowsCount - 1
    ...
  34. Re: [RESOLVED] Set row height of Excel rows when exporting from datatable

    duplicate. Sorry.
  35. Re: [RESOLVED] Set row height of Excel rows when exporting from datatable

    I did the same trick with recording and that was what I was doing in my fisrt post:

    Worksheet.Range((Worksheet.Cells(2, 1)), (Worksheet.Cells(RowsCount + 1, ColumnsCount))).Value = Cells
    ...
  36. Re: Set row height of Excel rows when exporting from datatable

    Than you ChrisE. I was trying to avoid looping through as it takes some time but if that is the only way then I take it :)
  37. [RESOLVED] Set row height of Excel rows when exporting from datatable

    Hi,
    I am unable to find guides for my issue. When I export my datatable to Excel, the row heights are dynamically set to fit the content. I would like to set the row height to a fix number or wrap...
  38. [RESOLVED] How to fit chart to page when printing using PrintDocument

    Hi,
    I am trying to figure out how to fit a chat to a landscape oriented page but can't make it to work:


    Private Sub Print1_PrintPage(sender As Object, e As Printing.PrintPageEventArgs)...
  39. Re: [RESOLVED] SQL - Running total for multiple columns, reset and special

    OK :(
    The query I use up there takes a very long time (3 second for 65 records, when comparing weeks of different years) to process. Any idea why and if we have a better approach?

    Edit: no...
  40. Re: SQL - Running total for multiple columns, reset and special

    I don't think that my database has those functions; I have tried to just write a dummy query with those and got an error that that re not recognised.
Results 1 to 40 of 449
Page 1 of 12 1 2 3 4



Click Here to Expand Forum to Full Width