Search results

The record source for the datasheet subform is this query, which first sorts by ContractStatus=1 ascending, (Active contracts only for this datasheet), then last payment date ascending so users can see oldest contracts first. then the other sort orders seen in the SQL statement. I don't see the...

Will do whenever I get back home from hospital. Meantime, I continue brainstorming with the help of Chatty on my iphone.

Will do, they admitted me for further tests and observation, I'm feeling much better. I should've brought my laptop because this iphone safari browser is flaky when editing posts.

Thanks for the well wishes. 102.6 fever, blood lactates, creatine phospho way high. Dark urine, concern for rhabdomyolisis kidney damage. This is not fun at all. They have me on double saline IV's to rehydrate me. Can't chat more, hope to recover soon, thanks again for your thoughts. Hopefully...

PercentPosition, or PresentPostion?

@CJ_London, But am I not capturing the absolute record position with this function below? But isin't the function below doing the same thing you suggested? Private Function DisplayContract() If Me.CurrentRecord = 1 Then crId = Me.CurrentRecord 'First record ElseIf...

#Name: Sounds like you need to declare variables, or you misspelled something?... I'm currently busy with something else, but will dig deeper in a while. How about attaching the latest verion of the accdb you're working on so we can take a look? I'm heading to the hospital emergency room, I...

1. I have users who periodically view a datasheet subform on the main dashboard that displays past due contracts. 2. Users drill down to certain contracts and decide if they want to forfeit the contract, or skip it and move on to the next contract. In the example below, the user decided...

Did you try what @June7, @Gasman, and @Ken Sheridan suggested? Explain exactly what's not working?

Once again, I stand by my earlier statements. Defend your existing app for all of its merits. If they're worried about you being the only one that knows how to maintain and run the app, there's plenty other experienced Access developers available.

It's a habit from working for so long with DATETIME YEAR TO SECOND on db servers.

So if I want to include any results for entire day of August 31st, my AccessSQL should be? ... WHERE TransactionDate BETWEEN #8/1/2025# AND #8/31/2025#; or ... WHERE TransactionDate BETWEEN "2025-08-01 00:00:00" AND "2025-08-31 23:59:59";

I have seen 00:00:00 and 12:00:00 AM, but not 24:00:00. I prefer using miltitary time (24 hour clock) where midnight is 0000, 1:00 PM is 1300, and so on. I find it strange, and undesirable, that by default Access does not display any time when it's 12:00:00 AM, but displays 12:00:01 AM. SQL...

Why does 12:00:00 AM Midnight get truncated when displayed?

Now it calculates correctly. I don't know why it didn't before :confused: You're not taking into account the seconds? Public Function CalcTotalHrsMin(ByVal ID As Long, ByVal dte As Date, ByVal QryName As String) As Variant Dim totalMin As Double CalcTotalHrsMin = Null If...

Hi Arnel, I downloaded your demo and added a tc record that starts on 8/7 and ends on 8/8. I don't see anything wrong with your query, but it calculated negative time worked :rolleyes:

If you post your accdb we can better help you.

Instead of just buying the ink cartridges, I buy Canon MG2522 printers for $29 that comes with color and bw cartridges. It's cheaper than paying $60 for the replacement ink. I have 5 spare printers. I mostly print bw, removing black backgrounds, and the cartridge lasts about 70 pages. The 4 in 1...

I kno it was a flimsy weak statement. I was being sarcastic, but users have to be trusted to a certain extent, without crippling their productivity.

Web apps use stateless unbound forms, but Access doesn't. Service accounts should be avoided because it's difficult, or impossible, to trace who did something.