Search Results - VBForums

Search:

Type: Posts; User: TysonLPrice

Page 1 of 13 1 2 3 4

Search: Search took 0.07 seconds.

  1. Re: How to handle Excel Spreadsheet formats issues

    You really don't need to wait until a big project is done to test it in a certain place. For example just open up a new project, hard code the values in variables, and test diffierent conversions...
  2. Re: How to handle Excel Spreadsheet formats issues

    Tough not to be a smart *** on that one :bigyello:

    Try it and see.
  3. Re: How to handle Excel Spreadsheet formats issues

    You can convert it as needed when you do the comparisons.
  4. Re: I think I'm about to have a nervous breakdown

    I'm interested in aerodynamics so I thought I'd start out by launching a rocket :o
  5. Replies
    17
    Views
    249

    Re: editing 2 tables at once

    A quick Google search indicates you can in at least Access 2010. Based on the OP's post I don't think the familiarity of them is there. The logic sure seemed to be a candidate for set based...
  6. Re: How to handle Excel Spreadsheet formats issues

    I can only speak to MS SQL Server, but yes. I'm pretty sure that would be true across the board. My thought was the leading zeros are stripped because the database type was numeric. Is that the...
  7. Replies
    7
    Views
    162

    VS 2012 Re: Duplicate in Two tables

    I think you have that a little backwards as far as what I was suggesting. I'm against turning identity on and off for maintenance as simple as that. I suggested not using the same primary key in...
  8. Replies
    17
    Views
    249

    Re: editing 2 tables at once

    That sure looks like a candidate to be a stored procedure. Have you considered that?
  9. Re: How to handle Excel Spreadsheet formats issues

    Maybe I'm over simplifing but it sounds like the DB column is a number and should be character...
  10. Re: Need help : Get Autonumber after adding record

    How are you adding the new record (I'm assuming it is in VB but stored procedure, recordset, etc.)
  11. Replies
    7
    Views
    162

    VS 2012 Re: Duplicate in Two tables

    I'm guessing this goes back to this link. In my opinion you started off on the wrong foot. Check out my last post.
    ...
  12. Replies
    10
    Views
    224

    VS 2012 Re: [RESOLVED] Copy data between tables

    It is obvious there is some disagreement here but to me when you are shutting identity inserts off and on in a simple maintenance scenario you have lost your way. Here is what I would do:


    ...
  13. Replies
    10
    Views
    224

    VS 2012 Re: [RESOLVED] Copy data between tables

    I don't think changing the identity insert helps if the key is already populated. That is for inserting unused keys I think. You may want to rethink what you are doing. It is not recommended to...
  14. Re: how to restore sql 2005 database to sql 2014

    How about some specific errors? The reason I ask is some things in 2005 no longer work in 2014. I know there are conversion reports that will list the issues. Maybe that is something you can look...
  15. Replies
    10
    Views
    224

    VS 2012 Re: [RESOLVED] Copy data between tables

    Does the row you are inserting already have a pk value?
  16. Replies
    5
    Views
    179

    Re: stop server

    I don't know what you really want to do but look at the SHUTDOWN command.

    http://msdn.microsoft.com/en-us/library/ms188767.aspx

    I'm guessing it wouldn't be considered a "best practice" though...
  17. Re: Dynamic SQL generation is not supported against multiple databases

    I didn't dig that deep but a cursory Google searched came up with:


    That is from here:
    ...
  18. Re: Passing enum variable at the sql statement

    Have you considered keeping the value in the combo box and getting it from there?
  19. Replies
    21
    Views
    278

    Re: Net neutrality

    This is cute:

    Senator Ted Cruz:

    "Net Neutrality" is Obamacare for the Internet; the Internet should not operate at the speed of government.
    10:43 AM - 10 Nov 2014

    This is a quick read of...
  20. Replies
    21
    Views
    278

    Re: Net neutrality

    One thing I mentioned but I like to reiterate is the carriers are using what can be considered public property and subsidies. I thinks that ups the ante for our stake in this.
  21. Replies
    21
    Views
    278

    Re: Net neutrality

    Well there absolutly is and one is the American voter. The problem with that is, for the most part, it is a farce on a number of levels starting with what someone else mentioned about voters being...
  22. Replies
    21
    Views
    278

    Re: Net neutrality

    Very good points but part of what you are saying, if I understand correctly, is who do you trust, market forces or the governent? Just because the market forces haven't put it to us yet doesn't mean...
  23. Replies
    21
    Views
    278

    Re: Net neutrality

    I was refering to his qualifications for the job not the subject. But I think he is probably better versed on the subject then most. Regardless of where his loyalties lie...

    I can't take the...
  24. Replies
    21
    Views
    278

    Re: Net neutrality

    FCC chairman Tom Wheeler is a former lobbyist for the cable and telecommunications industry. He has also made a career of cable and wireless industry. He disagrees with Obama's approach.
    ...
  25. Replies
    21
    Views
    278

    Net neutrality

    That's not a new topic but it is front and center at the moment with President Obama jumping in with support for it. I'm trying to familiarize myself with the subject. I found a link that is...
  26. Replies
    17
    Views
    277

    VS 2013 Re: Vb.net Exception help required urgent!

    The operative words are "server should have" :o

    Can you really count on that? I don't know what kind of environment you are in but I prefer copying off the data regardless if it is going to be...
  27. Thread: I'm back.

    by TysonLPrice
    Replies
    16
    Views
    365

    Re: I'm back.

    The Mayan calendar apocalypse fizzled out...
  28. Replies
    35
    Views
    713

    Re: Removing lice from a pigeon

    Lethal Weapon 4

    It's fried rice you plick...
  29. Replies
    35
    Views
    713

    Re: Removing lice from a pigeon

    That's a strange duck indeed...
  30. Replies
    2
    Views
    124

    Re: SQL Left Outer Join Problem

    Not asking why you are trying to do that, just answering your question about how to get all three records without a UNION this works:



    If object_id('tempdb..#TableAll') is not null drop table...
  31. Replies
    35
    Views
    713

    Re: Removing lice from a pigeon

    Or you could just "stick your head in the sand" and ignore posts you don't approve of. I'm just yolking around here...
  32. Replies
    17
    Views
    277

    VS 2013 Re: Vb.net Exception help required urgent!

    FunkyDextor posted a viable solution but I personally shy away for handling errors like they are "technically" OK. In this case if you can't get exclusive control, assume FTP has it, you will pick...
  33. Replies
    17
    Views
    277

    VS 2013 Re: Vb.net Exception help required urgent!

    I think you are always going to have access issues as long as the file can come in at any time and FTP has exclusive locks. I may not be able to help you. We have software where we set up an "FTP...
  34. Replies
    17
    Views
    277

    VS 2013 Re: Vb.net Exception help required urgent!

    It amazes me you are just mentioning that now :o

    One thing you can do is before you start the DB copy process check is to make sure you have exclusive control of the folder. I can find a link if...
  35. Replies
    17
    Views
    277

    VS 2013 Re: Vb.net Exception help required urgent!

    Yeah...that really answered my question :rolleyes:

    I'm guessing it is the delete. I removed the DB code and put in a using to eliminate the dispose. My guess is something really does have the...
  36. Replies
    17
    Views
    277

    VS 2013 Re: Vb.net Exception help required urgent!

    What line of code generates the error...
  37. Re: [RESOLVED] Restrict app use once a month

    Got ya...kind of like Ada Lovelace :)
  38. Re: Restrict app use once a month

    Are you saying you don't think they are not savvy enough to change the clock on their computer to get around these checks? That seems to be a prerequisite of how you are setting this up.
  39. Replies
    35
    Views
    713

    Re: Removing lice from a pigeon

    Your not going to fly the coop on us are you? I'd hate for you to think your post went south.
  40. Re: Can I install VB6 IDE in a Windows 2012 R2 Server?

    I would just try it. Last feedback I got from a Microsoft rep was he didn't know if the run times were supported or not. You'll be breaking new ground as far a I know. Make sure you click "run as...
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.