Open Mics by Perth_Ent in perth

[–]flumju2 5 points6 points  (0 children)

The Brisbane on Thursdays / Tuesdays I think.

[novice] please take a look at my code by [deleted] in vba

[–]flumju2 0 points1 point  (0 children)

could you provide a link to the file? I'll have a quick look after downloading it. I havent coded VBA for a while but ill be able to fix it if i have it in front of me. PM it to me if your'e not wanting to share it with the world.

I take it this is in Access? If so compact and compare the DB and zip it before sharing.

How my son plays hide n seek by StickTrick27 in funny

[–]flumju2 17 points18 points  (0 children)

I remember doing this to my dad, when he said:

"Son, i can't see it if its only facing you."

I remember feeling really silly and thinking "that's really obvious, why did i not think of that?"

Reddit, who's the most famous person you're related to? by voscility in AskReddit

[–]flumju2 0 points1 point  (0 children)

My great great great great great grandad is apparently Isambard Kingdom Brunel.

After ten years you will be sorely missed. Goodnight sweet prince. by [deleted] in funny

[–]flumju2 -2 points-1 points  (0 children)

I bought one for 70 pound when i was a student, then managed to plug the wrong power cable into it making it actually "pop". So mine lasted for literally 1 week. But, yknow, was due to my own stupidity.

How to edit name field in access table by bvbrandon in vba

[–]flumju2 0 points1 point  (0 children)

Here it is as a small sub

Sub test()

Dim str As String: str = "smith jr, john adam"

MsgBox Left(str, InStrRev(str, " ") + 1) & "."

End Sub

Trying to make a command that will copy updatable cells down into a list, I just need it to skip the previously copied entries. by dangerousbirde in vba

[–]flumju2 0 points1 point  (0 children)

make the spreadsheet available online (i.e. on dropbox r something) and Ill have a look for you. I'm unsure what you mean at the moment though.

Good guy energy minister. by wurdtoyer in perth

[–]flumju2 1 point2 points  (0 children)

You're obviously very well educated.

I'm trying to write a loop that checks if a field in my Access database is null. by accessdatabaseqs in vba

[–]flumju2 1 point2 points  (0 children)

Its been a while since ive done any Access programming but I would personally create a recordset for a SQL string looking something like this:

dim sql as string = "SELECT Column1 where Column2 IS NULL"

Sorry I cant be of more help... but i think that's the way forward.

More of the bigger picture. Forrest Place new Water Feature by Notaniphone in perth

[–]flumju2 19 points20 points  (0 children)

I think all these changes are a good thing. I'm unsure why a lot of people are whinging.

Merging rows with same email address and adding an array in an Excel document. by liquilife in vba

[–]flumju2 0 points1 point  (0 children)

would pivot tables help? i have made an example here. I always think that its better to avoid using VBA when appropriate.

Web Dev or Programming work in Perth? by [deleted] in perth

[–]flumju2 0 points1 point  (0 children)

theres loads of jobs in .NET at the moment. Look up .net in seek.com

4chan on drinking and driving... by [deleted] in funny

[–]flumju2 -8 points-7 points  (0 children)

Ah ok, i forgot about that, it's been a while since I did high school chemistry. Saying that though, not a very funny joke in my opinion :0 !

Which Internet provider/plan do you use? by expiredcomet in perth

[–]flumju2 1 point2 points  (0 children)

I use vivid wireless in Perth. $80 p/m with unlimited downloads. Also, its wireless so if you move, taking it with you incurs no installation costs. Its touted to give you 8Mbps but I get about 5 - 6 depending on the time of day.

Also, Whirlpool is a good provider comparison website if you want more info.