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 it2 votes
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.1 vote
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?3 votes
networkdays is a function in excel that provides date difference in workdays. Recommend same function be made available in MS Access
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 Access3 votes
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.1 vote
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.1 vote
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.3 votes
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/1 vote
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".1 vote
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 SQLMS11 votes
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.1 vote
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/1 vote
My access Query with a wildcard is not working. Microsoft had me to change SQL and still not working.1 vote
Bug with Office update 2005 build 12827 - Decimal data type enforced in ADO recordset based on passthru query
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
rs.Fields("counter").type = 20 ' DECIMAL ?!
rs.Fields("counter").value = ""
Same error with "SELECT COUNT(id)::BIGINT AS counter FROM foo"
Have to revert MSO on 20+ backoffice client machines and hope that ADO will be reverted as well.1 vote
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.3 votes
It doesn't need to be as complex as SQL Server, but pagination would be nice Something like:
ORDER BY Customers.Name
OFFSET 20 FETCH 5;
This would be so amazing.6 votes
The recent Access updates that broke the most simple update queries was bad. However, Microsoft's response was even worse. Rather than Microsoft fixing the very serious problem they created, they said we should change the way we update records in our applications. What moron thought that was an appropriate response? Like many other throughout the world, we have a production system with 400K lines of code and you want us to rewrite every update statement because you do not want to roll out a bug fix? Then, someone thought it was a good idea to wait 30 days to fix the problem. What are people to do in the meantime? These are production systems that people rely on every day to do their jobs! Again, what tone-deaf moron at Microsoft thought this was an acceptable response? Clearly someone needs to be fired.
The recent Access updates that broke the most simple update queries was bad. However, Microsoft's response was even worse. Rather than Microsoft fixing the very serious problem they created, they said we should change the way we update records in our applications. What moron thought that was an appropriate response? Like many other throughout the world, we have a production system with 400K lines of code and you want us to rewrite every update statement because you do not want to roll out a bug fix? Then, someone thought it was a good idea to wait 30 days to fix…6 votes
For updates, this is fixed for almost all channels now (a fix has been available for most users since 11/18).
Right click DUPLICATE a table, query, etc. Instead of Copy/paste.5 votes
queries, reports, forms1 vote
Seria necesario que las tablas de accces se puedan visualizar en Power Point sin necesidad de macros (Sin codigos). y tambien en slideshow1 vote
- Don't see your idea?