Search results

There's no need to spend lots of money and time migrating from a customized Access app to an off the shelf app that doesn't do everything that the Access app does just because it's "safer" than Access. That's certainly not a justifiable reason. Just protect the "non secure" Access app better by...

There are many objects that have no security at all, but you protect them by preventing someone else from gaining access to that object. Your wallet has no security, but you are always on alert to make sure no one can get it, unless they hold you up at gunpoint, or hit you over the head and take...

If you properly plan your design, you identify which objects you want to group and assign them a unique tag name when you begin building your app, and afterwards as you add new objects that warrant belonging to a group. It's no big deal to go all the way to the bottom of the property sheet and...

Let me explain something to you. First of all . . . Security Is A Myth! Anything can be broken into because the weakest link in security are the people entrusted to use SQL Server, Access, Excel, Oracle, Web Apps . . . ANYTHING! So it's unfair for you to single out Access as the weakest tool...

I have seen very few Access developers leverage the tag property, which allows you to group many objects into collections to do things like make all controls in a group visible, hidden, locked, etc. https://support.microsoft.com/en-us/office/tag-property-98633b4d-1474-4f88-9821-00a5b6cfa045

Everyone's entitled to their own opinion, but if you cause damage based on false statements presented as facts, that's:

I remember Frank and Daniel Pineault were bugging out about Microsoft and the future of Access. I recently saw Daniel unfairly badmouthing AWF on his blog's evaluation of the various Access forums, and I brought it to @Jon's attention, but he had already been monitoring Daniel's false negative...

The point I make with security keys is the client doesn't know the authentication key value. The issue your discusing is the use of service accounts, which can easily fall into the wrong hands and then how do you know who perpetrated a hack?

So the appended string is salted. I use a passwordless Yubico security key to login.

It uses a native access backend. I don't think it ever had Postgres. Most of the table create timestamps date as far back as 2012. I'm still trying to wrap my head around this app. It looks like it was originally written for Spanish locale and he started changing it to English.

I once dealt with a biz that only used service accounts and granted dba to public because they didn't want to bother with security obstacles. They went bankrupt in a couple of years 🤣

No, I bought the rights to his app because he quit software development, bought a tractor trailer, and drives cross country. I think he was fedup with what's going on with the software development industry, AI, and changed careers.

I disabled the CF and it's much faster, so yes, it has nothing to do with positioning the record selector. I do think the Immediate IF expressions for concating contract extension suffix and elapsed days since last payment slows down displaying the data. So I can zip and upload a video file and...

True, I do have CF primarily color coding values on that datasheet, concating suffix values to contract numbers, etc. Do I have to provide a weblink to post screen videos, or can I directly upload a wmv or mp4 video file? I used to have Camtasia Studio but it stopped working on Win7. Is there a...

Tested both MajP and Arnel's solution, there's a noticeable delay in postioning selector on next record when returning from forfeiting or redeeming past due contract. It also lags when scrolling through or clicking directly on any record. I thought it would be faster because recordset is in...

I imagined it would work with rs clone, and without having to use bookmark. I tested arnel's code and it also works. With Me.Recordset .FindFirst "ContactID = " & lngNextContactID Me.Bookmark = .Bookmark End With Thank you all for helping me with this, I'm back from hospital recovering.

So because the user updated the CurrentRecord's status, it no longer qualifies for the datasheet's filter criteria, it disappeared from the datasheet and the record pointer got lost, or disoriented, and automatically resetted to first record, even though i saved next recordID and told it to...

I will test using rs. I'm curious why rs clone fails sometimes, but not always?

Regardless of what I requery, if I stored the next ContractID I want to position on, it should directly go to wherever that row is located on the sheet, right?

But if I store next record's ContractID prior to user updating CurrentRecord's status to Forfeited, which no longer qualifies for the datasheets filter of Actives only, then moving directly to the stored ContractID would happen regardless of any or no sort order, right?