Search:

Type: Posts; User: si_the_geek

Page 1 of 13 1 2 3 4

Search: Search took 4.47 seconds.

  1. Replies
    3
    Views
    138

    Re: Depreciated Join Syntax

    You are correct, it is an Inner Join :)
  2. Replies
    2
    Views
    168

    Re: How to solve IO error?

    Instead of having this:

    Dim itemSize As Long= drive.TotalSize
    ...
    ListView1.Items(i).SubItems.Add(itemSize)
    You could do something like this:

    ...
  3. Replies
    1
    Views
    140

    VS 2017 Re: Check If Server is Online

    Rather than performing multiple steps like that, it would probably be best to just attempt to connect to it, using whichever method you would be connecting with (FTP or TCP or ADO.Net etc).
    ...
  4. Replies
    250
    Views
    19,367

    Re: Hamilton 5x World Champion ?

    I think that was the most impressive crash-fest for at least a decade!

    It's one of those races where you expect the minor players like Russell to do well (and that would have been great), but it...
  5. Re: [RESOLVED] DataGridViewCheckBoxColumn from SQL bit type

    The data is remembered because it not stored in the grid columns, it is stored in a DataTable (via the DataSource property of the grid). The grid just displays the relevant parts of the DataTable...
  6. VS 2015 Re: declaring "e" as BigInteger

    Most events (such as Button Click) have a parameter called e, and you cannot use the same name for a parameter and a variable.

    Depending on circumstances you might be able to rename the parameter...
  7. Replies
    250
    Views
    19,367

    Re: Hamilton 5x World Champion ?

    :lol:

    That's not how I feel about him (he does do bad things sometimes), but you've clearly got a strong opinion on this particular situation - and as you are much more aware of what happened than...
  8. Replies
    250
    Views
    19,367

    Re: Hamilton 5x World Champion ?

    The drivers do all kinds of things during red flags... my favourite was Kimi in a hot race, where he went to get his shorts on then grab an ice-cream. :D

    I don't know the timelines of what...
  9. Replies
    250
    Views
    19,367

    Re: Hamilton 5x World Champion ?

    Max's issue was "power unit", but that's all I found out with all the beeping when he talked - he wasn't a happy chap!

    Bottas apparently had damage from the first lap, which made his car much...
  10. Replies
    250
    Views
    19,367

    Re: Hamilton 5x World Champion ?

    Well that was a lovely race with lots of action all over the place, even the polystyrene blocks had some excitement!

    It was great to see that most people there (no matter which team) cheered the...
  11. VS 2019 Re: Adjusting an image (from Memory) to a PictureBox

    DrawImage has several overloads, and the one you are using (Image, RectangleF) "Draws the specified Image at the specified location and with the specified size." and "The image represented by the...
  12. VS 2019 Re: 10 Text Boxes differ by a number at the end of the name

    Welcome to VBForums :wave:

    I'm afraid you cannot access a control (or any other kind of object) just by building a string that represents the name of it.

    Thankfully however there is a built-in...
  13. Re: Hong Kong, Portland and the Moral Low Ground

    Yep, but you won the race we didn't know we were having :lol:
  14. Re: Hong Kong, Portland and the Moral Low Ground

    Yep, the world is finally waking up to various injustices and problems that have been brewing for a long time - and several of them are now making progress.

    The environment issues certainly...
  15. Re: Hong Kong, Portland and the Moral Low Ground

    The good news is that the message got thru to politicians before the pandemic, and they were starting to act... now that the world has changed (lots of jobs are currently gone or are "unsafe") there...
  16. Re: Hong Kong, Portland and the Moral Low Ground

    Greta has said that while the attacks on her aren't nice, it makes her feel good because it shows the message is getting through - and that is what matters. Many people (especially children and...
  17. Re: Hong Kong, Portland and the Moral Low Ground

    I don't see all protest as violent, but rather as attacks.

    There are various ways those attacks can happen, ranging from Greta Thunberg's non-confrontational style (which has yielded great results...
  18. Thread: vba6 error

    by si_the_geek
    Replies
    3
    Views
    325

    Re: vba6 error

    Welcome to VBForums :wave:

    Thread moved from the 'VB.Net' forum to the 'Office Development/VBA' forum. (which is the most apt forum we have for VBA)
  19. Replies
    49
    Views
    1,592

    VS 2019 Re: Old man needs help

    It turns out I made I mistake, this line:

    timeDiff.Add(New TimeSpan(24, 0, 0))
    ..should have been:

    timeDiff += New TimeSpan(24, 0, 0)
  20. Re: Hong Kong, Portland and the Moral Low Ground

    Does that mean the NBA would be a better president than Trump? :lol:

    Ah yes, I didn't read that part carefully enough "intend to" invite :sick:
  21. Re: Hong Kong, Portland and the Moral Low Ground

    Well there are some quite famous strikes happening apparently, for most major sports in the US (basketball, baseball, tennis, ...):
    https://www.bbc.co.uk/sport/basketball/53926764

    It has resulted...
  22. Replies
    49
    Views
    1,592

    VS 2019 Re: Old man needs help

    Welcome to VBForums :wave:

    An alternative way to do it is to just assume that a shift is a positive amount of time, less than 24 hours. You can then add 24 hours until the value is positive:
    ...
  23. Re: How to do dBASE string case insensitive (ignore case) search? VB6

    Depending on what built-in functions the database system has, one of these is likely to work:

    SQL = "SELECT * FROM PTDBF WHERE Ucase("LASTNAME") LIKE Ucase('" & SearchString & "')"

    SQL =...
  24. Re: If Not list.Contains(variable) not working

    You also set nxtNum twice, once before the If and again a couple of lines after it... remove the second line that sets it, and it will probably be fine.
  25. Re: Hong Kong, Portland and the Moral Low Ground

    I agree with the protestors (the police should be accountable, and avoid bad methods etc), I just think that there are too many people taking the protests too far - and in the process making things...
  26. Re: Hong Kong, Portland and the Moral Low Ground

    It's another messed up situation... the fact he is alive is obviously good (the long term damage to him isn't), but there is surprisingly little "official" information, and from the video I can't...
  27. Replies
    7
    Views
    363

    Re: Parameter Issues

    Welcome to VBForums :wave:

    The cause of the issue is actually likely to be something other than parameters.

    In many cases the issue is caused by a "bad" name for a field/table/query/etc,...
  28. Replies
    5
    Views
    474

    Re: Fill combobox with Sub

    dday9's suggestion uses more advanced methods that in some ways are superior to my suggestion - such as using AddRange to add multiple items at once (it runs faster, among other things needing fewer...
  29. Replies
    5
    Views
    474

    Re: Fill combobox with Sub

    Welcome to VBForums :wave:

    The way to do it is pass the combobox in as a parameter (similar to a variable, but the value gets passed in from somewhere else) and use the parameter inside the sub,...
  30. Replies
    1,420
    Views
    59,836

    Re: Corona virus, China major city lockdowns, etc.

    I don't know about that... I've just put on my blonde flappy wig and done the maths, it turns out that the US has the equivalent of 1.9 deaths in New Zealand. :ehh:
  31. Re: New Clustered Index already 50% fragmented

    An identity column will have sequential values, so new values are simply added to the end.

    Text-based data is not so predictable (values can be added that need to be between others), therefore...
  32. Replies
    4
    Views
    637

    Re: Automate some steps in IE, with VBA

    Welcome to VBForums :wave:

    Thread moved from the 'VB.Net' forum to the 'Office Development/VBA' forum.
  33. VS 2017 Re: Populating Labels From SQL Database

    One possible way to do it:

    ...
    dr = cmd.ExecuteReader

    Dim i as Integer
    Dim theLabels as Label() = {lbldate1, lbldate2, lbldate3, ... }
    ...
  34. Replies
    250
    Views
    19,367

    Re: Hamilton 5x World Champion ?

    Aero is certainly a major factor, but there are various other things under the hood they can change too (like suspension settings) that might help them. They will all probably have an effect on...
  35. Replies
    250
    Views
    19,367

    Re: Hamilton 5x World Champion ?

    The mixture of softer tyres and higher tyre pressure helped, and so did the heat... apparently the tyres will have a similar situation this weekend, so it could be good if the weather is right too.
    ...
  36. Re: Results rankings database Help Windows Forms Application, VB.Net

    The new schema looks good :thumb:
    In simple terms that would be fine, but unfortunately there have been times that drivers and/or constructors have been penalised for rule violations (such as...
  37. Replies
    250
    Views
    19,367

    Re: Hamilton 5x World Champion ?

    It is disappointing, but as they were all designing/building medical equipment for the pandemic, I'll forgive them!

    If I remember correctly, the new cars will only have about 20% of the current...
  38. Re: editing posts in quick reply

    It actually changed when the issues with double-posts etc were fixed, so I'm assuming that disabling it was part of solving the problems we had.

    It would be nice to have this back, but not if it...
  39. Replies
    250
    Views
    19,367

    Re: Hamilton 5x World Champion ?

    It was a good race with lots of good points, but certainly not in my top 30 or so races... thankfully with the new rules coming (now 2022) there should be much closer racing regularly from then on,...
  40. Replies
    6
    Views
    526

    Re: Loop not working

    Welcome to VBForums :wave:

    Thread moved from the 'VB.Net' forum to the 'Office Development/VBA' forum.
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width