swift412's latest activity
-
SI don't believe it. I copied your formula and now it works. :love: Thank you very much. :)
-
Sswift412 replied to the thread InStr function.Yep, works fine on my side. Access 2016. Double check that the brackets line up in your formula, you might have missed a closing bracket
-
Sswift412 replied to the thread InStr function.TestInstr: Left([ProductID], InStr([ProductID], "/") - 1)
-
-
Sswift412 replied to the thread InStr function.What is the name of the field you're using InStr on? IIRC, Access is really finicky about punctuation and other non-alphanumeric...
-
SThese come highly recommended by Dankpods. In terms of price, this is pretty much as low as they go. Raru though.
-
Sswift412 replied to the thread Excel formula amendment - tiny change :).If your version of Excel has =SORTBY, you can sort the red range in-formula using something like SORTBY($D$1:$E$10, $D$1:$D$10) or even...
-
Sswift412 replied to the thread Excel formula amendment - tiny change :).Using =IF or =IFS is okay if you're only dealing with 3 or 4 cases, but it's going to become a real schlep to scale up to more cases...
-
Sswift412 reacted to Ivan Leon's post in the thread Excel formula amendment - tiny change :) with
Like.
In Windows 7 & 8.x, if you set the language & regional (number format) settings to South Africa, then the default separator for currency... -
Sswift412 replied to the thread Eskom implements stage 3 load-shedding.Have they considered another emergency backup system for when their current emergency backup system is not working? :unsure:
-
SDid someone rewrite the specs for Epic? Evetech? I'd sooner smack myself repeatedly in the face with a rotting tuna.
-
Sswift412 replied to the thread Hardware Bargains - Open Thine Wallet.SSD all the way. I would rather use a 10 year old laptop with an SSD, than a 2021-model laptop with a HDD.
-
Sswift412 reacted to Hamish McPanji's post in the thread Hardware Bargains - Open Thine Wallet with Like.
It's gonna make a huge difference. I just upgraded an office laptop. Just the boot time went from about 3+ minutes to 15 seconds. And...
-
Sswift412 replied to the thread How South Africans will register for a COVID-19 vaccine.You people are overcomplicated things, man. Email every citizen a copy of "Copy of Copy of Electronic Vaccine Data System (9) (Final)...
-
Sswift412 replied to the thread Epic tech deals this week.I too miss people fighting over who gets to post a link to Guzzle first.
-
Sswift412 reacted to Bismuth's post in the thread Online platform to be used for tracking South Africa's COVID-19 vaccination programme with Haha.
A Google Form linked to Google Sheet?
