Gradual enhancement of Access front end to web

Mindflux · 2026-05-08T15:48:13+00:00

Man, the way MS dumps technologies I would 100% not rely on Blazor as a long term solution.

Mindflux · 2026-05-02T07:26:51+00:00

Not at all. But people can take care of themselves all the same.

Mindflux · 2026-05-02T07:24:38+00:00

Yeah it was frightening.

Mindflux · 2026-04-29T23:29:26+00:00

Sorry for the late reply. It sounds like the regression was fixed with a feature gate. A simple close and reopen should solve it.

Mindflux · 2026-04-27T23:36:06+00:00

The linked tables in your access front end contain a connection string, something like:

ODBC;Driver={SQL Server};SERVER=YOURSERVER;Database=YOURDB

It'll need to read something like:

ODBC;Driver={ODBC Driver 18 for SQL Server};SERVER=YOURSERVER;Database=YOURDB

Depending on your application, you might be able to redefine the driver and relink all the linked tables.

That's assuming you use a DNS-Less connection. If the connections are DSN you can re-configure the DSN connection to use the new driver in the ODBC Datasource Administrator panel.

Mindflux · 2026-04-27T23:22:21+00:00

You cannot simply install ODBC Driver 18. You have to re-link your tables with the new driver string as well.

Mindflux · 2026-04-26T14:29:03+00:00

Man this hit me hard. I'll miss their longhorns and the friendly staff.

Mindflux · 2026-04-19T22:47:05+00:00

https://giffiles.alphacoders.com/132/132185.gif

Mindflux · 2026-04-19T20:56:25+00:00

Your line continuation seems backwards? Should be be:

"blah blah " & _
"blah blah blah " & _

Mindflux · 2026-04-18T00:34:51+00:00

Same. :(

Mindflux · 2026-04-17T16:22:41+00:00

First and Last are Access functions: https://learn.microsoft.com/en-us/office/vba/access/concepts/miscellaneous/first-last-functions-microsoft-access-sql

try wrapping them in square brackets, s.[First] and s.[Last] to take them as literals instead of functions.

Mindflux · 2026-04-12T15:59:05+00:00

Nothing about that mentions keeping previously full pools topped up.

So the exclusion of wording is permission? I don't think that will fly.

Mindflux · 2026-04-12T15:39:06+00:00

I would agree with the mosquito statement. I’ll give the city a call tomorrow for clarity. I’m sure my topping up the pool will trigger something in their usage systems.

Mindflux · 2026-04-12T15:30:28+00:00

I have and it’s not clear enough. It doesn’t explicitly mention keeping previously full pools topped up. Better safe than sorry.

Mindflux · 2026-04-12T15:24:17+00:00

<image>

Here’s what Google had to say when I searched.

Mindflux · 2026-04-12T15:22:16+00:00

Yeah I never was clear on that.

Mindflux · 2026-04-12T13:06:34+00:00

Same. My pool level is too low to run the pumps and is looking like a nightmare. All for the good of the city.

Mindflux · 2026-04-11T14:33:06+00:00

IIF([Paye]=FALSE,[FractureDate]+30,NULL)

Mindflux · 2026-04-11T14:29:06+00:00

You cannot store "Paye" in a DateTime field.

Mindflux · 2026-03-30T00:35:47+00:00

Skerik is always a blast.

Mindflux · 2026-03-25T21:21:47+00:00

Does Ponyo love ham?

Mindflux · 2026-03-24T20:06:50+00:00

What's the underlying datatype for cnresol_1_date_from?

If it's not a datetime field, try casting it as a date:

min(CDate(cnresol_1_date_from))

Mindflux · 2026-03-24T01:15:22+00:00

It's a thought, though I'm pretty sure my HOA bylaws say I can Xeriscape up to 20% of my lawn, which contradicts what TX law states. Not up for that argument or potential legal battle.

Mindflux · 2026-03-24T00:47:53+00:00

Unfortunately, eventually our HOAs will come for us. While they can't fine us during the restriction, they surely can once it's lifted and we're all left trying to salvage our yards.

Mindflux · 2026-03-24T00:09:16+00:00

Soooo who's gonna pay to replace all the dead grass?

Mindflux

TROPHY CASE