Solved Highlighting Next Record After Current Record Filtered Out of Datasheet

[BlueSpruce]

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 memory and ContractID is indexed?

 

[Ken Sheridan]

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?

A set has no intrinsic order. When we talk of the next record we are usually referring to the next record in the current sort order, which we can do here because that's what we want, regardless of what that sort order might be. However in another context we might want to go to a record in a sort order which differs from the current sort order, in which case we would do so on the basis of the values in the record in the way I described.

 

[MajP]

It also lags when scrolling through or clicking directly on any record. I thought it would be faster because recordset is in memory and ContractID is indexed?

This is likely having to do with conditional formatting, I doubt there is a code issue.

My solution works regardless of how you sort or filter the datasheet.

 

[BlueSpruce]

This is likely having to do with conditional formatting, I doubt there is a code issue.

My solution works regardless of how you sort or filter the datasheet.

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 free video capture tool i can download for Win7?

 

[MajP]

I do have CF primarily color coding values on that datasheet, concating suffix values to contract numbers, etc

My point is that I doubt any of the lagging has to do with identifying and moving to the "new" correct record. So you have to do some other troubleshooting. I would see what happens if you test it without CF.
You cannot upload a video unless you zip it as a file. To display you need to host it somewhere.

 

[BlueSpruce]

My point is that I doubt any of the lagging has to do with identifying and moving to the "new" correct record. So you have to do some other troubleshooting. I would see what happens if you test it without CF.

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.

You cannot upload a video unless you zip it as a file. To display you need to host it somewhere.

So I can zip and upload a video file and memebrs can click on it to play it, or I have to upload it to utube and members click on the link?

Below are the data properties of the datsheet subform, do they look adequate?

 

[cheekybuddha]

This UI looks familiar.

Is that you, Frank?

 

[BlueSpruce]

This UI looks familiar.

Is that you, Frank?

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.

 

[cheekybuddha]

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.

Is it still using a postgres backend?

 

[BlueSpruce]

Is it still using a postgres backend?

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.

 

[cheekybuddha]

I don't think it ever had Postgres

Interesting. Frank talked a lot about using it for the BE, but perhaps he was looking to implement it.

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.

Shame UA is no more, he asked a lot of questions about it there.

 

[BlueSpruce]

Interesting. Frank talked a lot about using it for the BE, but perhaps he was looking to implement it.


Shame UA is no more, he asked a lot of questions about it there.

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 remarks.

 

[cheekybuddha]

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,

You're going a bit off topic here, but I think Daniel's entitled to his opinion.

 

[BlueSpruce]

You're going a bit off topic here, but I think Daniel's entitled to his opinion.

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

Slander and libel are both forms of defamation, which involves making false statements that harm someone's reputation. Slander refers to spoken defamatory statements, while libel pertains to written or published defamatory statements.