Search Results - VBForums

Search:

Type: Posts; User: FunkyDexter

Page 1 of 13 1 2 3 4

Search: Search took 0.09 seconds; generated 45 minute(s) ago.

  1. Replies
    3
    Views
    84

    Re: Select/Insert Array Query

    The easiest way to insert where something doesn't exist is to insert from a select and put a where clause on the select:-



    Insert into t_Makes (Make)
    Select 'Nissan'
    Where Not Exists
    ...
  2. Re: Need to get an average from dataset columns

    That's not quite true. It sounds like your datagridview is "tied" (I think you probably mean "bound") to a DataView that's generated from an ADO DataTable. Nb NOT a table in the database but rather...
  3. Re: Need to get an average from dataset columns

    ...then you'll probably make a good programmer.

    We're going to need some more info before we can help though. You've said that the form has a database attached but that doesn't really mean much. ...
  4. VS 2008 Re: Microsoft.ACE.OLEDB.12.0 provider is not registered error help

    You'll certainly get that error if you haven't got the driver installed but you might also get it even if you have.

    There is a 32 bit and a 64 bit version of Ace driver and the two are...
  5. Thread: Post Race!

    by FunkyDexter
    Replies
    58,466
    Views
    2,143,840

    Re: Post Race!

    Does that mean you've got one grotty buttock?
  6. Replies
    7
    Views
    162

    Re: LIKE in SQL

    I'll be honest, I'm still not 100% clear on your goal but I'll take the best punt I can.

    If you just want a then that's an equality, not a like. so you would just put: WHERE parts = 'a' (n.b. no...
  7. Replies
    7
    Views
    162

    Re: LIKE in SQL

    You need to use the wildcards apropriately. % means "any number of characters" so if you say "Like %Davies" you're saying "anyone that has a name ending Davies". Andy Davies meets that criteria so...
  8. VS 2008 Re: Whats wrong with this class that connects to Mysql DB?

    You should. The point of connection pooling is that the connection isn't actually closed when you release it. It's just released back in to the pool where it can be reused. If it sits unused in...
  9. Set default application folder for plug in msi based on existing application path

    Hi All

    I've got an application that uses plug-ins to represent different flavours of sql (e.g. MySQL, PostGres, SQLServer etc.). The intention is that further flavours of SQL will be supported by...
  10. Thread: Post Race!

    by FunkyDexter
    Replies
    58,466
    Views
    2,143,840

    Re: Post Race!

    You do know you can empty those and refill them don't you? You don't have to keep using the same water.
  11. Replies
    7
    Views
    164

    Re: User Control being "truncated"

    :lol: It's fair cop, guv. I wasn't expecting to have to post code when I started the thread so I went with the busier VB forum.
  12. Replies
    7
    Views
    164

    Re: User Control being "truncated"

    Win 7.

    Already tried that. Turning VS off and on again fixes an uncomfortable number of mysterious behaviours:rolleyes:

    I've got a vague memory of something like this no a project I worked on...
  13. Replies
    7
    Views
    164

    Re: User Control being "truncated"

    There are no UI Customizations in the man file.

    Here's the designer code:-

    partial class ConnectionStringBuilder
    {
    /// <summary>
    /// Required designer variable.
    ...
  14. Replies
    6
    Views
    209

    Re: Global (System Wide) Hotkeys HELP

    I took a look at the MineCraft EULA and it doesn't appear to prohibit autoclickers although individual servers may prohibit them and many consider their use to be cheating. It's a grey area but...
  15. Replies
    7
    Views
    164

    User Control being "truncated"

    I have a user control on a form and the bottom of it is getting lopped off for some reason.

    Here's the user control in the designer:-
    121789

    And here's how it appears when added to a form. ...
  16. VS 2008 Re: Whats wrong with this class that connects to Mysql DB?

    Looks pretty reasonable but I'd offer a couple of bits of criticism.

    1. Classes should be named as nouns, not actions. Actions should be methods in the class. Rather than call it...
  17. Replies
    3
    Views
    189

    Re: How to join in Garena by VB6 code?

    Thread moved. The code bank forums are for submissions rather than questions.
  18. Re: Insering a graphical character in a listview column

    Thread moved. The code bank forums are for submissions rather than questions.
  19. Replies
    6
    Views
    209

    Re: Global (System Wide) Hotkeys HELP

    It's not so much that they're not allowed but rather that they're often used for malicious purposes and that's not allowed.

    KShadow22, I've taken a look at your threads and the questions you're...
  20. Re: How many bytes in memory a string occupy in Java language?

    Thread moved. The code bank forums are for your code submissions rather than questions.
  21. Replies
    5
    Views
    261

    Re: Inactive Command Buttons

    Moved. You're much more likely to get a decent response if your thread is in the right forum.
  22. Thread: Post Race!

    by FunkyDexter
    Replies
    58,466
    Views
    2,143,840

    Re: Post Race!

    Looks like your in a nice area. Lots of green out the back.
  23. Re: Future value question that I'm stuck with!

    Merged. It might not have been obvious but you didn't need to create a new thread. I'd already place your existing thread in the correct forum.
  24. Re: [RESOLVED] VB6: SQL SELECT Statement Syntax Error

    Here's a DAO parameter object. They're not specific to ADO.

    I'm with TG, I'd pretty much never let a Select * in production code. It's good for ad-hoc querying but production code doesn't just...
  25. Re: VB6: SQL SELECT Statement Syntax Error

    I can 't see any way of tightening up the SQL (it's a straight select with Where clause from a single table so there's not much room for different aproaches) but you might want to consider using...
  26. Replies
    463
    Views
    13,204

    Re: Christmas In July!

    FShhhhhhhhhhhhhhhh
  27. Thread: Ferguson

    by FunkyDexter
    Replies
    61
    Views
    1,489

    Re: Ferguson

    I actually agree which is an unusual position for me where this sort of thing is concerned. I can understand peoples reticence, particularly given some of the other videos that have made it onto the...
  28. Re: Future value question that I'm stuck with!

    Moved

    PJim, you actually attemtped to post this in several forums (none of which was the office forum) and in another user's thread. Please take a little care to make sure any questions you post...
  29. Thread: Ferguson

    by FunkyDexter
    Replies
    61
    Views
    1,489

    Re: Ferguson

    Depends what you mean by that. He'd verbally resisted in so far as he'd protested that he shouldn't be arrested. He hadn't physically resisted in any way. From what I understand selling of...
  30. Replies
    13
    Views
    223

    Re: What are you listening right now?

    A conference call next door that I probably shouldn't be listening to.
  31. Thread: Ferguson

    by FunkyDexter
    Replies
    61
    Views
    1,489

    Re: Ferguson

    I genuinely don't know whether it had nothing to do with race but I do agree with your assertion that we shouldn't automatically make the assumption that it was. However, given the fact that there...
  32. Thread: Ferguson

    by FunkyDexter
    Replies
    61
    Views
    1,489

    Re: Ferguson

    Now there I would agree with you but as I've said several times in this thread, the riots are not a response to the Ferguson shooting. They're a response to years of frustration built up by a real...
  33. Re: ExportAsFixedFormat Not Working on All Machines

    Thread moved to Office section as this deals with Office Automation.

    I'm not sure but I think you're probably falling foul of either the heightened security measures that were introduced in Vista...
  34. Thread: Post Race!

    by FunkyDexter
    Replies
    58,466
    Views
    2,143,840

    Re: Post Race!

    ]Yeah, that drives me nuts too.
  35. Thread: Ferguson

    by FunkyDexter
    Replies
    61
    Views
    1,489

    Re: Ferguson

    No I didn't, I did the exact opposite. I said that if her reaction would have been different if the kid were white then it would be racism. I didn't explictely say that if her reaction wouldn't...
  36. Thread: Ferguson

    by FunkyDexter
    Replies
    61
    Views
    1,489

    Re: Ferguson

    DD, I think Garner was the victim, not the officer. Have I go that wrong? Anyway...

    Yeah, that was pretty much how I saw it. Race may have played a part but I didn't see anything in the video...
  37. Thread: Ferguson

    by FunkyDexter
    Replies
    61
    Views
    1,489

    Re: Ferguson

    I don't think there's any implication that you should take some sort of morbid pleasure in it but if we're going to comment on whether it was right, wrong, racially motivated or just normal policing...
  38. Thread: Ferguson

    by FunkyDexter
    Replies
    61
    Views
    1,489

    Re: Ferguson

    No and I really should have made the effort by now.

    It's an interesting take on it but there's some truth there. As I've said, though, I don't think they're really rioting in response to this...
  39. Replies
    3,236
    Views
    128,601

    Re: The Golden Chair

    Well, it's my rut and I'm comfortable in it.
  40. Replies
    152
    Views
    6,190

    Re: Frickin' Lasers for Eyes!

    I'm not the only one either.

    I may get to the point of involving lawyers etc. but would rather get second opionions first. I want to understand exactly how much I lost and whether or not that...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.