Search Results - VBForums

Search:

Type: Posts; User: SparrowHawk7

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: Datagridivew indexing problem

    Well, I found the problem although it makes absolutely no sense to me. It was disabling the group box that contained the detailed data. If I do not disable the box after updating the data, the...
  2. Re: Datagridivew indexing problem

    These three subs are used to load the datatable (TABLE)


    Imports System.Data.OleDb

    Public Class clsMDBDatabase
    Dim OLECmd As New OleDbCommand
    Dim OLEDA As New OleDbDataAdapter
  3. [RESOLVED] Datagridivew indexing problem

    Using VB.net 2012 and a datagridview. I'm using a datatable to populate a datagridview programmatically. If I click a cell, the data on that row should be displayed in greater detail elsewhere. This...
  4. Re: [RESOLVED] Chart Control Scale VB 2012

    The angle works great .. thank you. Sometimes the syntax on things is not exactly intuitive.

    The binding is still the same problem. I used an alias in the sql statement for Date .. but the problem...
  5. Re: Chart Control Scale VB 2012

    Thanks for the information guys. What I ended up doing was this:


    Dim s As New Series
    s.Name = "PPG"
    s.ChartType = SeriesChartType.Line

    Dim mn As Double = 1000
    ...
  6. [RESOLVED] Chart Control Scale VB 2012

    I'm using the stock chart control in vb 2012 and getting the data from an MS Access dB.


    SQL = "SELECT Fuel.DatePurchased as [Date], Fuel.PPG FROM Fuel " &
    "WHERE (Fuel.DatePurchased...
  7. Replies
    1
    Views
    548

    Re: Formula problem

    OK ... I found the answer. I went into VS and experimented with split until I understood it. Then I went back to CR and used Basic Syntax with this:

    dim birthday() as string
    dim mnth as string...
  8. Replies
    1
    Views
    548

    [RESOLVED] Formula problem

    I think I'm posting in the right place. I'm using Crystal Reports XI developer with an MDB database. One field in the database is called Birthday and is a text field in the format for example, of...
  9. Re: Centering Text in Column Headers on datagridview

    Yep ... that was it .. the sorting icon. Thanks a million. I might try fiddling around and try to adjust the spaces to allow for the sorting arrow since I would like the user to have that available...
  10. [RESOLVED] Centering Text in Column Headers on datagridview

    I can't seem to get my text centered in column headers on a datagridview for some reason. The text in the cells is centered ... but not in the column headers. I'm using VB 2012 with the default...
  11. Re: Sql statement question ....

    Thanks for the visual ... that helped me get things straight in my head. After a lot of fiddling around with conditions I now have things working the way I want them. For anyone reading this and...
  12. Re: Sql statement question ....

    Thanks for putting up with me, tg ... I've been writing code since 1970 but until now I've been able to get by with pretty simple sql. This is working sort of backwards to my mind ...
    I follow the...
  13. Re: Sql statement question ....

    Thanks for the reply TG. The Units.UnitID field is autonumbered so it's unique and never null - the BuildingID will never be null either. What I was wanting to do is fill a grid with available units...
  14. [RESOLVED] Sql statement question ....

    I've never had to try using EXCEPT in sql but I think that is what I need for this. I've stripped off all the irrelevant fields to make this as straightforward as I can here. I'm using VB 2012 and an...
  15. Replies
    6
    Views
    903

    Re: [RESOLVED] Inner join problem

    Thanks jm. The buildingID in the reservation table was experimental as I couldn't seem to get that information from the Unit table. Once I managed to get the syntax in order I removed it. I...
  16. Replies
    6
    Views
    903

    Re: Inner join problem

    After fiddling around for a couple hours I stumbled on the correct syntax and order. I removed the BuildingID field from the Reservation Table as it was just superfluous.:


    "SELECT...
  17. Replies
    6
    Views
    903

    Re: Inner join problem

    Thank you for the reply jmcilhinney. Your answer is what I had been trying but without success. (I built the SQL statement line by line because it made it easier for me to include or exclude a line...
  18. Replies
    6
    Views
    903

    [RESOLVED] Inner join problem

    I assume this belongs in this forum ...

    I've got an Access 2003 type dB with 3 tables, Reservations, Buildings and Units. The Units table has UnitID, BuildingID and UnitNumber fields. The Building...
  19. Re: Step through datagridview column

    Thanks for the reply jmcilhinney. I ended up adding a new column, hiding the integer column and then stepping through the data to populate the new column. I tried doing that once before in this...
  20. Re: Step through datagridview column

    Thanks for the replies guys.

    I tried that approach initially but

    frmMain.grdUnits.Columns("Occ").Value = "open"
    gives the error "'value' is not a member of...
  21. Re: Step through datagridview column

    I'm trying to get one column to show "open" when the value is 0 and "occ" when the value is 1.
  22. [RESOLVED] Step through datagridview column

    I'm using vb 2012. Somewhere I'm missing something ... this should be really easy. In fact I use the same technique on another grid which works fine. This grid won't cooperate. The column I'm...
  23. Replies
    4
    Views
    311

    Re: Problem sorting a combo

    Thank you for the quick reply. Setting the sorted property of the combo resulted in scrambled results. However, using a dataview and sorting that did the trick. I've never used a dataview so I never...
  24. Replies
    4
    Views
    311

    [RESOLVED] Problem sorting a combo

    Using vb 2012 I bind the combo to a datatable (TABLE). I also add a new row <None>.


    Dim row As DataRow
    row = TABLE.NewRow()
    row("EmployeeID") = 0
    row("EmployeeName") = "<None>"...
  25. Re: Hide column in DataGridView control

    Yes indeed ... that's what it was. I was busy thinking columns. Who'da thunk it?

    Thanks to you both!

    Ken
  26. [RESOLVED] Hide column in DataGridView control

    This is probably ridiculously easy but I've tried searching for an answer without success. I don't think I'm using the right terminology. I want to hide the selection column in a DataGridView control...
  27. Replies
    4
    Views
    518

    Re: Get Record Count

    Of course! Silly mistake .. thanks for pointing it out. Duh! Thank you!
  28. Replies
    4
    Views
    518

    Re: Get Record Count

    Thanks for the reply! I made the changes you suggested which make perfect sense to me .. but I still get the complaint:



    On the Return CNT line.
  29. Replies
    4
    Views
    518

    [RESOLVED] Get Record Count

    Back with another simple question that I cannot seem to get past. Everywhere I look on the net people are using readers but it seems to me a nonquery is indicated for this ... Unfortunately my syntax...
  30. Replies
    5
    Views
    461

    Re: Test for empty dataset

    That worked a charm wes4dbt! Thank you! I figured it was some pretty simple syntax that I just couldn't quite get hold of. THANK YOU!
  31. Replies
    5
    Views
    461

    Re: Test for empty dataset

    Thanks for the reply, KG. With either approach, the null dataset apparently is never true - although the grid is empty. I tried both ways and the code always thought the dataset was populated so it...
  32. Replies
    5
    Views
    461

    [RESOLVED] Test for empty dataset

    I've been unable to figure out how to do this although it ought to be really simple. I'm using VB 2012.




    Dim connection As SqlConnection = clsConnection.GetConnection()
    Dim DataAdapter As...
  33. Re: Invalid Column Name with Date

    Thank you! That was it.
  34. [RESOLVED] Invalid Column Name with Date

    (Mod: I'm not sure if this is the right place to post this ... )

    I'm getting pretty confused about using dates in grids in VB 2012.

    I am using 10 grids in the program so I wrote reusable code...
  35. Replies
    2
    Views
    620

    Re: Best Practices VB 2012

    Thanks for the reply, Kevin. That gives me some stuff to consider and look into. Most everything I see on the net is very specific to a single question but not much goes into program architecture....
  36. Replies
    2
    Views
    620

    Best Practices VB 2012

    I'm pretty new to VB2012 having come from years of working with VB6. In VB6 I rarely worked with classes with the occasional exception of using classes for repetitive forms. Since I'm just getting...
  37. Re: set radio buttons based on integers from tableadapter query

    Ah I see .. thanks. I'll give that a try and see where it leads me.
  38. Re: set radio buttons based on integers from tableadapter query

    I tend to agree with you ... using the wizards are fast, but I find myself completely confused and lost much of the time.

    The problem I had was trying to figure out how to make a connection in...
  39. Re: set radio buttons based on integers from tableadapter query

    Thanks Paul .. I sort of figured it would be an if=then=else statement ...so it makes sense .. but I found I had to change things all around for VB to accept the syntax...
  40. [RESOLVED] set radio buttons based on integers from tableadapter query

    Using VB 2012 and sqlexpress. I have a grid with a hidden column (TaskID) which is filled with the primary key for the task record displayed in that row. Here is the code I use to return one record...
Results 1 to 40 of 234
Page 1 of 6 1 2 3 4



Featured


Click Here to Expand Forum to Full Width