Search:

Type: Posts; User: techgnome

Page 1 of 13 1 2 3 4

Search: Search took 1.39 seconds.

  1. Replies
    4
    Views
    62

    Re: Jet SQL: Insert Null FK?

    Which is exactly what I did... :D

    hmmm.... I see your point...

    -tg
  2. Replies
    4
    Views
    62

    Re: Jet SQL: Insert Null FK?

    Don't use MAX() ... there's no reason to. Fillings is unique... so you're not going to get more than one... you will get one or nothing...

    -tg
  3. Re: WebBrowser not loading the page correctly

    The WebBrowser control uses IE7 compatibility ... odds are the website is relying on newer capabilities.... Search the forums for IE Compatibility registry setting - it's a matter of changing a...
  4. Replies
    27
    Views
    323

    VS 2015 Re: Calculations not calculating? VBS 2015

    Ummm..... I was using the aggregate, collective "we" ??? :D
    That's my story and I'm sticking to it.


    -tg
  5. Replies
    27
    Views
    323

    VS 2015 Re: Calculations not calculating? VBS 2015

    No, nearly all of us here are either professional developers, owners, or hobbyists in one form or another... development is what we do for a living or fun... I don't think any of us are instructors...
  6. Re: Using public type as input parameter for function

    What you can do:
    Declare variables in a module and use them.
    Declare variables in a sub an use them.
    Declare variables in a module and sub and use them.

    What you CAN'T do:
    Declare variables in...
  7. Re: Delete the last item in listview

    Of course it didn't work... because that's not right... and if you debugged it, you'd see why.

    What do you think this does:


    lvw.ListItems(idx).Checked

    Because I know what it does. It...
  8. Replies
    23
    Views
    378

    Re: Notorius R.B.G ... RIP

    I caught a news report that gave a run down of the potential candidates - all women ... At first I thought maybe it was an attempt to fix the "Grab 'em" problem... then I realized it's an end run...
  9. Replies
    17
    Views
    276

    VS 2017 Re: Importing CSV Strings as numbers

    Yeah,I had issues a few years back is Student IDs where ' solved the issue... at this point, I'm inclined to think about dumping ADO and using TextFieldParser at this point... I've had greater...
  10. Replies
    17
    Views
    276

    VS 2017 Re: Importing CSV Strings as numbers

    I didn't miss it, I just also know Excel does weird things... which is why I wondered what the raw CSV looked like...



    And it looks like this... OK great... Just for fun... And I know that you...
  11. Replies
    17
    Views
    276

    VS 2017 Re: Importing CSV Strings as numbers

    Look at the CSV directly... what's in it? Don't guess what's in it... know what's in it.

    -tg
  12. Replies
    23
    Views
    378

    Notorius R.B.G ... RIP

    It's like someone said, "Well, it can't get any worse."
    And the universe said "Challenge accepted! Death... find a soul to take and make its loss a deep and dark bottomless source of suck."
    And...
  13. Thread: Thanks....

    by techgnome
    Replies
    19
    Views
    544

    Re: Thanks....

    Also some of us have been on the forums long enough to remember parksie ... ::duck:

    We've all had our dark days... and in these strange times, we need to make sure we're taking care of ourselves...
  14. Replies
    7
    Views
    300

    Re: Parameter Issues

    It's using a different style... it's the same as recordset!fieldname... which works well enough, but can have some limitations.

    But... that does make me think of something. Are all the parameters...
  15. Re: Find value that is not included in a group of rows.

    I think you were close with that last one... but here's why it didn't work:
    your CTE is sourced by the table for all records with 'BankResponseRaw' ... So that includes row 1.
    You're then selecting...
  16. Replies
    7
    Views
    300

    Re: Parameter Issues

    To be fair, until we know what the errors are, we can't rule anything out. We also can't rule out the nature of the queries... like you mentioned. SharePoint is horrible to work at times and only...
  17. Re: Running code against Sqlserver worked fine first time but now 'Access denied'

    Couple things:
    1) Why would you have a user folder on the server?
    2) Even if you did, you're not the "user" on the server, the service is... it doesn't have the same context, so your user folder...
  18. Re: 2 projects in solution vut can't debug one of them

    I always forget... and then I'll have to add it twice more (because I'll screw it up the first time and re-add the DLL) ... you do that enough times, you remember these little things.

    -tg
  19. Re: [RESOLVED] SQL - Query to list all year-to-date weeks and sum up occurrences of t

    1) He's already got the week number in the database, so it doesn't need to be recalculating it in the code.
    2) Jeezes... what's wrong with a table with the numbers in it like that, especially for...
  20. Thread: ADO on Lan

    by techgnome
    Replies
    17
    Views
    412

    Re: ADO on Lan

    Through the connection... you establish a connection to the server and issue commands through it, the results come back through that connection.
    Same as how a web browser connects to a web server,...
  21. Re: 2 projects in solution vut can't debug one of them

    Remove the reference.... then Add Reference.... BUT... switch to the projects tab... and select it from there ...
    What's happening is that you're addding the reference to the DLL, but there's no...
  22. Replies
    5
    Views
    233

    VS 2017 Re: Issue with JSON POST using WebClient

    It's possible it's solely a problem on their end....you're getting a 500 internal Server Error... not a bad request... so your request is being accepted, but then something fails on their end. ...
  23. Re: Running code against Sqlserver worked fine first time but now 'Access denied'

    OK, writing files to anywhere in the Program Files is a bad idea... MS has increasingly locked down that folder over the years to prevent users & apps from shooting themselves in the foot. Ideally,...
  24. Thread: ADO on Lan

    by techgnome
    Replies
    17
    Views
    412

    Re: ADO on Lan

    IP addresses change... server names tend to be more static. Plus also if one machine physically needs to be swapped out, using a named server is the way to go.
    As for deleting the mdb file ... 1)...
  25. Thread: ADO on Lan

    by techgnome
    Replies
    17
    Views
    412

    Re: ADO on Lan

    Not to mention good old fashioned proofs of concept - make sample projects and try them out.

    -tg
  26. Re: [RESOLVED] SQL - Query to list all year-to-date weeks and sum up occurrences of t

    That's not a problem either - he's already got a field for it in the database and storing it... so it's already been calculated and stored.


    Meanwhile *I* have concerns that he has two dates, and...
  27. Thread: ADO on Lan

    by techgnome
    Replies
    17
    Views
    412

    Re: ADO on Lan

    Did I miss something? When did we get to Disneyland?

    -tg
  28. VS 2017 Re: Advice On Storing Member Data in Text Files

    Yeah, thanks... while I somtimes post booby trapped code to prevent blind copy-pasta w/o understanding what the code does, that was not the case here. I didn't have access to VS at the time, so I...
  29. Replies
    1,421
    Views
    57,691

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

    So this happened...


    You know what else? If you then take out the red states, it's at an even lower rate!

    -tg
  30. VS 2017 Re: Advice On Storing Member Data in Text Files

    Ooof.... that's some.... needlessly complicated code...





    Code:

    Public Class Form1
    Private gridDataTable As New DataTable
  31. VS 2017 Re: Advice On Storing Member Data in Text Files

    Yikes...
    What is the source of this file then? Is it something in your control? The assumption was thaat your app was what created and maintained it... now... I'm not so sure.

    I'm going to toss...
  32. Re: vs 2019 vb.net .vb How can I clone my project under a new name ?

    I'd still be leary of using your local dev machine as the "remote" repo ... things happen. And this is 2020, which does not have a great track record at the moment (I mean we're 9 eps deep and it's...
  33. Thread: file locked

    by techgnome
    Replies
    4
    Views
    171

    Re: file locked

    Huh? What string?
    No... you CATCH the SPECIFIC exception:


    Catch ex As IOException
    ' Replace this with your cached file here
    Console.WriteLine( _
    "{0}: The write operation...
  34. Thread: file locked

    by techgnome
    Replies
    4
    Views
    171

    Re: file locked

    Use a Try Catch....with two Catches ... the first being for the specific exception of a locked file, the second being for the generic exception ... handle the opening of the cached file in the first...
  35. VS 2019 Re: All possible combinations in an integer array

    No... I'm not playing your game. You were given a list of acceptable responses to choose from. Since you couldn't understand English enough to get that, I'm not biting. I'm beginning to think you're...
  36. VS 2019 Re: All possible combinations in an integer array

    Sooooo.... do you want ONE combination or ALL combinations? Simple question really. I'm not sure what was so hard to understand about it. IT seemed pretty clear from the get-go to me. And yet, your...
  37. Replies
    10
    Views
    283

    Re: Date comparison between DB Access fields

    Example it is you want? OK. An example you shall have. We run a service off an AWS data center that's located who knows where... And it's a pain sorting through the logs looking for something,...
  38. Replies
    22
    Views
    843

    Re: Contest 14 - DnD Dice Roller

    IT depends on the die manufacturer.... I've got some that have the tens on them... others that have an odd colored 1d10 with just simple 0-9 on it... to be used as the tens... There is also a massive...
  39. Re: [RESOLVED] SQL - Query to list all year-to-date weeks and sum up occurrences of t

    They will appear if they in either query... if there is a weekNum is missing from both, then it will not show.

    -tg
  40. Re: SQL - Query to list all year-to-date weeks and sum up occurrences of tasks for a

    You need the total number of the tasks submitted fopr each weeknum:


    Select NG.SubmittedDate_WeekNum As Weeknum,
    Sum(Case When NG.Classification ='Major' then 1 else 0 End) As SubmittedMajor...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width