Computer Learning Zone CLZ Access Excel Word Windows

Peace is good for business.

-35th Rule of Acquisition
 
Home   Courses   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
Home > Forums > Captain's Log
Back to Captain's Log    Comments List
Upload Images   @Reply   Bookmark    Link   Email  
Don't Rely on One Finger
Richard Rost 
           
2 months ago
Today's Captain's Log is brought to you by... a jar of jelly.

Not some epic space anomaly or a philosophical showdown with Q. Just jelly. I sliced open the side of my right index finger on the sharp edge of the metal lid. And of course, it's the finger I use for everything: typing, tapping, swiping, unlocking my phone. No, not just picking my nose.

Anyhow... this finger is offline.

So here's your PSA: don't just rely on one finger.

Set up multiple fingerprints on all your devices. Thumb, pinky, left hand, backup left hand. One little cut and suddenly you can't unlock anything unless you've got a backup. Luckily I had a few other fingers registered, so I didn't get locked out - but it was a close call. And on my laptop I also have a PIN setup which is easy to remember... and yes, partially Star Trek related. LOL.

Also worth thinking about your passwords. I use Google's password manager, which works great for me. I know some folks - including my wife - aren't comfortable having everything stored in one place. And yeah, if someone gets into your Google account, they've got the keys to the kingdom. But at some point, you've got to trust the tech. If Google's getting hacked at that level, we're probably all in trouble anyway.

As I've said multiple times, you should never use the same password everywhere. But you've got to have some easy way to remember all your passwords. Or at least have them stored in a central repository.

And speaking of backups, this is exactly why Starfleet doesn't let just one person control the ship. There's always a second officer. Even Data has backup subroutines. You think they gave Worf the conn just for fun? No, that's planning ahead in case the jelly jar wins.

So yeah - protect your data, enroll your backup fingers, and don't underestimate the danger of pantry-based injuries.

LLAP
RR

P.S. Shameless plug for my mouse pad. You know you want one.
Richard Rost OP  @Reply  
           
2 months ago

Thomas Gonder  @Reply  
       
2 months ago
As to the mouse pad, I was told, by some old Access wag, to always do a rs.MoveFirst as you can't trust that the rs will be at the first record. Is that not the case anymore? I would have called it a bug, but you never know with Microsoft.

If you, like Richard's SMART, new-wife don't like putting your life in the cloud, a local app called KeePass Password Safe is a great alternative. There is a version for Android too, so it's always available even if the Internet (or your finger) aren't available. Mentioned before in other threads.
Thomas Gonder  @Reply  
       
2 months ago
Bonus, stupid dad joke:
Why do gorillas have such big nostrils?


Because they have a huge index finger.
Richard Rost OP  @Reply  
           
2 months ago
Great question. It is safe to assume in Microsoft Access, when you open a recordset, that you're at the first record. However, this isn't always necessarily the case with other database systems, including SQL Server. But for Access, you're usually good.

Just like it's always safe to assume that a string variable that you declare is always initialized to an empty string. But I always like to manually initialize that myself just in case. S=""

And just like it's always safe to assume that when you exit a procedure, access always cleans up any object variables by setting them to Nothing. But I've seen first-hand that it doesn't. Hence, if you set it, you got to forget it.

So is it a good idea to MoveFirst? Yeah it can't hurt, and if your code's not working right that could be why. Access is supposed to start you at the first record, but you never know. I will admit with the mouse pad I was trying to put together the smallest possible recordset loop, but it can't hurt... just like it can't hurt to add some error handling.
Thomas Gonder  @Reply  
       
2 months ago
Likewise, you gotta keep an eye on those arrays set to variant.
If you like testing for Nulls, it won't work because they are "empty".
Richard must have a video somewhere on all these little variable gotchas.

For most of my years, I worked in a database system that was record and not record-set oriented. When you wanted to work on a set of records, there was a natural query language, somewhat similar to SQL, but it created a temporary index (that was how we ran 30 users in 64K of core memory, no huge internal "temp tables" hogging up memory, just an index that could be paged to hard disk). When you referenced the index in code or another query, it ALWAYS started with the first record. Doh Microsoft!
Matt Hall  @Reply  
          
2 months ago
Maybe someone needs to add band-aids to the swag shop.  :)
Richard Rost OP  @Reply  
           
2 months ago
UPDATE: I can use my finger again today. Well, mostly. As long as I stick to the side of it, I'm fine. It's not painful anymore, just mildly discomforting. My fingerprint recognition works if I stick to the side of the wound. If I push anywhere near where that gash is, then it doesn't work. So... Yay for the healing power of the body.
Richard Rost OP  @Reply  
           
2 months ago

Sam Domino  @Reply  
     
2 months ago
Maybe it was just me, but your index finger was not the "finger" that I thought you were talking about!  LMFAO!!!
Thomas Gonder  @Reply  
       
2 months ago
Sam He got me too. My first thought after reading just the title: One isn't enough?"
Michael Olgren  @Reply  
      
2 months ago
I gotta plug Dashlane. By far the best password keeper I’ve used. Has a pw generator, secure notes section, autofill— the usual, plus you can get a family account and securely share notes and pw with them. Reasonably priced to boot.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Captain's Log.
 

 
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2025 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 7/14/2025 7:16:19 AM. PLT: 1s