Access (Desktop Application)
Welcome to the Access Desktop feedback forum! This is the place for users to send us suggestions and ideas on how to improve.
We have partnered with UserVoice, a third-party service and your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.
-
Fix rendering of VBA UserForms with Parent controls (eg. Frames) in Access 2003+ file formats
The Access 2000 mdb format supports VBA UserForms with normal and parent controls, but all database formats beyond Access 2003 (ACCDB) only render UserForms that do not include Parent controls.
Being able to reuse UserForms across VBA hosts is a very useful way of reusing code and User Interfaces, but a runtime error (Error 75) occurs when trying to render a UserForm in an ACCDB database format, when there is a Parent control (such as a Frame or MultiPage control) present.
Parent controls enable rich functionality and more intuitive UI, but Access fails to render the forms, with an error…
24 votes -
24 votes
-
Create a stand alone file independently version of Access or Runtime and 32 or 64 bit architecture
Due to the currently conflicts between versions, I think it would be necessary to create a stand alone file that can be run independently of the version of Access or Runtime and 32 or 64 bit architecture, that the user has installed!!
24 votes -
import from excel
Better control of datatypes when importing from Excel or linking to a worksheet.
Currently the import decides for you using the first few rows, so often you have truncated memo fields when the first few rows are less than 255 char or errors when the first few rows are numeric but later rows are alpha numeric.
When importing into an existing table the import should honor the datatypes in the table.
23 votes -
Create a truly locked down FE format
ULS was a pain and way too many people implemented it incorrectly but it did serve a function which we have lost. People who develop Access apps for others need a way to completely lock down the FE. The .accde doesn't cut it because users can still modify tables, queries, and macros. We need something that acts like the .accdr but which isn't a trick. I understand why creating an .exe is not an option but you should be able to create a "permanent" format that acts like .accdr but which can't be undone by simply renaming the file. That…
23 votes -
Allow custom controls and a gallery
Due to wide variance among different industries, I think Access is best benefited if users are enabled to author and share custom data-bindable controls. That would enable industries to build controls customized to their particular need, and hopefully share with one other, making it easier to develop with Access even for those who don't have the programming expertise to author it themselves. Look at PowerBI gallery as an example of how this can be a success story for Access.
23 votes -
New Property, Filter for Combo Box
Scenario: Product Obsolete.
if product is marked as obsolete then we do not want it to appear on the combo drop down list but still must be visible to display historic data.The Hack involves hiding a second drop down behind the first with a different rowsource, on click of the first we swap focus to the rear dropdown which then retrieves the required value without effecting the bound tables historical data.
Can you apply a filter to a combo box, on focus, for addition of records.
23 votes -
22 votes
-
with accde: create forms and controls at runtime. even reports.
how wonderful it would be to have programmatic access to create forms and Controls at runtime (compiled version)
Even The ability to create and change reports.22 votes -
Create PDF-File with merge function
Create more than one PDF-File from the Report and merge the PDF-File to one PDF-File
22 votes -
State of the Art Replacement for Active X MS Calendar
Everything revolves around time and Microsoft Active X Calendar is(was?) the perfect tool to use in a lot of applications we've prepared over the years. This gem works seamlessly even in continuous forms while current datepickers associated with textboxes won't do and subforms won't do and equally seamlessly integrates with VBA code and queries and control sources SQL. It doesn't work in Access 64 bit so it's about time to come up with a state-of-the-art replacement but even simply enabling it for 64 bit would suffice.
22 votes -
System Resource Exceeded, On Big Table
Can not allways count rows, update fields (ADODB/DAO),
SUCCESS RATE ................ONLY 40-80%...!!!!
BUG, Confirmed by :.......... Deepak Panchal10 - 9,745Points
Microsoft Office for Developers.Access for Developers22 votes -
make set_spapprole work in a VBA context
SQL Server (see https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-setapprole-transact-sql?view=sql-server-2017) has a great security feature to allow an app to assume a security role when connected to the server. This doesn't work from Access VBA. This leaves us having to give permissions to data that users can subvert. Whilst this can be mitigated, if Access could connect using a user account with no permissions, and switch to an app role with the right permissions security would be wonderful. SetAppRole is particular pleasant in that in the context we still know the original user who started the app.
22 votes -
Changing theme in access 365 proplus
It seems not possible to change the theme to black in Access 365 ProPlus. I have installed on another computer Access 365 Home and I can change it there. Further, all other ProPlus applications can be changed to Black. I have set the "UI" in registry editor to 4 which enables the colour options to increase to 4 - Colorful, Dark, Black, and White. only colorful and white are available in Access ProPlus, access home there are all 4 colours available
22 votes -
Cambiar la altura de la fila de encabezado en un hoja de datos
La idea es poder manipular la altura de la fila de encabezado de una hoja de datos para poder darle un alto suficiente capaz de mostrar todo el título de la columna, pero sin cambiar su anchura.
21 votes -
Add capability to call stored procedures with DAO
Please add the capability to call stored procedures in a remote ODBC database with DAO, like it existed in the past with ODBC-Direct-Workspaces.
Pass-Through-Queries are only a kludge because parameters have to be concatenated into the sql string.21 votes -
SQL View - Add replace to edit mode
If in SQL View of a query it is extremely annoying not to have the replace command handy.
20 votes -
add event: Before Leave Record
an event that would be nice to have is Before Leave Record. This would enable a main form/view to ensure there are are actually detail records
20 votes -
20 votes
-
Limits are reached - if I open one more form: Error 3048: Cannot open any more databases
I have 2 reports and 1 form open. Each of theses has complex data sources (with many joins, subqueries...). If I open an fourth report - I get the error message.
I think the limits are to low. Please upgrade them.
20 votes
- Don't see your idea?