Search results for query: *

Afternoon all, So I started a new job and I am working with PLSQL for the first time in many years. I understand basic SQL calls, select statements ETC. I am currently trying to adjust a package which I inherited from the previous admin. At a basic level, when the script sees a well that it...

Well, the good news. I solved the issue... Looks like the referenced tab needed to have the headers in it and the person using the spreadsheet deleted the headers. Either way, easy fix and thank god it wasn't much to deal with. Thanks for your help guys hopefully this wont happen again!

Strongm, Thanks so much, I tried changing the name and I also used your exact suggestion but I am still receiving an error: "No value given for one or more required parameters." I got this error over and over when I tried to change the name of the field to something completely different.

Hi all, Not a programmer but am getting the "circular reference error" on a spreadsheet that I inherited. I am running the macro our former employee created, and I am getting: "RunTime error 2147467259 (80004005)': Circular Reference caused by alias 'Fiscal Year' in query definitions SELECT...

Hey Skip thank you, I am doing exactly what you said by putting the new column at the other end of the spreadsheet... I am actually a reporting analyst/SQL guy and the person I took over was a VBA guy. Unfortunately, you download the CSV of this report from our reporting system and then load it...

Hi Skip, sorry I was typing as you were replying so my apologize and yes I did delete that post... Yes you are correct I added column "I" (which is a time/date field) to the upload sheet as I stated in my original question. I am just trying to fix it now... I will change any reference after...

Combo, Thanks for the reply but this is a bit beyond me. I did change the cell reference in the data validation module and it works. I added in Column I where I have highlighted but I don't see any other references to column I. Here is the entire module... the error that...

Hi guys, Not a programmer here but I have to work with some VBA script that was legacy from the previous guy. We added a new column, column I time and date field, into the spreadsheet and I made some adjustments but I am still getting a Type Mismatch error in line 405. I think its pretty...

Worked perfect thanks... do you know how I can line up all the counts in the center of each existing bar now?

Hey guys, So I have an excel pivot chart, dual axis, one showing average "uptime" percentage, and the other one shows totalcount of sites. I would like to be able to JUST show the number of sites without the bar (so basically just the label). Stuck right now... does anyone have ideas?

SkipVought, Worked perfectly! I have one very odd issue that I have been trying to figure out. I have several different PT running off the same data, they are all formatted exactly the same coming from the same data, yet ONE of them has a different output than the others: All others come...

I have set the #DIV/0! to show as "No Data" in the pivot table (right click->PivotTableOptions->For error values show) Cell 1111 - Rabbit Creek CO1 0.0% Cell 1111 - Rabbit Creek CO2 3.2% Cell 1111 - Rabbit Creek CO3 5.3% Cell 1125 - Anchorage Daily News (ADN)1 1.2% Cell 1125 - Anchorage Daily...

Hi all, I hope this is the best place to ask this, so I am working with regular old Microsoft Excel/ Office Professional 2010. So I have a regular old pivot table, and I have set the options to show "No Data" rather than the dreaded #DIV/0/. I have another sheet where I do % calculations based...

Afternoon all, Quick question for all those with Access experience: We have a 2010 access database that resides on one of our servers on our network. Our techs travel quite a bit and do not alway have internet access at the sites they travel to. They usually make updates when they return...

Skip... Seriously? Yes, 12 years I've been on here but I was on a plane, in a hurry, on a tiny screen, and not a fan of Tecumseh Markup Language. I hope this to your liking: Column E 6 seconds 1 minute 14 seconds 7 minutes 12 seconds 2 hours 28 minutes 6 seconds 1 day 9 hours 5 minutes 9...

Hi Skip, I think I got it, but my only issue is that ("Time to Resolution" is column E) Sometimes it may only come up seconds, sometimes it may come up hours, minutes and seconds... sometimes "Days" might be the first. Does that matter? This is exactly how the data is coming back in a CSV...

Thanks for the reply guys... But this is actually what is in the cell: Time to Resolution 1 minute 56 seconds 4 hours 38 minutes 14 seconds 3 hours 31 minutes 6 seconds 3 hours 30 minutes 6 seconds 3 hours 30 minutes 6 seconds 6 hours 32 minutes 7 seconds It actually spits out of the...

Hi All, Looking for a formula to turn this: 4 hours 38 minutes 14 seconds into seconds in excel? Anyone?

Got it! Works perfect! Thanks Skip and Zelgar!

Actually guys I think I got it fixed! The only last problem is how can I have it stop when it hits the "Summary" workbook"? Thats what was making it overwrite the data we put in. Here's my code: Sub GatherData() 'loops through \\newyork\Wireless_ops\Wireless Field Maintenance\Maint...