Search Results - VBForums

Search:

Type: Posts; User: SparrowHawk7

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    6
    Views
    165

    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...
  2. Replies
    6
    Views
    165

    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...
  3. Replies
    6
    Views
    165

    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...
  4. Replies
    6
    Views
    165

    [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...
  5. 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...
  6. 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...
  7. 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.
  8. [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...
  9. Replies
    4
    Views
    127

    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...
  10. Replies
    4
    Views
    127

    [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>"...
  11. 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
  12. [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...
  13. Replies
    4
    Views
    218

    Re: Get Record Count

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

    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.
  15. Replies
    4
    Views
    218

    [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...
  16. Replies
    5
    Views
    216

    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!
  17. Replies
    5
    Views
    216

    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...
  18. Replies
    5
    Views
    216

    [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...
  19. Re: Invalid Column Name with Date

    Thank you! That was it.
  20. [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...
  21. Replies
    2
    Views
    351

    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....
  22. Replies
    2
    Views
    351

    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...
  23. 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.
  24. 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...
  25. 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...
  26. [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...
  27. Re: compacting 2010 accdb database using VB 2012

    Then an mdb format?
  28. Re: compacting 2010 accdb database using VB 2012

    TG:
    I'm sorry .. the exception is an "invalid argument".

    DF:
    I can't guarantee that the end users will have Access 2007+ installed and since I need to clean the file up from time to time after...
  29. compacting 2010 accdb database using VB 2012

    I've looked all over the net and tried all sorts of different code suggestions, but nothing seems to work. I'm obviously doing something wrong, but I don't know what it could be.


    'Add a...
  30. Re: Chilkd form still jumping on resize

    It's clear you have no respect for me. That's too bad .. but your choice. Thank you for trying anyway.
  31. Re: Chilkd form still jumping on resize

    The application uses roughly 10 different forms. There is a button bar so the user can select which form to work from. In addition there are several modal forms. Are you saying I should be using...
  32. Re: Chilkd form still jumping on resize

    OK ... for the record I think I figured it out. Im not going to mark this thread resolved just yet however ...

    for the properties of the child form:
    FormBorderStyle = None
    Window State = Normal...
  33. Re: Chilkd form still jumping on resize

    Thanks all for trying .. none of the suggestions will work for what I want to do. Leaving the child form sizable is definitely something I do not want although I guess I have no choice. If I make the...
  34. [RESOLVED] Chilkd form still jumping on resize

    This is driving me nuts. I posted this question not long ago and thought it was resolved but it is not. I can't figure out why this is happening but more importantly, I can't figure out how to make...
  35. Replies
    0
    Views
    699

    loop input question

    I'm just starting with C++ and I know this is a really simple newbie question .. but I can't seem to find or write anything that works the way I want. I've been programming in Basic since the early...
  36. Replies
    5
    Views
    321

    Re: Child Form Problem

    Thanks ... your earlier answer held the key though. For some reason setting the form property to maximize was not working. If, however, I added the line


    Me.WindowState =...
  37. Replies
    5
    Views
    321

    Re: Child Form Problem

    Well, there really isn't much code to show ...


    Private Sub ToolStripButton2_Click(sender As System.Object, e As System.EventArgs) Handles btnClients.Click

    frmAllClients.MdiParent =...
  38. Replies
    5
    Views
    321

    [RESOLVED] Child Form Problem

    I'm new to VB2010 but have some experience with VB6. Some things are very different but I've managed to create a MDI Parent and a child. The child has no border or control box with a graphic for the...
  39. Run secondary software from Install Shield 2012 installation package

    I think this is the right place for this question ... I hope I can explain it clearly enough.

    I've built an app in VB6 that uses crystal reports 11.5 and I'm trying to build an installation using...
  40. Re: Linking help file topic to button event

    I fiddled some more and got it sorted. There was something wrong with my compiled help file. I compiled it again and topics began to work. So things are sorted. Thank you for helping me!
Results 1 to 40 of 220
Page 1 of 6 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.