A Tech Help Thread--Yes I Looked

[BadgerAlum@WMU]

I am starting this because I have a very confusing issue.

I have a 2-year-old Samsung Galaxy SIII. I know that's several generations old, but it works great and it's more of a tiny tablet than a phone most of the time, and I love it.

However, here is the issue. When I first got it, I also bought an external battery pack, and it worked great for awhile. However, at some point, the phone stopped accepting the charge from the battery pack at all. I tried changing cords, buying a new battery pack, etc. and nothing works. The phone charges great on a wall charger and via USB from my laptop. I have tried all sorts of battery packs from the cheapo 2200mA ones in the dollar section at Target to the really nice 6000 mA myCharge I bought initially. Zip.

Any ideas as to why this might be so? It perplexes me as to how I can get every other charging method to work but a battery pack. (Note: my car does not have a cigarette lighter port in it at all, so I have no way of testing that. It's a 2000 Ford Crown Vic PI. It has an ash tray but no cigarette lighter port that I have found.)

I'm asking this because I'm going on a 4-day camping trip with no electricity and would like to keep my phone charged for emergencies, and I really don't want to pony up $50+ for one of those car battery jumpers with a USB port.

 

[FlagDUDE08]

Re: A Tech Help Thread--Yes I Looked

Your tech support tip of the day, courtesy of the New York Times. http://www.nytimes.com/2016/09/02/t...uld-i-hit-reply-all-asking-to-be-removed.html

 

[St. Clown]

Re: A Tech Help Thread--Yes I Looked

MS SQL Studio question for those of you who know:

I'm trying to convert a date-time field that stored as a text string, example: "10/7/2016 11:03:00 AM" to an actual date-time field for my queries. The examples I'm finding of the various sites aren't proving fruitful. Can anyone help?

 

[The Sicatoka]

Re: A Tech Help Thread--Yes I Looked

MS SQL Studio question for those of you who know:

I'm trying to convert a date-time field that stored as a text string, example: "10/7/2016 11:03:00 AM" to an actual date-time field for my queries. The examples I'm finding of the various sites aren't proving fruitful. Can anyone help?

I assume you've tried the ideas on StackOverflow.
http://stackoverflow.com/questions/207190/sql-server-string-to-date-conversion

And I'm assuming you're trying to do this directly in the DB and not pulling data up into a higher level language.
If you were pulling that as part of a query up into C# it'd be a walk.
http://stackoverflow.com/questions/919244/converting-a-string-to-datetime

 

[Kepler]

Re: A Tech Help Thread--Yes I Looked

MS SQL Studio question for those of you who know:

I'm trying to convert a date-time field that stored as a text string, example: "10/7/2016 11:03:00 AM" to an actual date-time field for my queries. The examples I'm finding of the various sites aren't proving fruitful. Can anyone help?

Parse the string to component variables. It's a good idea anyway in case you need to query or sort on partials later.

if you're sure of the delimiters in the source field it's a snap.

 

[Jimjamesak]

I assume you've tried the ideas on StackOverflow.
http://stackoverflow.com/questions/207190/sql-server-string-to-date-conversion

And I'm assuming you're trying to do this directly in the DB and not pulling data up into a higher level language.
If you were pulling that as part of a query up into C# it'd be a walk.
http://stackoverflow.com/questions/919244/converting-a-string-to-datetime

I don't how to help but StackOverflow is a great name.

(Of course I think of something completely different...)

 

[jen]

Re: A Tech Help Thread--Yes I Looked

I have an Excel question. Maybe I'm not picking the right terms to Google, but I can't find a solution.

Spreadsheet A - when you use the right arrow to scroll across the columns, it keeps going to the right. When you get to the end of the worksheet, it stops. This is good.
Spreadsheet B - when you use the right arrow to scroll across the columns, after the data ends, it moves to the next row instead of stopping. This is not good.

How do I make B function the same way as A?

I tried creating completely new sheets, but it went back to the same thing.

 

[The Sicatoka]

Re: A Tech Help Thread--Yes I Looked

I have an Excel question. Maybe I'm not picking the right terms to Google, but I can't find a solution.

Spreadsheet A - when you right cursor across the columns, it keeps going to the right. This is good.
Spreadsheet B - when you right cursor across the columns, after the data ends, it moves to the next row. This is not good.

How do I make B function the same way as A?

I tried creating completely new sheets, but it went back to the same thing.

Are you moving the cursor with the right arrow key or by the enter key? The arrow key will move cell-to-cell (unless you have something like scroll lock on); the enter key tends to follow the pattern the data is entered so a row with an empty cell in the middle may toss you back to the start of the next row. Not sure what the tab key does in those scenarios but I know some folks use that to move cell-to-cell sometimes.

 

[jen]

Re: A Tech Help Thread--Yes I Looked

Are you moving the cursor with the right arrow key or by the enter key? The arrow key will move cell-to-cell (unless you have something like scroll lock on); the enter key tends to follow the pattern the data is entered so a row with an empty cell in the middle may toss you back to the start of the next row. Not sure what the tab key does in those scenarios but I know some folks use that to move cell-to-cell somehow.

Right arrow key with both. Scroll lock off.

This has to be some kind of setting, but apparently my brain doesn't work the same way as the MS programmers, because I can't figure out what they would call it or where to find it.

 

[The Sicatoka]

Re: A Tech Help Thread--Yes I Looked

MS SQL Studio question for those of you who know:

I'm trying to convert a date-time field that stored as a text string, example: "10/7/2016 11:03:00 AM" to an actual date-time field for my queries. The examples I'm finding of the various sites aren't proving fruitful. Can anyone help?

Thinking about this some more, and looking at the format the string data is in, do you have admin rights on the DB?
If so, you could try to covert the datatype of that right in the DB table. --> ALTER TABLE table_name ALTER COLUMN column_name datatype

 

[The Sicatoka]

Re: A Tech Help Thread--Yes I Looked

Right arrow key with both. Scroll lock off.

This has to be some kind of setting, but apparently my brain doesn't work the same way as the MS programmers, because I can't figure out what they would call it or where to find it.

Is there any help (or ideas) in here:
http://www.techrepublic.com/blog/mi...rol-excels-cursor-movement-during-data-entry/

 

[St. Clown]

Re: A Tech Help Thread--Yes I Looked

Thinking about this some more, and looking at the format the string data is in, do you have admin rights on the DB?
If so, you could try to covert the datatype of that right in the DB table. --> ALTER TABLE table_name ALTER COLUMN column_name datatype

I do not have admin rights to the DB. We're not able to change the DB for this app since it was written - sloppily - in VB6 back in 2002. We've found that when we make small changes to the DB structure, unless it is to make a new table for a new process, as they've had the oddest downstream impacts. The application is set to retire in 2020, only delayed because we're putting all our resources into a new trust system and surrounding applications. So I get to play Patchwork Adams with this old one.

I'm off work today, so I'll have to try the earlier suggestions when I get into work tomorrow.

 

[St. Clown]

Re: A Tech Help Thread--Yes I Looked

Right arrow key with both. Scroll lock off.

This has to be some kind of setting, but apparently my brain doesn't work the same way as the MS programmers, because I can't figure out what they would call it or where to find it.

Is your one worksheet protected? That's how it sounds to me, that a range of cells allow for scrolling and editing while the remainder are locked down.

 

[jen]

Re: A Tech Help Thread--Yes I Looked

Is your one worksheet protected? That's how it sounds to me, that a range of cells allow for scrolling and editing while the remainder are locked down.

That's the ticket. I have one locked cell on spreadsheet B (but none on A). I changed the "protect" options to allow everything, and now it works fine. You made my day.

 

[jen]

Re: A Tech Help Thread--Yes I Looked

I have 4 spreadsheets. Each spreadsheet has 12 worksheets. Each worksheet has open and closed items on it.

Each worksheet has 5 lines of stuff, then column headings begin on line 6, then data on line 7.

I want to have 1 spreadsheet that lists all open items on all 5 spreadsheets. I can't use a PivotTable, because too many of the columns have no data in them. Any ideas how I can do this?

 

[Kepler]

Re: A Tech Help Thread--Yes I Looked

I have 4 spreadsheets. Each spreadsheet has 12 worksheets. Each worksheet has open and closed items on it.

Each worksheet has 5 lines of stuff, then column headings begin on line 6, then data on line 7.

I want to have 1 spreadsheet that lists all open items on all 5 spreadsheets. I can't use a PivotTable, because too many of the columns have no data in them. Any ideas how I can do this?

Open a new file. Build a macro that deletes prior contents of the file then iterates through each of your other files within which it visits each worksheet, goes to the data rows, and copies the row data if the record meets the criterion (wherever "Open" is specified), then closes the file when it reaches EOF. When it has gone through all the files have it go back to the top of itself and process (sort, group etc) all the rows it just created. Rename the macro Auto Exec so it runs on Open. When you want to use it just open the file.

 

[St. Clown]

Re: A Tech Help Thread--Yes I Looked

I have 4 spreadsheets. Each spreadsheet has 12 worksheets. Each worksheet has open and closed items on it.

Each worksheet has 5 lines of stuff, then column headings begin on line 6, then data on line 7.

I want to have 1 spreadsheet that lists all open items on all 5 spreadsheets. I can't use a PivotTable, because too many of the columns have no data in them. Any ideas how I can do this?

There's not a way I can think of to get the information consolidated using a formula, so a macro would be the answer.

ETA: and you don't need to delete any of the data, just have it search Column X, where "OPEN"/"CLOSE" would be held, and copy those rows of data over to a new worksheet.

 

[jen]

Re: A Tech Help Thread--Yes I Looked

I've never worked with macros before, and this is more of a "nice to have" rather than a requirement, so I'll hold off for now, but thanks for your input, guys. I was hoping for a formula or a way that PivotTables would work. If I get bored, I may stumble through it.

 

[FreshFish]

Re: A Tech Help Thread--Yes I Looked

I have 4 spreadsheets. Each spreadsheet has 12 worksheets. Each worksheet has open and closed items on it.

Each worksheet has 5 lines of stuff, then column headings begin on line 6, then data on line 7.

I want to have 1 spreadsheet that lists all open items on all 5 spreadsheets. I can't use a PivotTable, because too many of the columns have no data in them. Any ideas how I can do this?

Depending upon how the data is arranged, you might be able to use vlookup.

 

[St. Clown]

Re: A Tech Help Thread--Yes I Looked

Depending upon how the data is arranged, you might be able to use vlookup.

I thought about that too, but the status field is never a unique value, and is never the first column of data in a situation she described.