Search Results - VBForums

Search:

Type: Posts; User: RobDog888

Page 1 of 12 1 2 3 4

Search: Search took 1.11 seconds; generated 4 minute(s) ago.

  1. Replies
    5
    Views
    100

    VS 2010 Re: DataTable Filtering

    Got it with this.


    DataTable dt = dsSTDDB.Tables["StandardCHP"].Copy();
    DataView dv = dt.DefaultView.ToTable(true, "chID", "chGrp").DefaultView;
    dv.RowFilter = "chGrp='C'";
  2. Replies
    5
    Views
    100

    VS 2010 Re: DataTable Filtering

    The "true" parameter is the distinct identifier in teh parameters

    DataView dv = dt.DefaultView.ToTable(true, "chID").DefaultView;

    I guess I could add the second column in hte list as I think it...
  3. Replies
    5
    Views
    100

    VS 2010 Re: DataTable Filtering

    Looking at copying the datatable and doing a .DefaultView.ToTable(true, "chID").DefaultView.RowFilter = "chGrp = 'C'" but its giving an error that it cant find the column but it does exist in the dt....
  4. Replies
    5
    Views
    100

    VS 2010 [RESOLVED] DataTable Filtering

    Ok so have looked into the DataView and read that its not going to do what I want as I already have a DT populated but have a situation where I now need to filter it with a DISTINCT query and WHERE...
  5. Re: Connecting to Excel 2010 with VB 6 lates service pack error

    Are you stepping through and debugging your code?

    Place a breakpoint on "Set xlApp = CreateObject("Excel.Application")" by pressing F9. Then run your app and when the code execution line hits your...
  6. Replies
    77
    Views
    2,559

    Re: GoTo is still alive!

    GoTo is essentially DEAD. Lets create a petition to bring it out into the forefront!
  7. Replies
    77
    Views
    2,559

    Re: GoTo is still alive!

    But thats what keeps things interesting!
  8. Replies
    205
    Views
    9,434

    Re: The State of VBForums

    Guess its time to :spam: then
  9. Replies
    1
    Views
    83

    Optimize Stored Procedure

    This resource intensive sp needs to be optimized. I got it working accurately so next up is to make it faster.



    CREATE PROCEDURE [dbo].[ChangeReport_DetectChange] (
    @RetVal INT OUT
    ) AS
    ...
  10. Replies
    27
    Views
    639

    Re: Cat team building

    Fixed :)
  11. Replies
    1
    Views
    93

    Re: VBA in excel - Search function

    Thread Moved from VB6 to Office Development (VBA) Forum.
  12. Re: Connecting to Excel 2010 with VB 6 lates service pack error

    And we are back :)
  13. Replies
    77
    Views
    2,559

    Re: GoTo is still alive!

    Naw, I'll let you continue to do the managing. :)
  14. Replies
    27
    Views
    639

    Re: Cat team building

    Cat Team Building:

    Topic VII - How to mark your territory in a competitive industry
  15. Replies
    27
    Views
    639

    Re: Cat team building

    Yes there is - Meow!


    Oh no, flashbacks to my infamous cat-astrophy thread :lol:
  16. VS 2013 Re: Converting h (C header file) to something usuable in vb

    Codeken, please read our terms of service as a new member you need to understand what the rules are for attachments. Youre zip attachment was blocked for download by my browser as malicious. Please...
  17. Re: Connecting to Excel 2010 with VB 6 lates service pack error

    No, now seeing this is .NET. The "Set" keyword is not needed/supported. Your example came from the VS 2013 .NET page.

    Perhaps you were meaning "Option Explicit" in your reference to your quotted...
  18. Replies
    23
    Views
    745

    Re: Posting a new thread question

    So soon there will be bot2?
  19. Replies
    77
    Views
    2,559

    Re: GoTo is still alive!

    I think MS supports VBA allot more than VB6 :lol:
  20. Replies
    77
    Views
    2,559

    Re: GoTo is still alive!

    You wouldnt have the budget for me anyways :)
  21. Replies
    21
    Views
    1,356

    MsOf10 Re: [RESOLVED] Display the File|Print Window

    No prob. But you actually see the backstage view in Excel 07?
    ...
  22. Replies
    21
    Views
    1,356

    MsOf10 Re: [RESOLVED] Display the File|Print Window

    I dont have 2007 at work but I believe this was new for Excel 2010.

    Edit: Yes for Excel its 2010+
  23. Re: Connecting to Excel 2010 with VB 6 lates service pack error

    Since this is a reference error due to the machine having a newer installation of Excel, the solution is either one of two: Downgrade Excel and install the older version OR change the code to reflect...
  24. Replies
    21
    Views
    1,356

    MsOf10 Re: Display the File|Print Window

    Here you go Martin:


    Application.CommandBars.ExecuteMso("PrintPreviewAndPrint")
  25. Re: Connecting to Excel 2010 with VB 6 lates service pack error

    As Wes stated, since you are using Early Binding you are stuck to a particular version of Excel. If a system has a newer or different version of Excel installed it will crash with an error like you ...
  26. Replies
    77
    Views
    2,559

    Re: GoTo is still alive!

    I just figured that since there has been so many negative thread about the death of this and bring back that etc that it may be nice to see that something so fundamental is still alive under the...
  27. Replies
    30
    Views
    1,674

    Re: Will .Net outlive us?

    +1,000,000
  28. Thread: MartinLiss

    by RobDog888
    Replies
    60
    Views
    3,579

    Re: MartinLiss

    Oh god no! lol
  29. Thread: MartinLiss

    by RobDog888
    Replies
    60
    Views
    3,579

    Re: MartinLiss

    "The Re-Animator!"
  30. Replies
    77
    Views
    2,559

    Re: GoTo is still alive!

    Police brutality!!!
  31. Thread: MartinLiss

    by RobDog888
    Replies
    60
    Views
    3,579

    Re: MartinLiss

    Thats like a Dr. bringing you back right after you die from an accident or such and then you only are back for a minute and end up croaking. :afrog:
  32. Replies
    23
    Views
    1,534

    Re: vb6 or vb.net ?

    More of an as compared to VB6 mobile development. Think all VB6 supports is the old depreciated CE 3.0 for the old Windows 6.5 OS platform
  33. Replies
    30
    Views
    1,674

    Re: Will .Net outlive us?

    I hope to be done developing in no more than 8 years max. Time to go outside and do things vs sitting behind a monitor all day never seeing the sun etc
  34. Thread: MartinLiss

    by RobDog888
    Replies
    60
    Views
    3,579

    Re: MartinLiss

    But you do not retain them. They come back, make a post and then leave. So still a fail lol
  35. Replies
    23
    Views
    1,534

    Re: vb6 or vb.net ?

    Another good point is in what you want to get out of it for the future? Programming for mobile devices is sooo much easier and with the support for Windows Phone 7 with .NET its just a hands down...
  36. View Post

    Because checking fields on a form is simply just passing the fields in a loop to the SpellMe function after you instantiate the clsSpellMe class. My initial example is just for one big "field" if you...
  37. Re: Microsoft VB Runtime Error '424' object required (Mircosoft Office Word 2013)

    If its only on one particular doc file then press Alt + F11 after you get it open to view the VBA code behind the document. All the variations of VB languages are quite verbose so you may be able to...
  38. Replies
    77
    Views
    2,559

    Re: GoTo is still alive!

    You need to include some entertaining pictures too
  39. Replies
    30
    Views
    1,674

    Re: Will .Net outlive us?

    It will outlive me thats for sure


    Correct
  40. Thread: Day Shift

    by RobDog888
    Replies
    41
    Views
    3,123

    Re: Day Shift

    More like 45 minute each way, no freeways just surface streets. Sucks cause I cant even drive my Cobra as will get pulled over definitely on the streets, the freeway I have no problems with the cops
Results 1 to 40 of 462
Page 1 of 12 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.