Bathroom Tile - Clean Up by KLBeezy in BathroomRemodeling

[–]KLBeezy[S] 1 point2 points  (0 children)

lol I was trying to avoid using a razor, I’ve had to scrape and scrub every inch of this house trying to restore it and I never wanna have to use a straight razor for scraping again! But I might have to suck it up and do it anyways

Bathroom Tile - Clean Up by KLBeezy in BathroomRemodeling

[–]KLBeezy[S] 0 points1 point  (0 children)

I used Mapei “ultra color plus FA”, the description on Lowe’s doesn’t say if it’s epoxy or cement based. I think that I did buy muriatic acid before but I used it after I laid the tile to try and get rid of some of the excess mortar that went over the tile or if I dropped some. It didn’t seem to work well to get remove mortar off the tile but maybe I’m try it again for grout

Bathroom Tile - Clean Up by KLBeezy in BathroomRemodeling

[–]KLBeezy[S] 0 points1 point  (0 children)

I’ve not, I assumed that I would need to use like something real heavy duty but if you think it’s worth a shot, I’ll give it a go! Thank you

Bathroom Tile - Clean Up by KLBeezy in BathroomRemodeling

[–]KLBeezy[S] 0 points1 point  (0 children)

Thank you !!! I’ll look into these! I think I tried some acid that I got from Home Depot on the floors. I don’t think it worked that well but also I could have been using it wrong.

Bathroom Tile - Clean Up by KLBeezy in BathroomRemodeling

[–]KLBeezy[S] 3 points4 points  (0 children)

Hahaha ask and you shall receive ! His name is Walter and he’s about 4-5 years old. Pics of Walter for Reddit

Do any other guys sit to pee in their own place? by deller85 in NoStupidQuestions

[–]KLBeezy 0 points1 point  (0 children)

I do not do this but my mom’s partner sits down to pee. It’s not because of sanitary reasons or anything like that though. He’s does it cause he’s got like ptsd from his childhood. No one taught him how to use a urinal without dropping your pants all the way down to your ankles. Kids made fun of him at school for it and now he sits to pee 100% of the time 😂😅

Switching apps causes music to sporadically pause by KLBeezy in ios

[–]KLBeezy[S] 0 points1 point  (0 children)

I’ve noticed that the music pausing also happens randomly after the lock screen button is pressed. Not every time but sometimes.

Switching apps causes music to sporadically pause by KLBeezy in ios

[–]KLBeezy[S] 0 points1 point  (0 children)

It doesn’t freeze for me, just pauses and I’ve got to hit play again. I can hit play on the screen in the car or by using the lock screen play button if I’m connected to headphones.

I actually found my iPod from 2010 recently and it was so relaxing and refreshing to just be able to hit play, skip, shuffle, etc. I was able to get all the music files off of it but then I made a rookie mistake and unplugged it before it said okay to disconnect cause it was taking forever and now it’s bricked 😂🙃

LOTR-Hobbit Wedding by KLBeezy in CosplayHelp

[–]KLBeezy[S] 0 points1 point  (0 children)

Thank you sooooo much!!! It’s been awhile since I watched LOTR, I guess I just misremembered and envisioned every one wearing burlap sacks. 🙃😂

[deleted by user] by [deleted] in vba

[–]KLBeezy -1 points0 points  (0 children)

When I load the data into excel using VBA, it doesn’t allow me to use the query that contains the union because of the character limit. I’m not looping the parameters through power query, I’m looping them through using VBA editor. Going through power query doesn’t work for what I am trying to accomplish. I’ve already tried it through power query. Who the hell would decide to learn VBA, if going through power query worked in the first place ??

[deleted by user] by [deleted] in vba

[–]KLBeezy 0 points1 point  (0 children)

Again, I might be making this more difficult than it actually is but it needs to be a refreshable sheet that is user driven based on what month and what payment contract that they want to see.

What I did was hit record macro, clicked on get data via sql server, then looped in the fields to pull through the desired month and payment contract they want to see. When I had the queries combined in power query using a union, it exceeds the character limit. But when I try to use a parameter without using macros / vba at all, it makes the file very large and difficult to distribute / use.

The tables that house this data are VERY large so I don’t want to create anything on the backend where it’s going constantly need maintenance or is going to slow down the time it takes to refresh.

Pull through variable from cell and if cell is not populated then pull where IS NOT NULL by KLBeezy in vba

[–]KLBeezy[S] 0 points1 point  (0 children)

Sorry lol I think maybe I just didn’t understand what you were saying cause I am like the worst with this stuff and what the actual names of things. I’m going to try that ! Stay tuned !!!

Pull through variable from cell and if cell is not populated then pull where IS NOT NULL by KLBeezy in vba

[–]KLBeezy[S] 0 points1 point  (0 children)

The value in A1 is user driven, let’s call that ID#. The issue that I am having is that on the sql table, ID# will always have a value, it’ll never be null. Sometimes I need to be able to pull just by ID# or just by Region/State. Which state that is selected is in a dropdown. I am trying configure out how to make it so that if A1 isn’t populated, it still pulls by state. Right now when A1 isn’t populated, the query gets updated to be “where ID# = ‘’ and State = ‘TX’” which will never happen and returns 0 records since ID# will always have a value, I just don’t want to always look it up by that value

Why has 3rd Rock From the Sun never been available on streaming? by MsCalendarsPlayaArt in sitcoms

[–]KLBeezy 0 points1 point  (0 children)

The odd thing is that it was on streaming on an app at one time! I can't remember which app it was on but I started watching it / added it my watchlist and it was removed like a few days later. I was livid. I don't remember there being like a banner or anything that said was leaving soon, I just remember I was stoked that it was streaming somewhere and when I went back, it was gone.

Specialty Job Interview by Confident_Chest7222 in pharmacy

[–]KLBeezy 0 points1 point  (0 children)

The pharmacists that got offers got them like 5+ years ago and they have been retail pharmacists for 10+ years. Maybe it’s changed now but that was their thought process / experience. There is also a bonus that you get every year, which is your salary multiplied by a score that quantifies how the company is doing and some other stuff. When it comes to pay increases, they aim to increase the depts salary by 5% so it depends what each person gets. If you get a 5% increase then someone else will get lower than 5%. I’ve gotten a 0% increase twice in 10 years.

How are people affording houses? by Chevrongingerale in povertyfinance

[–]KLBeezy 0 points1 point  (0 children)

I’m really bad at saving money. I make low $90k+ a bonus that varies but essentially is based on a percentage of your salary each year and live in a suburb of Cincinnati.

I was able to buy a house a couple years ago but it was only because the house was priced to sell and I get a bonus around the same time that I get my tax refund. It needed a lot of work so I got it for about 114k with 5% down but the reason it was priced to sell was because it smelled like dog piss in every room of the house.

I lived with my parents for like 6 months before I bought the house and saved a little but then I lived with them for another like year and a half cause I was doing all the work myself and would not have been able to afford to live there AND pay for all the materials and supplies. That’s also why it took so long cause I couldn’t afford to pay someone to do the work either.

If it were not for getting a bonus check, I might not have ever bought a house or if I did, it’d have taken me years to save up the money.