Posts by Stuugie

My own opinion, which may or may not mean much is this; you are doing too much! Even your 9 to 5 job there is just too much for one person. Depression over one's work is a field of study on its own but without going into that too much I'd like to know, what is your working title at the 9 to 5?

Another thing I would like to know so that I don't presume is what is your education background? You stated you were in the right spot at the right time and was therefore "lucky" to get that position but it's my opinion that the educated person is not "lucky", they work for theirs. If not formally educated then I would say that you've fallen into one of those work traps where an employer feels they do dump anything on you and you won't say no because you are "lucky" to have that job anyways. I've been there, won't do that again.

Anyhow, I think you are depressed about your jobs because you are burnt out, which happens to many who work too much. If I was you, I would reduce some of my 9 to 5 duties by delegation or some other means and I would get rid of the after hours work. Or, do the after hours work instead of the 9 to 5. You really should pick one or the other. With some free hours outside of work, enjoy yourself. You have just this …

How can you expect anyone to know something like that and that they would be able, or willing, to just provide it all in one go? I would imagine that there would be many lines of code involved and they would be personal to a particular inventory control system. What have you got/done so far? Wow.

Archer, not a movie but damn funny imo. I'm easy like that!

So are you basically deleting them and then re-adding them according to adjacent cells, which can be dynamic? Is that where Excel is not deleting them properly?

If yes, try deleting them along these lines:

Sub DeleteShapes()

    Dim wS1 As Worksheet
    Dim shp As Shape

    Set wS1 = Worksheets("Sheet1")
    For Each shp In wS1.Shapes
        shp.Delete
    Next shp

End Sub

Please keep this thread updated if you don't mind, I'd like to know if it works in a new Excel book on your end too.

What version of Excel are you using?

Hi jkvt,

What is it you are wanting to accmplish after you make these drop downs and buttons? I cannot reproduce your issues so I'm thinking they are coming up somewhere else, perhaps in another code block?

Are there many named ranges in the one sheet that you want the data from? I'm personally not a fan of working with named ranges in code, for these reasons too. The goto code will always take you to the range so that cannot be used. At any rate, the following can be amended to your purposes:

Sub CopyNamedRangeData()

    Dim wS3 As Worksheet
    Dim rCnt As Long, cCnt As Long

    Application.ScreenUpdating = False
    Set wS3 = Worksheets("Sheet3")
    Application.Range("NamedRange").Copy
    wS3.Range("A1").PasteSpecial xlPasteValues
    Application.CutCopyMode = False
    Application.ScreenUpdating = True

End Sub

Watched Captain Phillips last night. Tom Hanks is a really great actor. That was an intense movie imo.

I started programming at 35, 5 years ago. There will no doubt be many different opinions regarding which language to start with but I'll suggest Java. In saying that, once you understand one, picking up other languages will not be as daunting as you would think. As for learning on your own or getting a degree (or diploma), I think a school setting is best and it makes you more hireable than saying "I learnt this on my own".

My 2 pennies.

Hi mavtcr, try the following and let us know how it goes:

If ACRS.RecordCount > 0 Then
        If MsgBox("SALARY ALREADY CALCULATED DO YOU WANT TO RECALCULATE ?", vbYesNoCancel, "Pebble") = vbYes Then
            'Perform your Yes calculation here
        Else
            'Prompt a message for no or do nothing
        End If
    Else
        CmbNdm.SetFocus
    End If

If I remember correctly in Java, the:

answer == "yes"

will not work because == does not work in that sense with strings like that. I'm kind of surprised it worked with string numbers (1/0) but meh. Try

"yes".equals(answer)

Put near the end of your Userform module and see if it does what you need.

Instead of

With ActiveCell.Interior

use:

With Selection.Interior

See if that works.

Granted but you have no time for that!

I wish I had a Rolex watch!

If it were me I would create 2 tables and go with your second option. Normalization is important with regards to relational db design. Also, I really dont see how speed will be an issue with your example regarding 2 tables, I wouldnt be worried about that!

My 2 pennies!

Theology aside, I don't think it will ever be abolished because it is a huge economic driver at this time of year. It would be political suicide to abolish xmas for a slew of reasons, including religious idiologies which are still dominant in NA. It's far too celebrated to abolish it.

My 2 pennies.

This may be browser related but there is also a problem with overlapping of text. See pic.

I'm not sure about how the name of the thread starter is more prevelant than the title of the thread. Maybe it's just something I need to get used to but as it stands I prefer thread titles to be more viewable than who has started the thread.

Why don't you ask about the problem(s) you are having? Provide some of the work that you've done already to see where you can be helped. You won't find anyone from this site that will do your homework for you. Effor goes a long way here.

Classic intelligence failure, nothing nefarious about it.

Classic intelligence failure that started a full blown war. Inexcusable.

As to Syria, guess where Saddam shipped a lot of his stuff when things started heating up in 2002?

Are you just saying that because that's what you think?

Also, why would the rebels used chemicals on the people they've been trying to protect? I don't believe it was to make the Syrian gov't look bad because they've been doing a good job of that on their own.

Yeah but terrorism, terrorism, terrorism, terrorism, terrorism,terrorism,terrorism,terrorism,terrorism, terrorism,terrorism,terrorism,terrorism,terrorism,terrorism,terrorism,terrorism,terrorism,terrorism,terrorism,terrorism,terrorism,terrorism,terrorism,terrorism,terrorism,terrorism,terrorism.

Just making sure you see the word terrorism to make it more important.

I just bought my wife a Kindle Fire so I guess we are in the "late first-time buyers" category. That said, she uses it for reading and watching Netflix. I use it for Netflix and my social media accounts. My kids have used it to watch the Youtubes and oh yeah, we've all used it for the Googles.

As for the reading my wife does, she uses it for ebooks as well as a university course she is taking as the course has a weekly pdf for the class to read and she likes it for that.

All in all, we go to the tablet now for quick information checks before we go to the laptop. Personally, I don't think it can replace the laptop except for its displaying capabilities.

My 3 pennies.

PS, nice article.

My opinion would be to add a new column to the existing table. If people are already used to working with that table, it might be easier to have them change how they work with that table rather than teach them to work with an all new table.

My 2 little pennies.

Nothing better than a woman's bum!

Look in your text book, there should be enough examples there to get you started.

pritaeas shared a nice link regarding how SharePoint can integrate well with other applications. However, I don't think SharePoint can help you design a database. From my limited work with SharePoint I've noticed it works primarily with lists which is alright but can be slow when there are many-o-many of lists to traverse through. Database design can be made easier with good ERD modelling tools like this.

Fetching Odd Ovals Tackling Big Animal Lumpy Linemen

Hockey

Tweeting Witless Ignorant Tactless Thoughts Enraging Reality

Vine

10 seconds is probably enough!

***********
Granted, you just grew a bit, not a byte but a bit!

I wish I could go to Mars.

Surely someone can write a program for this problem?

This is simple! Just ask and she'll either say yes or no. If yes then your doom awaits (jk) and if no then at least you'll spare yourself some real heart-ache later on.

In all my youth-like wit, I proposed to my wife with the following question:

Would you object to not marrying me?

Worked like a charm and as far as I'm concerned, doesn't give her the option to say no and mean it.

Availability With All Resources Earning New Endangered Screaming Species

Youtube

Computer sciences cover a broad range of courses. To say that there's an aid before the start of it imo is false. Like you had stated, learning the hardware and software side would be beneficial but as for programming languages, you'd have to research what your school will be teaching. Also, it's not just programming, hardware and software. Learning documentation is critical for all systems. Database systems are big in computer sciences too. There's so much really.

If I were you, I would see what your first couple courses are and start learning them.

I just noticed this, congratulations JorgeM. For some reason I too thought you were a mod already.

Well you got lucky there nstrazmiri! I wouldn't suggest doing this again if I was you.

Yeah, I'd say that with using the screw driver, you damaged either the cpu, motherboard, or (most likely) both. Time for some new hardward.

As for using your pc's cpu, if you don't mind possible destroying that one too then go for it but I would strongly recommend that you don't.

Unfortunately I don't think that is possible. They great proprietary designers of this world don't like to make parts like this compatible across other platforms. At least not as a rule!

If the pins are ben or broken you will have troubles for sure. The only way they wouldn't stick deep enough is if the pins are bent or the whole CPU isn't aligned properly. Either way, it's bad news.

It will be difficult for anyone to give you a definitive answer but I think the CPU is where the trouble is. Three things could have happened, 1, you damaged the CPU, 2, you damaged the motherboard, or 3, you damaged both.

When you say you cleaned the CPU, what exactly does that mean? The removal and replacement of a CPU is a very delicate operation and can easily be done erroneously. If I was to guess, your problem is there.

No!

My turn :) May you trip up right nastly!

Crazy

Congrats on that, that's a very good score!

Welcome to Daniweb Andreea, this is a great community and you'll learn a lot too.

Android - Aggressive New Development Reaching Ovations In Discoveries

Apple

Potential Relations of Gruesome Rituals and Materialistic Masochisms Inverting Narcissistic Gamers (wtf?)

Easy

Granted, you get anything which actually turns out to be nothing.

I wish I was a famous musician.

Just to start, tell all your friends about your blog site using Facebook or Twitter if you use social networks. If you don't use social networks, perhaps it's time you started.

Did you submit your blog URL to Google or Bing or other search engines? I'm not really sure about how exactly you do that but I'm sure Google and others have easy ways to do that.

Do you allow commenting? I've seen blogs that don't and I've thought they should as a blog site should be interactive with people if you want people to keep coming back.

Hopefully this helps a bit and good luck.

I liked it so much I had to Tweet, Facebook, and LinkedIn share it!

He's just saving face in order to look good and help people forget that whistleblowers are basically dead-people-walking.

What I'm not particularly fond of is the one side the US government is taking with topics like this. Take Snowden for instance, here's a guy that can never go home again because he leaked "sensitive" info that "embarassed" the US government. I say, tit-for-tat. If the governements want to watch us we should be able to watch them too. Oh but that doesn't work though because they should be aloud to keep secrets in the name of security. Pisses me off really how we let our governments get away with so much and then forget about things a week later. ^^Feels like ranting^^