Search Results - VBForums

Search:

Type: Posts; User: TysonLPrice

Page 1 of 13 1 2 3 4

Search: Search took 0.11 seconds; generated 7 minute(s) ago.

  1. Re: Planet building. Not your mama's engineering project.

    I forgot about them....I remember the cartoon.
  2. Thread: subquery

    by TysonLPrice
    Replies
    6
    Views
    102

    Re: subquery

    I did too but one doesn't make any more sense than the other to me so I went with easy\ludicrous.
  3. Thread: subquery

    by TysonLPrice
    Replies
    6
    Views
    102

    Re: subquery

    I wonder why and you need to be more specific:


    select * from
    (select c.customername , c.customerid, sum(s.sales) sales
    from customers c
    inner join sales s on c.customerid=s.customerid ...
  4. Replies
    77
    Views
    2,742

    Re: GoTo is still alive!

    Yep that is it...that was a blast from the past. I haven't looked at that in since around 2002.
  5. Replies
    77
    Views
    2,742

    Re: GoTo is still alive!

    I'm guessing you mean CICS...what a leap forward to be able to just paint your screen and move controls around with the cursor. Like the old sheets you mentioned you had to map out all the starting...
  6. Replies
    77
    Views
    2,742

    Re: GoTo is still alive!

    How could I have been so wrong, and those brackets, who wouldn't want to have them in the code.

    Your are probably one of those people that like those god awful ugly dogs with the smushed in faces...
  7. Re: Text Box Accepting Decimals????????????

    There are a lot of ways to skin that cat and searching this forum will provide quite a few ways. Just a simple masked text box set to five digits is one way. That will only allow numbers to be...
  8. Replies
    77
    Views
    2,742

    Re: GoTo is still alive!

    While we are at it...could we bring back VB 6.0 :eek:
  9. Replies
    77
    Views
    2,742

    Re: GoTo is still alive!

    I really hope you don't mean syntactically...that part is just horrible to me. Case sensative and a boatload of quirks (quirks to me like = and ==). I'm definately prejudiced in favor of VB though.
  10. Replies
    77
    Views
    2,742

    Re: GoTo is still alive!

    I can appreciate what you guys are saying. Comparing programming back then to now is like going back to stone tools. But as I hear so many times it is just syntax. This is that program converted to...
  11. Re: Need some kind of ROW trick in a VIEW

    I'm not a SQL guru but I can't imagine what triggers have to do with updatable views?
  12. Replies
    77
    Views
    2,742

    Re: GoTo is still alive!

    I rarely use them because structured programming was the vogue when I got into the business. I'm not as rabid as some about never using them but you won't see me putting them into production. If I'm...
  13. Re: how to use vb6 dll in sql server 2012 ?

    It is hard to say without knowing what you are trying to do. Most of the time I use stored procedures to interact with VB 6.0 and MS SQL.
  14. Replies
    2
    Views
    112

    Re: My life coach the cockroach.

    Trust in Allah, but tie up your camel at night.
  15. Replies
    16
    Views
    492

    Re: How much is my website worth?

    Not really...
  16. Re: Planet building. Not your mama's engineering project.

    That tough but one thing I wouldn't build in is the food chain we have now. In a way this planet is a huge blood bath with everything eating everything else to survive; with few exceptions (most...
  17. Re: how to disable a user to change date if it is not the same month

    I recommend not using Now() when preventing something from happening. The user can just change the computers clock. Especially if it is important like logging or time keeping. Get it off a server...
  18. Replies
    13
    Views
    308

    Re: Access Denied

    Well I deleted my last post because I didn't want to start an argument in someone else's post. Can you do the same thing at work outside the application? I'm trying to determine where the lack of...
  19. Replies
    13
    Views
    308

    Re: Access Denied

    Edited..
  20. Re: Program kicks out after con.open() without error.

    Try pointing in some error checking and narrowing down the error.
  21. Replies
    13
    Views
    308

    Re: Access Denied

    Not necessassrily; companinies that enforce group policies can override all that. We do it quite a bit. And that doesn't change for one second what I was talking about. In a controled production...
  22. Replies
    13
    Views
    308

    Re: Access Denied

    That's assuming you don't work in a production environment and users control the rights to thier machines. I don't now how many thing that have worked on my machine but not when I rolled it out. ...
  23. Replies
    13
    Views
    308

    Re: Access Denied

    Do you understand you don't have access and that is the nature of the error or are you asking for a way around it. Do you have a common share where you can save the file?
  24. Re: Error : Microsoft Office Excel cannot open or save any more documents

    I would think that would only apply to the one active application. The task manager is the best tool I know for checking that.
  25. Replies
    3
    Views
    123

    Re: Passing varible from application

    Does:



    mean you are refering to a variable in a macro or is that a value in a cell?
  26. Re: Error : Microsoft Office Excel cannot open or save any more documents

    Just for grins look in the task manager and see if you have a lot of Excel.exes running. It looks like that blurb of code is cleaning up after itself but maybe something else you are doing has Excel...
  27. Replies
    1
    Views
    135

    A+ for effort and being irritating

    This made the national news; it is somebody trying to cancel his Comcast service. It goes on for at least ten minutes and it isn’t a joke. I wouldn’t have had the patience the guy calling in did.
    ...
  28. Replies
    13
    Views
    1,188

    Re: Quick question

    OMG you actually invited someone to start that conversation over :eek:
  29. Replies
    13
    Views
    1,188

    Re: Quick question

    It is what I would use.
  30. Replies
    77
    Views
    2,742

    Re: GoTo is still alive!

    goto hell
    goto the end of the line
    goto jail
    goto the first door on the right
    and never use goto
  31. Replies
    1
    Views
    326

    Re: Print to PDF or Excel

    I have time on my hands and am in a good mood. You could have easily used Google to try doing it for yourself and them posted issues you might be having. At any rate:

    Add a refernce to Excel...
  32. Re: [Excel]~~ Urgent! Please help me on coding for find data by VBA

    What about exporting the data to a database, manipulating it, and then writing it back to Excel?
  33. Re: [Excel]~~ Urgent! Please help me on coding for find data by VBA

    I don't know where it would lead but I would start by recording marcos sorting on colors and filtering by colors. That would at least group all the yellow together. I'm on Excel 2010 and that...
  34. Replies
    65
    Views
    3,444

    Re: What do you think about nicotine

    So what happened to the rest of the people in your world that weren't warned :eek:
  35. Thread: Day Shift

    by TysonLPrice
    Replies
    41
    Views
    3,461

    Re: Day Shift

    Sounds like I'd have to where a mask to work to do better than that. I've only worked in the private sector, they expect results...

    Ghostbusters:
    Dr Ray Stantz: Personally, I liked the...
  36. Replies
    3
    Views
    398

    Re: Insert into Statment Error

    Start by helping us to help you. Show us what the SQL looks like that is being passed to Access. We don't have a clue based on what you posted. I see that debug.print there. Show us that the...
  37. Replies
    3
    Views
    613

    Hackers at work

    I guess it could have been worse...

    "Florida Road Construction Sign Hacked To Show Extremely Vulgar Message"
    ...
  38. Re: Nested replace() functions: a better way?

    I'm assuming you mean SQL Server and just glancing at it you only want number? Here is a link to something you might be able to use:
    ...
  39. Replies
    5
    Views
    746

    Re: Execution plan? What about them?

    That's a pretty big topic and there are entire books dedicated to it. I recommend you use Google. I used the keywords

    sql server understanding execution plans

    and got quite a few hits.
  40. Re: If you are an athletic supporter please read:

    This is not a joke...we have a doctor on file named Richard Oder. Can you imagine the crap he took in high school?
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.