#msaccess — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #msaccess, aggregated by home.social.
-
And, to top it off, due to the size of her screen, she only sees the funnel icons now instead of the words. She has to hover over to see what the icons mean. Despite being a Gen-X with lots of office computer experience, the coworker still doesn't hover over icons to figure them out. She only knows the ones she knows and expects words for things she doesn't know. Hovering as an exploration doesn't come natural to her.
-
And, to top it off, due to the size of her screen, she only sees the funnel icons now instead of the words. She has to hover over to see what the icons mean. Despite being a Gen-X with lots of office computer experience, the coworker still doesn't hover over icons to figure them out. She only knows the ones she knows and expects words for things she doesn't know. Hovering as an exploration doesn't come natural to her.
-
Remaking Akabot's DB in MS Access
-
Remaking Akabot's DB in MS Access
-
Wrote my first Windows batch file today. It checks if a user's local copy of an Access frontend database is the current version; if not, it downloads the latest version from the server into a local folder, deletes any old local copies, then launches Access with it in runtime mode. 😎 #access #office #msAccess #msOffice #windows #databases #programming
-
Wrote my first Windows batch file today. It checks if a user's local copy of an Access frontend database is the current version; if not, it downloads the latest version from the server into a local folder, deletes any old local copies, then launches Access with it in runtime mode. 😎 #access #office #msAccess #msOffice #windows #databases #programming
-
Apparently the optimal VBA code to save a record in Access is:
If Me.Dirty Then
Me.Dirty = False
End If🤔
-
Apparently the optimal VBA code to save a record in Access is:
If Me.Dirty Then
Me.Dirty = False
End If🤔
-
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
-
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
-
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
-
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
-
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.
-
@adacosta Microsoft also promotes the path to migrate #MSAccess databases to Dataverse (Power Platform) and turn the apps into #PowerApps. Which would surely be great alternative to SQL for the citizen developers managing their own Access apps. https://powerapps.microsoft.com/en-us/blog/access-migration-to-power-apps-and-dataverse-is-released-to-general-availability/
-
@adacosta Microsoft also promotes the path to migrate #MSAccess databases to Dataverse (Power Platform) and turn the apps into #PowerApps. Which would surely be great alternative to SQL for the citizen developers managing their own Access apps. https://powerapps.microsoft.com/en-us/blog/access-migration-to-power-apps-and-dataverse-is-released-to-general-availability/
-
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
-
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
-
🏘️ 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:
-
🏘️ 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:
-
DB-Engines Ranking climbers of the month:
1. #SQLServer
2. #MsAccess
3. #Splunk
https://db-engines.com/en/ranking -
DB-Engines Ranking climbers of the month:
1. #SQLServer
2. #MsAccess
3. #Splunk
https://db-engines.com/en/ranking -
That feeling when you realise you've been using MS Access since back when the example date given was recent.
#database #access #MSaccess #FeelingOld -
Translating a query from #msaccess ( :blobcatmeltcry: ) to #tsql in order to troubleshoot something. The Access query uses InStr() https://support.microsoft.com/en-us/office/instr-function-85d3392c-3b1c-4232-bb18-77cd0cb8a55b in which the parameters are in exactly the opposite order than the equivalent CHARINDEX() https://learn.microsoft.com/en-us/sql/t-sql/functions/charindex-transact-sql?view=sql-server-ver16
I'm sure this is an organic evolution of disparate, yet similar technologies, but damn it took me too long to figure out why my record counts were so off.
-
Translating a query from #msaccess ( :blobcatmeltcry: ) to #tsql in order to troubleshoot something. The Access query uses InStr() https://support.microsoft.com/en-us/office/instr-function-85d3392c-3b1c-4232-bb18-77cd0cb8a55b in which the parameters are in exactly the opposite order than the equivalent CHARINDEX() https://learn.microsoft.com/en-us/sql/t-sql/functions/charindex-transact-sql?view=sql-server-ver16
I'm sure this is an organic evolution of disparate, yet similar technologies, but damn it took me too long to figure out why my record counts were so off.
-
#freude - wenn das neue #macbookpro16 jetzt auch #Windows11 kann 👏👏👏
Und ich somit alle Vorteile von #Apple hab und trotzdem auch #msaccess oder im Bedarfsfall das gesamte Office-Paket in vollem Umfang nutzen kann!!! Bin.voll.begeistert!😊 -
Ein Vorsatz fürs neue Jahr: Endlich Ordnung in die Schulbibliothek bringen - vielleicht sogar mit einem einfachen Verleihsystem? So klappt's mit dem Datenbank-Tool #MicrosoftAccess:
https://www.malter365.de/access/schulbuecherei/ -
Ein Vorsatz fürs neue Jahr: Endlich Ordnung in die Schulbibliothek bringen - vielleicht sogar mit einem einfachen Verleihsystem? So klappt's mit dem Datenbank-Tool #MicrosoftAccess:
https://www.malter365.de/access/schulbuecherei/ -
Ich kenne mich recht gut in #MSAccess aus. Ich möchte mich nun in #PostgreSQL weiterbilden. Schwerpunkt #Programmierung, weniger Administration.
Ich freue mich über eine Empfehlung. Darf auch gerne Englisch sein, wenn es sein muss. -
But take, for instance, a data-storing and manipulating application. I rather program that in #MSAccess than in #java with #springData or #Hibernate. Why? Because Access gives me so much, that I have to scaffold myself if using java. The obvious part, the data part, gets scaffolded with Hibernate. But how about a nice GUI? Input validation? Reporting? Access gives us that, whereas java lets us create that. A world of difference.
-
DBeaver Community
Free Universal Database Tool.
Free multi-platform #database tool for #developers, database #administrators, #analysts and all people who need to work with databases. Supports all popular databases: #MySQL, #PostgreSQL, #SQLite, #Oracle, #DB2, #SQLServer, #Sybase, #MSAccess, #Teradata, #Firebird, #Apache #Hive, #Phoenix, #Presto, etc.
-
DBeaver Community
Free Universal Database Tool.
Free multi-platform #database tool for #developers, database #administrators, #analysts and all people who need to work with databases. Supports all popular databases: #MySQL, #PostgreSQL, #SQLite, #Oracle, #DB2, #SQLServer, #Sybase, #MSAccess, #Teradata, #Firebird, #Apache #Hive, #Phoenix, #Presto, etc.
-
Vous voulez rire ? encore 2 techniciens sont mobilisés aujourd'hui pour comprendre comment télécharger et installer la version de #MSaccess qui correspond à la licence achetée. Ça fait déjà trois demi journées!
