Did anyone see Independence Day: Resurgence over the weekend? I had fun with it but the film is full of many odd edits/poor dialog moments and just some truly bizarre scenes.

SPOILERS: Like when Dr. Isaacs died. Dr. Okun's reaction was so over the top and I didn't know if they were close friends or in a relationship. The character of Floyd Rosenberg and his desire to find himself by mentoring with Dikembe Umbutu seemed so one dimensional and predictable. And the kids driving the car who find
Julius Levinson came out of nowhere, long after all of the character building had taken place. The sphere and it talking seemed so out of place. And many other scenes... END SPOILERS

That said, I still smiled a lot and had fun with it. But the more I think about it, the more I realize it was a mess.

@david.wiese said in 3 Monitor Capable Graphics Card Suggestions:

this is what we are using for our sales and customer service group. They each have 3 monitors and it works great. Just remember you need to purchase Active Display Port Adapters in order to get all 3 to work.

http://www.newegg.com/Product/Product.aspx?Item=N82E16814487025&cm_re=evga_geforce_gtx750--14-487-025--Product

That's a good price and I'll give it a shot...thanks!

@wirestyle22 said in 3 Monitor Capable Graphics Card Suggestions:

@garak0410 said in 3 Monitor Capable Graphics Card Suggestions:

I am looking for a good PC compatible graphics card that will truly support 3 monitors. This is for business and not gaming. Most of our PC's here have graphics cards with 3 ports (of varying types) but the GPU's will only support 2 at one time.

I've searched and I am having difficulty finding one. One of them in the descriptions just come right out and say 3x Monitor support. Any suggestions off hand? I prefer NVIDIA but am open to anything and looking for reasonable costs.

Thanks...

I always use http://pcpartpicker.com/ to find parts. Well, not always, but most of the time.

I checked out the video card section...very nice but still doesn't show or verify if the card allows more than 2 monitors at once.

@wirestyle22 said in 3 Monitor Capable Graphics Card Suggestions:

@garak0410 said in 3 Monitor Capable Graphics Card Suggestions:

I am looking for a good PC compatible graphics card that will truly support 3 monitors. This is for business and not gaming. Most of our PC's here have graphics cards with 3 ports (of varying types) but the GPU's will only support 2 at one time.

I've searched and I am having difficulty finding one. One of them in the descriptions just come right out and say 3x Monitor support. Any suggestions off hand? I prefer NVIDIA but am open to anything and looking for reasonable costs.

Thanks...

I always use http://pcpartpicker.com/ to find parts. Well, not always, but most of the time.

I'll give it a shot...I didn't think this would be so difficult but it has been.

I am looking for a good PC compatible graphics card that will truly support 3 monitors. This is for business and not gaming. Most of our PC's here have graphics cards with 3 ports (of varying types) but the GPU's will only support 2 at one time.

I've searched and I am having difficulty finding one. One of them in the descriptions just come right out and say 3x Monitor support. Any suggestions off hand? I prefer NVIDIA but am open to anything and looking for reasonable costs.

Thanks...

Yeah, this one will be a toughie because it won't even let me step through past a break-point with this error:

@dafyre said in VBA Hint Needed - Change Way An Existing Project Grabs Data:

@garak0410 said in VBA Hint Needed - Change Way An Existing Project Grabs Data:

@dafyre said in VBA Hint Needed - Change Way An Existing Project Grabs Data:

That is right. The way the code works, is it just prints the rcell.value to the screen, sets SJOB =rcell.value, and then at the Next rCell line, it goes to the next cell. It's not actually doing anything beneath that.

The trick will be to comment out the "Next rCell" line

and find out where the end of the process is, and then on the next line add next rCell and see if that works.

If this thing is actively modifying files and such, I'd hightly recommend backing everything up before running it while you are working on that part.

Question...if I comment out the Next rCell line to test this, then what do I do with the FOR line? It will tell me there is a FOR without a NEXT.

Yeah. You need to read through the code and figure out where to put that Next rCell statement.

It is most likely near the end of the code... but look and see where it looks like everything is done, and put the Next statement there.

Gotcha...call me nuts but this is kind of fun...learning a lot and trying not to get frustrated at this crazy code...

@dafyre said in VBA Hint Needed - Change Way An Existing Project Grabs Data:

That is right. The way the code works, is it just prints the rcell.value to the screen, sets SJOB =rcell.value, and then at the Next rCell line, it goes to the next cell. It's not actually doing anything beneath that.

The trick will be to comment out the "Next rCell" line

and find out where the end of the process is, and then on the next line add next rCell and see if that works.

If this thing is actively modifying files and such, I'd hightly recommend backing everything up before running it while you are working on that part.

Question...if I comment out the Next rCell line to test this, then what do I do with the FOR line? It will tell me there is a FOR without a NEXT.

@garak0410 said in VBA Hint Needed - Change Way An Existing Project Grabs Data:

I'm making progress even if still getting errors...

I did put job numbers in rows W2 and W3. SJOB is still a null value even after this:

For Each rCell In Worksheets("REPORT").Range("W2:W50")
Debug.Print rCell.Value:
sJob = rCell.Value
Next rCell

And some how, it is still pulling data from Schedule, S and putting it in Column C...I am trying to track that down...

While debugging, it DOES pull from column W and I see SJOB being assigned a job number both by hovering over the variable and in the intermediate window. It then does the same for the next job number (only entered two for this example, cell W2 and W3. The intermediate Window does show both jobs:

But it is not holding the SJOB data as it eventually goes null...

When it gets to this part:

Function FindJobDir(ByVal strPath As String) As String
Dim sResult As String

sResult = Dir(strPath & "*", vbDirectory)
FindJobDir = UCase$(sResult)
Do While sResult <> ""
sResult = Dir
If Len(sResult) > 0 Then FindJobDir = FindJobDir & "," & UCase$(sResult)
Loop
End Function

It just starts grabbing all job folder information from the server location...luckily it fails when it hits a ZIP folder otherwise it would have been a data overrun...

When it is executing this line: vJobFolders = Split(FindJobDir(strpathtofile & sJob), ",")

SJOB Shows Null like this:

@dafyre said in VBA Hint Needed - Change Way An Existing Project Grabs Data:

@garak0410 said in VBA Hint Needed - Change Way An Existing Project Grabs Data:

@dafyre said in VBA Hint Needed - Change Way An Existing Project Grabs Data:

@garak0410 said in VBA Hint Needed - Change Way An Existing Project Grabs Data:

@dafyre said in VBA Hint Needed - Change Way An Existing Project Grabs Data:

@garak0410 said in VBA Hint Needed - Change Way An Existing Project Grabs Data:

In my weeks long struggle with this, I did at least try somethiing...I commented out all of the lines that grabbed the data from the other sheet (see code in posts above) and made a varient called rcell and tried this line of code:

For Each rcell In Worksheets("Sheet1").Range("W2:W50"): Debug.Print rcell.Value: Next rcell
sJob = rcell.Value

I keep getting SUBSCRIPT OUT OF RANGE.

I guess this is a lack of my own education mixed with bad coding in the first place...

A little formatting my help you see the problem...

For Each rcell In Worksheets("Sheet1").Range("W2:W50")
 Debug.Print rcell.Value: 
Next rcell

sJob = rcell.Value

It looks like you're trying to assing sJob after you come out of the For Each loop... Try:

For Each rcell In Worksheets("Sheet1").Range("W2:W50")
 Debug.Print rcell.Value: 
 sJob = rcell.Value

Next rcell

OK...I am giving this a shot...I am at the point in the old code where I see when SJOB is equal to the value of the job on the date range on the other spreadsheet. Since I am moving these jobs to manually entered job numbers in Column W, will se how this works. Curretly, SJOB is equal to: sJob = ParseJob(GetValue(sSchedPath, "Schedule S.xls", "LOG (2)", "B" & CStr(l)))

sJob=ParaseJob(rcell.value) ?

The more I work on this (uninterrupted from day to day issues that I am NOT getting today, wooo!), the more I think I am "getting it."...I don't think we need ParseJob because what that did before was remove spaces in the job numbers that were lisited on Schedule, S. So I just need it to be rcell.value...about to code and see what happens.

puts on hard hat...

Here... Hold my beer?

Funny...it is amazing what a closed door and no distractions can do to your focus and clarity...and maybe "beer."...

@dafyre said in VBA Hint Needed - Change Way An Existing Project Grabs Data:

@garak0410 said in VBA Hint Needed - Change Way An Existing Project Grabs Data:

@dafyre said in VBA Hint Needed - Change Way An Existing Project Grabs Data:

@garak0410 said in VBA Hint Needed - Change Way An Existing Project Grabs Data:

In my weeks long struggle with this, I did at least try somethiing...I commented out all of the lines that grabbed the data from the other sheet (see code in posts above) and made a varient called rcell and tried this line of code:

For Each rcell In Worksheets("Sheet1").Range("W2:W50"): Debug.Print rcell.Value: Next rcell
sJob = rcell.Value

I keep getting SUBSCRIPT OUT OF RANGE.

I guess this is a lack of my own education mixed with bad coding in the first place...

A little formatting my help you see the problem...

For Each rcell In Worksheets("Sheet1").Range("W2:W50")
 Debug.Print rcell.Value: 
Next rcell

sJob = rcell.Value

It looks like you're trying to assing sJob after you come out of the For Each loop... Try:

For Each rcell In Worksheets("Sheet1").Range("W2:W50")
 Debug.Print rcell.Value: 
 sJob = rcell.Value

Next rcell

OK...I am giving this a shot...I am at the point in the old code where I see when SJOB is equal to the value of the job on the date range on the other spreadsheet. Since I am moving these jobs to manually entered job numbers in Column W, will se how this works. Curretly, SJOB is equal to: sJob = ParseJob(GetValue(sSchedPath, "Schedule S.xls", "LOG (2)", "B" & CStr(l)))

sJob=ParaseJob(rcell.value) ?

The more I work on this (uninterrupted from day to day issues that I am NOT getting today, wooo!), the more I think I am "getting it."...I don't think we need ParseJob because what that did before was remove spaces in the job numbers that were lisited on Schedule, S. So I just need it to be rcell.value...about to code and see what happens.

@dafyre said in VBA Hint Needed - Change Way An Existing Project Grabs Data:

@garak0410 said in VBA Hint Needed - Change Way An Existing Project Grabs Data:

In my weeks long struggle with this, I did at least try somethiing...I commented out all of the lines that grabbed the data from the other sheet (see code in posts above) and made a varient called rcell and tried this line of code:

For Each rcell In Worksheets("Sheet1").Range("W2:W50"): Debug.Print rcell.Value: Next rcell
sJob = rcell.Value

I keep getting SUBSCRIPT OUT OF RANGE.

I guess this is a lack of my own education mixed with bad coding in the first place...

A little formatting my help you see the problem...

For Each rcell In Worksheets("Sheet1").Range("W2:W50")
 Debug.Print rcell.Value: 
Next rcell

sJob = rcell.Value

It looks like you're trying to assing sJob after you come out of the For Each loop... Try:

For Each rcell In Worksheets("Sheet1").Range("W2:W50")
 Debug.Print rcell.Value: 
 sJob = rcell.Value

Next rcell

OK...I am giving this a shot...I am at the point in the old code where I see when SJOB is equal to the value of the job on the date range on the other spreadsheet. Since I am moving these jobs to manually entered job numbers in Column W, will se how this works. Curretly, SJOB is equal to: sJob = ParseJob(GetValue(sSchedPath, "Schedule S.xls", "LOG (2)", "B" & CStr(l)))

In my weeks long struggle with this, I did at least try somethiing...I commented out all of the lines that grabbed the data from the other sheet (see code in posts above) and made a varient called rcell and tried this line of code:

For Each rcell In Worksheets("Sheet1").Range("W2:W50"): Debug.Print rcell.Value: Next rcell
sJob = rcell.Value

I keep getting SUBSCRIPT OUT OF RANGE.

I guess this is a lack of my own education mixed with bad coding in the first place...

Has anyone used BLOC for those online developer training bootcamps? Are just having the right books and resources with self-discipline still the best, cheapest way?

https://www.bloc.io/web-developer-career-track

Using our SharePoint Online options, I have dumped our first week of Survey results into an Access DB. The data is there. And I know this sounds dumb, but what do I do with it now? Are there any SharePoint online options to customize the viewing of this data? Or do I just analyze the data in Excel? I just don't see a lot of useful "Hey, use me to do this" screaming at me on my SharePoint Online site.

@Brett-at-ioSafe said in Wayward Pines - Anyone Watch It? (May Contain Spoilers):

@garak0410 I've not watched the TV show, but I've read the books and they're really good.

Season 1 does the books justice while adding some things to it...Season 1 is worth a look. Blake is involved in Season 2 as a creative consultant, so it is still his baby of sorts but so far..."eh"...

Overall, Wayward Pines is worth a watch for its first season. It is very mysterious if you don't get spoiled...but once the "reveal" is out, it is more or less over...

@wrx7m said in Wayward Pines - Anyone Watch It? (May Contain Spoilers):

I watched the first season and loved it. Less than impressed by the second season.

I'm gonna trust that the writers have something up their sleeves but Season 2 has been very awkward to say the least, especially with key characters dying with no resonance.

@DustinB3403 said in Wayward Pines - Anyone Watch It? (May Contain Spoilers):

Essentially the show takes place some ~2000 years from today, where we has humans destroyed the environment. One man saw this happening and built an enclosure for the remaining humans.

Outside of the enclosure there are these beast that go around and eat people (think a cross between a werewolf and a vampire).

How they add people to the population is they use cryogenic freezers to keep people alive, but asleep. And as they need a doctor or an IT person or an army person they defrost them.

It's an oddly stupid show. I watched last nights episode and decided I won't be watching it again.

Did you see Season 1? Go back and watch it and just be good with a contained series in one season. That's how I felt about Heroes...season 1 was great and good by itself.