Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: graabein
  • Order by date
  1. graabein

    Stop trimming text fields

    Problem solved (not really). When I export to Excel the whitespaces appear so it was just the HTML rendering that fooled me. If somebody finds a solution to this I'm still interested in knowing it. There are times you want to control screen rendering also. [elephant2] graabein
  2. graabein

    Stop trimming text fields

    Incredible. I even tried selecting everything into a single text column from the database but SSRS still trimmed multiple whitespaces within the table cell! Somebody shoot me! LOL. [elephant2] graabein
  3. graabein

    Stop trimming text fields

    Hi, I have to create a text file that outputs data in certain chuncks like this: Name, 10 chars [1-10] Number, 2 chars [11-12] Code1, 3 chars [13-15] Code2, 3 chars [16-18] I put all the fields from the dataset next to eachother in a single table cell and the idea is to let the user export to...
  4. graabein

    Help with debugging database bug

    Not yet. Been busy working on another project. I've bookmarked this page for later reference. [elephant2] graabein
  5. graabein

    Count distinct values on sevaral fields

    LOL nice coincidence! Thanks man. [elephant2] graabein
  6. graabein

    Count distinct values on sevaral fields

    I think I did it! Check this out: select Work.Code, count(*) from ( select Code1 as Code from table1 union all select Code2 as Code from table1 ) as Work where Work.Code is not null group by Work.Code What do you think? [elephant2] graabein
  7. graabein

    Count distinct values on sevaral fields

    Hi, I have a sort of stupid table structure on the project I inherited. It's a list of what work was performed that uses codes like this: CustomerID | Date | Code1 | Code2 | Code3 | Code4 I want to know all work that was performed for a certain period and thus need to count the distinct codes...
  8. graabein

    Help with debugging database bug

    Thanks Joe, I'll update my code with that. Another thing, can I get the line number with Erl? error_handler: Dim errNum As Long Dim errDesc As String Dim lineNum As Long errNum = Err.Number errDesc = Err.Description lineNum = Erl [elephant2] graabein
  9. graabein

    Help with debugging database bug

    The bug occurs in production and I can't recreate it on my development environment. [elephant2] graabein
  10. graabein

    Test if a list of dates is sorted

    Well I'm trying to write some tests to run on the code (not written yet). They're not registrations of the same thing, they're a series of events connected with a bigger operation so we need to know what happened when for later on. Some of these events have to be in the proper order. Thanks for...
  11. graabein

    Help with debugging database bug

    Thanks, I have mztools installed but wasn't aware of Erl! [elephant2] graabein
  12. graabein

    Help with debugging database bug

    Hi, I'm looking for some advice on cornering an annoying bug I cannot recreate! I'll just paste the code here: Public Sub CreateView( _ lv As ListView, _ lvTemp As ListView, _ dtFromDate As Date, _ dtToDate As Date, _ Optional sFilter As String = "" _ ) Dim rs As New...
  13. graabein

    Test if a list of dates is sorted

    The user registers a list of dates. I want to see if they are in order. [elephant2] graabein
  14. graabein

    Test if a list of dates is sorted

    Here is what I've got so far but it's probably not the best way to go about this. Suggestions are welcome! private bool IsSorted(ObservableCollection<CustomEntity> coll) { List<DateTime> unsorted = (from n in coll where n.EventDateTime > DateTime.MinValue select...
  15. graabein

    Test if a list of dates is sorted

    Hi, I'm pretty new to C# .Net 3.5 so go easy on me... I want to test if a list of dates is sorted. I use LINQ to extract the DateTime field from a ObservableCollection<T> with either ToArray or ToList. I do this twice, with and without orderby clause. The (simple?) problem is how do I compare...
  16. graabein

    Package &amp; Deployment Wizard looking for &quot;3&quot;

    Hi, I'm trying to build a setup program for my application. The Package & Deployment Wizard keeps asking for file "3". When I look at the project references I can see two references to *.DLL\3: Visual Basic runtime objects and procedures C:\WINDOWS\system32\msvbvm60.dll\3 Microsoft VBScript...
  17. graabein

    Find code for trapping line break

    Yes! I finally found the source of my problems, namely the DefaultCancel property on the user control. That's seven or eights hours I'll never see again. [elephant2] graabein
  18. graabein

    Find code for trapping line break

    I think I might have used subclassing on the user control or maybe used a picture or a button to get the enter key event. I tried adding a multiline textbox on the main form and that worked as intended with enter key. In the user control however the enter key does not work on the multiline...
  19. graabein

    Find code for trapping line break

    Hello everyone! I have the strangest problem. In my main form I somehow trap linebreaks in textboxes with MultiLine = True. Problem is I don't know where this code is! It's a pretty old application... On a new form I added (a dialog box) this input filter trap key magic is non existing...
  20. graabein

    Problems with ListView.Visible and focus

    I think I'll try remembering the previous selected row, do a HideSelection and SelectedItem = Nothing, then reset the selected row while rebuilding (or after) and do HideSelection = False when I'm done. If that don't work and the selected row jumping still bothers me I'll try your tip [peace]...

Part and Inventory Search

Back
Top