Replace Function contained within sql query no longer works correctly... either deletes the entire string, or crashes the application

add a new menu item in order to view the sql behind a query; sometimes it takes ages to load a query in design, I just want to see the sql behind it

The 'Add Tables' palette is redundant as tables & queries may be added to a query by dragging them from the Navigation Pane.

The Add Tables palette is displayed every time a new query is created and it would be useful to be able to disable it completely.

InStr or InStrRev function results in error or crashes database if sort order is “General”).
Work around: Options > General > New database sort order > General - Legacy’, followed by ‘compact database’.
The behaviour is very odd in that e.g. it may or may not work first time after reboot / logon, but fails subsequently. Compacting and then restarting the database never fixes the issue.
This problem resulted from recent (Quarter 2 to July 2020) Windows and / or Access 2019 updates.

I find it annoying that everytime I send an .accdb file with multiple queries and forms to a collegue who uses ACCESS in a different language, I have to do a search/replace of every criteria in all queries and translate it to his language (for example : Forms -> Formulaire, Reports -> Etats ...)
It would be easier is all criteria were coded by default in English, and then showed to users in their UI language? Or maybe automatically translate all criteria when UI language is changed?

networkdays is a key concept in service level agreement measurement and project management reporting. It measures workdays between two dates. This function exists in Excel and should be easy to port into Access

Create a built in age function. This function should take in birthdate and ageasof_date as inputs, and calculate age as an output.

Datediff is close, but a little bit off, and requires adding a more complex if/then corrective function to get age fully precise.

In cases of contractual or regulatory compliance, the added precision is required.

I've received a few request for Accessibility from our CSAM's to provide while Customer Engineers are delivering workshops. Since these requests I've not be able to find any information or anyone that can provide this information on Accessibility. If a customer need Accessibility for a workshop that is being delivered via remote or onsite it would be nice to be able to provide this as a service to our them. This would be very beneficial to our customers.

It will be really helpful to change/correct table names/references quickly.

Many times I need to change the base table names to a different one in a complex query with formulas that refer to table names. Currently, I need to copy the SQL to notepad, make the changes and paste it back in the SQL view. However, this resets the column ordering in Datasheet view. I think "Find and Replace" is quite basic function to have while working in "SQL View".

If anyone wants to migrate Lotus Notes mailbox data into Office 365 mailbox then try NSF to Office 365 Migration Tool. It easily adds and browses the NSF mailbox items and convert to Exchange Online cloud platform without losing any data. It easily performs with all versions of Windows OS and compatible with all editions of Lotus Notes.

More Info- http://www.nsfto.com/office-365/

If you looking at the easiest way to split the Outlook PST files then use MailsDaddy PST Split Tool. It is a most popular single wizard application, which easily divides the Outlook PST file according to date, folder, size, and email id. The software is compatible with all editions of Windows OS and MS Outlook.

More Info- https://www.mailsdaddy.com/pst-split-tool/

When switching between SQL Management Studio and an Access front end I find myself pressing F5 to run the Access query as I've been working in the other window - would be good if F5 ran the query in Access as it does in SQLMS

In Dec... Your update wiped out our ability to query. We go through it. Last month SQL Server wouldn't query. We got through it. NOW On particular NEW MS OFFICE Installs my query is returning Gargage. I have the details with pictures. But I am recommending we shut off MS updates to both of my clients. If this "bug" is not fixed and it spreads to the whole company computers, we stop working.

No place for me to attach the graphic details of the NEW BUG.

My access Query with a wildcard is not working. Microsoft had me to change SQL and still not working.

In my testing
ODBC connection to Postgres v11
Create a passthru query "SELECT COUNT(id)::INTEGER AS counter FROM foo"
Mark query as returning records
Open ADO recordset on above query

Result:
rs.Fields("counter").type = 20 ' DECIMAL ?!
rs.Fields("counter").value = ""

Same error with "SELECT COUNT(id)::BIGINT AS counter FROM foo"

Current state:
Have to revert MSO on 20+ backoffice client machines and hope that ADO will be reverted as well.

Update the Add Tables Task Pane so if you've clicked into the list and scroll the mouse wheel it scrolls the list. Even better if the mouse is over the list and you scroll the wheel it should scroll the list.

Also arrow keys should allow you to move up and down on the list after you've click on an entry in the list.

It doesn't need to be as complex as SQL Server, but pagination would be nice Something like:

SELECT Customers.*
FROM Customers
ORDER BY Customers.Name
OFFSET 20 FETCH 5;

This would be so amazing.

Right click DUPLICATE a table, query, etc. Instead of Copy/paste.