Would love this technique to take data from my bank, download it to access, and append all info to where it needs to be.
As a good example: think of a real estate management that tracks who paid rent and who is still outstanding and they need to get this data from the bank on a daily basis in order to send out the right balance to each tenant - this technique will be done automatically...
You already covered all this but the very first part to go out to the bank automatically I haven't yet seen.

It would be tough to do this on Access or any app because of the fraud security prevention that is usually involved.  You can have your web browser auto-fill passwords for you (see picture below), but it can't go through CAPTCHAs for you (see picture below), because CAPTCHAs specifically want live human beings to use.

Regarding transferring data from bank websites to Access, those websites usually let you export bank records to CSV files (comma-separated values, see picture below), which you can then import to Access.

Also, nowadays many logins allow two-factor authentication to add extra security: after logging on with user ID and password, the user still has to retrieve a code from an authenticator app on another device (usually a smartphone) and enter it in order to pass the login.  This is specifically designed for a live human being to use and thus impossible to automate.

Hi,
Thanks for your comment,
I thing Richard did mention that you can do it to your bank account...

If your browser is already set up to auto-login, then yes, you can automate that by just opening the website link with AppActivate or FollowHyperlink.  But nowadays you are strongly advised to use two-factor login when it is available (especially for important sites like banking), you have to manually enter the info for that.  You can't automate that except maybe cyber criminals.

Yeah, there's no way you can use SendKeys to beat Captcha... but I have a morning routine that was getting VERY boring... log into Paypal, check my balance, check my credit card balance, download yesterday's payment info (CSV file), log into my bank, check balance, etc. So, I decided to try to automate it with SendKeys and Access. I have it working FOR ME. Granted, it has to be perfectly timed. If the bank changes ANYTHING on their site (including the number of TAB-able fields) then you have to reprogram your script to account for it. There are a dozen things you have to watch for. BUT... I've got it down to where it's 90% reliable which saves me a LOT of time in the morning, every day, from going click... click... click... Now I just click ONCE, sit back and watch it, make sure it's running right, and if not, figure out what I have to tweak. More will be coming. Still ironing out bugs.

Hi Richard, even if it works for you, your students are not you.  If things go wrong, you can deal with it, but your students may not.  Why put your students in harm's way?  In your video for "Logon Automatically," you actually suggest the user turn off his PC's password requirement.  That is a very risky move, especially when his PC is a server.  The fact that they even ask you for these kinds of solutions means they are not aware of all the dangers and they don't have all the knowledge.  And those are exactly the people you don't want to put in harm's way.

Kevin, I posted this response to your similar comment on YouTube:

I think you misunderstood the meaning of the video. I'm not telling people to do this with their Windows Server that runs the whole business. I'm saying if you have a machine acting like a "server" running some non-secure tasks like sending emails, and you want to make sure it boots on logon, this is one possible solution. I believe I made this explicitly clear in the video. In fact, I'm not even sure this trick works with Windows Server.

Obviously if this is a business critical server, don't disable password protection! Also make sure the machine is in a physically secure location (locked office, server cabinet, etc.)

By "server," I meant any PCs with a server role, not just those that run server OS.  A regular Windows PC running an Access back end that all users connect to is, in fact, serving a server role.  Richard, server or not, your advice to disable password requirement (with a backdoor method, no less) just went a bit too far for me.  One reason I joined your site was the "gatekeeping" you do as a certified professional; you ensure all your content is of high standard.  I know sometimes you offer unorthodox advice, but this one is just a bit too risky -- even for professional, let alone your students.

I have had many clients over the years who have non-secure "server" machines that do things like send emails or act as a timeclock... nothing critical, nothing sensitive. There's no problem with having those machines automatically logon. I trust that people know enough to NOT bypass the Windows password and other security if that machine has vital and sensitive information on it, and I'm sure I made that VERY clear in the video.

Yeah, at 2:05 I spend about a minute talking about this issue... and then I mention it AGAIN at the end of the video, where I recommend SQL Server for any sensitive data.

Richard, a warning like this serves little purpose.  A warning doesn't help the PC become more secure.  The only way to make it secure is not use your method, in which case no warning would be necessary.  Many of your students have jobs and livelihood that depend on your advice, so I just thought this particular advice went a little too far.  And as I said in my YouTube comment, there are ways to solve this kind of problems without lowering the security, and those are the methods you and your site should endorse.  If someone's PC doesn't stay on, he should find ways to make it stay on -- the right way, instead of breaking password protection to do it.

I appreciate what you're saying. In fact, just today I updated my WatchDog template so that it will kill MSACCESS.EXE and restart the database instead of relying on a full PC reboot. But, there's still nothing wrong with a little email or print "server" sitting in the corner without a password. I've seen it a million times. :)