Search Results - VBForums

Search:

Type: Posts; User: SparrowHawk7

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    1
    Views
    467

    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...
  2. Replies
    1
    Views
    467

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

    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...
  10. Replies
    6
    Views
    852

    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...
  11. Replies
    6
    Views
    852

    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...
  12. Replies
    6
    Views
    852

    [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...
  13. 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...
  14. 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...
  15. 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.
  16. [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...
  17. Replies
    4
    Views
    247

    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...
  18. Replies
    4
    Views
    247

    [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>"...
  19. 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
  20. [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...
  21. Replies
    4
    Views
    404

    Re: Get Record Count

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

    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.
  23. Replies
    4
    Views
    404

    [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...
  24. Replies
    5
    Views
    386

    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!
  25. Replies
    5
    Views
    386

    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...
  26. Replies
    5
    Views
    386

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

    Thank you! That was it.
  28. [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...
  29. Replies
    2
    Views
    536

    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....
  30. Replies
    2
    Views
    536

    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...
  31. 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.
  32. 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...
  33. 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...
  34. [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...
  35. Re: compacting 2010 accdb database using VB 2012

    Then an mdb format?
  36. 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...
  37. 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...
  38. 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.
  39. 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...
  40. 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...
Results 1 to 40 of 228
Page 1 of 6 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.