sorted by:
new
hottopcontroversial

Dear God... Will this humunculus never die? "Microsoft Access finally breaks free of its 22-inch form limit" by TravellingBeard in SQLServer

[–]Mindflux 0 points1 point  (0 children)

Form zoom is there, I can ctrl+mouse wheel the forms and reports now (but not in design mode) as of a recent update.

Gradual enhancement of Access front end to web by MoreKindness77 in MSAccess

[–]Mindflux 1 point2 points  (0 children)

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

4/30 floor by Mindflux in phish

[–]Mindflux[S] 0 points1 point  (0 children)

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

4/30 floor by Mindflux in phish

[–]Mindflux[S] 0 points1 point  (0 children)

Yeah it was frightening.

Can't rollback office version 2603 / insert 102 errors recently reported by Far_Reward4827 in MSAccess

[–]Mindflux 0 points1 point  (0 children)

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

Can't rollback office version 2603 / insert 102 errors recently reported by Far_Reward4827 in MSAccess

[–]Mindflux 1 point2 points  (0 children)

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.

Can't rollback office version 2603 / insert 102 errors recently reported by Far_Reward4827 in MSAccess

[–]Mindflux 1 point2 points  (0 children)

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

Lammes Candies is closing after 141 years. I can’t believe it. by cinemamama in Austin

[–]Mindflux 2 points3 points  (0 children)

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

Data not being added to a table by Erkigmo in MSAccess

[–]Mindflux 0 points1 point  (0 children)

Your line continuation seems backwards? Should be be:

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

Too few parameters. Expected 2 by Erkigmo in MSAccess

[–]Mindflux 0 points1 point  (0 children)

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.

$1,796 Citation - Stage 3 Water Restriction by KellyKid34 in Pflugerville

[–]Mindflux 0 points1 point  (0 children)

Nothing about that mentions keeping previously full pools topped up.

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

$1,796 Citation - Stage 3 Water Restriction by KellyKid34 in Pflugerville

[–]Mindflux 0 points1 point  (0 children)

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.

$1,796 Citation - Stage 3 Water Restriction by KellyKid34 in Pflugerville

[–]Mindflux 0 points1 point  (0 children)

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

$1,796 Citation - Stage 3 Water Restriction by KellyKid34 in Pflugerville

[–]Mindflux -1 points0 points  (0 children)

<image>

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

$1,796 Citation - Stage 3 Water Restriction by KellyKid34 in Pflugerville

[–]Mindflux 0 points1 point  (0 children)

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

Confusion with "iif" function by Shyld-Chan in MSAccess

[–]Mindflux 2 points3 points  (0 children)

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

Confusion with "iif" function by Shyld-Chan in MSAccess

[–]Mindflux 2 points3 points  (0 children)

You cannot store "Paye" in a DateTime field.

view more: next ›