Apparently the optimal VBA code to save a record in Access is:

If Me.Dirty Then
Me.Dirty = False
End If

#vba #MSAccess #access

https://answers.microsoft.com/en-us/msoffice/forum/all/force-save-record-in-vba-code/e8261ebb-6f53-4168-a999-fef162fa3093

Nearly all of my prior database experience comes from working in Salesforce. I've built lots of custom objects, apps, flows, and have written some Apex.

But I have this one little project requiring MS Access now. It's been really frustrating but I'm making progress. I guess Salesforce spoiled me. Functionality I took for granted in Salesforce, I have to implement from scratch in Access with unwieldy SQL statements and VBA. #salesforce #MSAccess #database

Hm, really tired of this #MSAccess, #LibreOfficeBase database application stuff. I need a quick way to create a "main/detail" GUI from a database.

There once was #WebObjects and that really nice #JavaClient stuff.

Is there anything else, existing to this day?

I know of
- #Apache #Cayenne (only ORM, no GUI generation)
- #ManyDesigns #Portofino (very close, but only web GUI. Thanks to @peter for that hint some time ago).

Do you know of anything? @helge

12,000 years ago some bloke invents agriculture and now I have to read a 1100 page book on Microsoft Access. Fucking bullshit. #msAccess #access #microsoft

Trying to build anything in Microsoft Access's form designer is excruciating. #msAccess #access

All new https://KEXI-Project.org Website! #kexi #databases #foss #opensource #MSAccess #MicrosoftAccess #linux #KDE

When showcasing #ODBC prowess #excel and #msaccess were unrivaled. Methinks #pivotviewer is going do the same thing for #linkeddata :-)

When showcasing #ODBC prowess #excel and #msaccess where unrivaled. Methinks #pivotviewer is going do the same thing for #linkeddata :-)

Ugh, spent quite some time on an update query for #MSAccess only to find out that it wanted the joins right after the UPDATE and before the SET.

It's actually a nice, clear way to do it, but it is so different from everything else, I kept stumbling because the vague error from Access made me think it was a field name that was wrong.

On an #MSAccess report, I need to add a button that will appear on the screen, but not when printing. BUT I want it to show in Print Preview mode. Is there a way to show an element on a report when in Print Preview mode, but not when actually sent to the printer? The OnPrint event seems to trigger on the Print Preview mode not when the actual print occurs. MS docs say "The Print event occurs after data in a report section is formatted for printing, but before the section is printed."

A continual irritation in my life is app interface redesigns for easier to use touchscreens that make them worse on non-touchscreens. For example, I've been battling #Chrome & #Brave forever finding tweaks to remove the extra white space they put in menu line spacing that just means less is displayed. Meanwhile, Microsoft increased the size of their #MSAccess tool ribbon so that none of my forms fit properly on screen anymore.

Why not just let us customize? WTF.

#TIL you can order by alias in #MSAccess by referring to the index

SELECT id, last_name & ", " & first_name AS full_name from customers ORDER by 2 ASC;

works while

SELECT id, last_name & ", " & first_name AS name from customers ORDER by full_name ASC;

does not.

Ah, wie viele Tausend Stunden wohl intern von diversen Leuten aufgewendet wurde für diese «Produktivitätshilfen»?
#MSAccess

Für die #VBA-Entwickler habe ich hier ein nettes kleines Feature: Eine mehrzeilige und formatierte MsgBox (leider nur für #MSAccess).

(Der Artikel ist schon 1/2 Jahr alt, ich habe ihn heute nochmal geringfügig überarbeitet.)

https://www.juengling-edv.de/messagebox-deluxe

If you need to export a Microsoft Access database while on macOS or Linux, this might do the trick:

1. `brew install mdbtools`
2. `pip install pandas_access`
3. In a Python session:

```python
file_name = ‘path_to_access_file.mdb’
for table in mdb.list_tables(file_name):
df = mdb.read_table(file_name, table)
df.to_excel(f'{file_name}-{table}.xlsx')
```

You're welcome! (Including myself in the future…)

See also https://gist.github.com/juandesant/e77b00bccf6cfda04abc3467e75f2531

Microsoft Access is an amazing piece of software. #msaccess

Dauerbrenner im Blog: Wie kann man eigene Immobilien digital verwalten?

Probier's mal mit einer Datenbank in #Access! Hier gibt's die Inspiration - auf Wunsch mit vielseitiger Vorlage für den Start:

https://www.malter365.de/access/immobilienverwaltung/