Subscribe
News
Press Office
Breaking News
Forum
Industry News
Network Status
Speed Test
Menu
Forums
New posts
Search forums
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Log in
Register
What's new
Search
Search
Search titles only
By:
Current visitors
New profile posts
Search profile posts
Menu
Log in
Register
REGISTER FOR FREE NOW
See hidden discussions
|
Win great prizes
|
Get free support
Members
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
swift412's latest activity
S
swift412
reacted to
LaraC's post
in the thread
InStr function
with
Like
.
I don't believe it. I copied your formula and now it works. :love: Thank you very much. :)
Tuesday at 7:06 PM
S
swift412
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
Tuesday at 7:04 PM
S
swift412
replied to the thread
InStr function
.
TestInstr: Left([ProductID], InStr([ProductID], "/") - 1)
Tuesday at 7:00 PM
S
swift412
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...
Tuesday at 6:29 PM
S
swift412
reacted to
Dylan_G's post
in the thread
Hardware Bargains - Open Thine Wallet
with
Like
.
These come highly recommended by Dankpods. In terms of price, this is pretty much as low as they go. Raru though.
Feb 18, 2021
S
swift412
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...
Feb 18, 2021
S
swift412
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...
Feb 17, 2021
S
swift412
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...
Feb 15, 2021
S
swift412
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:
Feb 10, 2021
S
swift412
reacted to
rustypup's post
in the thread
Epic tech deals this week
with
Haha
.
Did someone rewrite the specs for Epic? Evetech? I'd sooner smack myself repeatedly in the face with a rotting tuna.
Feb 5, 2021
S
swift412
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.
Jan 31, 2021
S
swift412
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...
Jan 31, 2021
S
swift412
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)...
Jan 29, 2021
S
swift412
replied to the thread
Epic tech deals this week
.
I too miss people fighting over who gets to post a link to Guzzle first.
Jan 29, 2021
S
swift412
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?
Jan 29, 2021
Members
Top
Subscribe to our daily newsletter
Subscribe