Add the "Quick Filter" drop down menu that is on columns of a datasheet view as a feature that can be used on continuous form controls7 votes
As some databases get bigger and more complex the need to report also gets more complex. If the structure of the database is very complex, the 55 cm maximum height for a report becomes insufficient and there comes a need to bodge the design by inserting lots of subreports, each with their own limitation in height. This can cause severe difficulties, particularly with page-breaks.
Please remove the height limit.9 votes
The DISTINCT option for aggregate functions is actually missing.14 votes
For the development of modern and user-friendly programs a division of the window (split screen) in MS Access is desirable so that the window can be scaled user-dependent.2 votes
Currently it is a big problem to handle ACCDE files, if your users do have different versions of Access: Full or Runtime, 2010 / 2013 / 2016, 32bit or 64bit. Please support a "low level format" with a higher level of compatibility.6 votes
I would like an option to make tables and queries read-only by default. This would be under Access Options, Object Designers, Table & Query design sections. Two settings:
* Make Tables read-only in Datasheet view
* Make new Queries read-only (Snapshot)
Rationale: I deal with a lot of production data, and it would make my job considerably easier if I could make accidentally changing data much harder. Thanks!3 votes
There are several controls that always in the foreground (eg. Speed, Slider, ..) appear and other controls can not be covered). This is very disturbing when programming.3 votes
Thanks for your suggestion.
Please provide more information about your request.
Also note there is (maybe) a similar request here https://access.uservoice.com/forums/319956-access-desktop/suggestions/10207788-provide-these-3-basic-native-controls-slider-spi – if it is indeed the same, please let us know and we’ll combine the two.
Please provide a new native control for multiselect checkboxes like available in Excel for filtered columns.13 votes
I use the uSysRibbon table and the custom ribbon works. The form it is attached to is unbound. Once the user picks a record from the combo box, I set the recordsource in code. And as soon as I do this, the ribbon CHANGES for no reason. If I bind the form, it's no problem. It is clearly the me.recordset="Select......" code that triggers this.1 vote
The multi-select-comboboxes are great, but only usable with native Access tables. Because I'm working with SQL-Server as backend, I have no use of that.
Please make it possible to store the data within a normal text-field (e. g. as csv or XML). So it would be also possible to use it within tables of SQL-Server or other backends.4 votes
If you do some VBA in endless forms all changes of e.g. properties go to ALL "instances" of that form.
So "rows" in an endless form are not separate objects and can't be handled separately.
Conditional formatting helps (sometimes), but it's only "half of a solution".
Like with .Parent it could be an idea to add .Record(id) to enable individual formatting and computing on single records of an endless form.2 votes
In the VBE show a dialog where i enter the name of my private variable and the datatype to generate the two standard property methods.7 votes
Normally on the left side the developer can select an object. The names of them are too smal on large Screens.3 votes
.Integration of real Treading
-More and better Controls in the GUI (sample, Graphical Checkbox, Dataview with Hovereffect, multiline Headlines and integrated Imagecontrols like an Explorer
-Autocompactfunction in Background
-Expand maximum Databasesize
-Autozoom of Images on Buttons
-Button with Text and Image need a better function for positioning for the Image (like a Tab)
- Windows without frame become a shadow
- Transparentoption for every Control and Form (different Header, Detail and Footer)
- new Framecontrol with Splitter
- every Object become a identity Name so that i can used it without a long path over form and subform ...8 votes
Add a row-id field to all kinds of queries.1 vote
Drag & Drop function, reordering per Drag & Drop endless-formulars, time selector a' jquery - charts like in excel - outlook integration (kalendar object) ... you can take ideas from gambas3 linux there are many good objects3 votes
Thank you for taking the time to post your suggestions. It is hard to respond as there are multiple items in your single suggestion.
As for charts – we are actively looking into ways to modernize data visualization in Access.
Include Macro in Button Wizard for moving forms (and/or Access Application Window) from one monitor to another
Basically, include native support for easy positioning and size of Access Application Window and Forms instead of requiring complicated API calls and code manipulation.1 vote
My name is Yosiki-Tojo.
I sometimes request an improvement of SQL Azure DB of Access Web.
Now, upper limit size of this DB is 1 GB,
This is very small of these day's business application.
Anyone can understand that this is too small.
Now, I have two prospects for Access Web.
One is flower shop chain, other is clothing rental shop.
They have large image datum for customer selection.
However, I can't proposse Office 365 because of this limitation.
I'll hope this limitation will be improve , such as 5GB or 10GB.
Additional fee is OK.
Best Regards1 vote
In crosstab queries besides count, sum, average etc., there is only the possibility to take either the first value or last value as VALUE. There is no support for concatenation of string values. It would be nice to have such a concatenation function or more generally a callback function where the user can decide how to transform the values.2 votes
When exporting report results there are two options for excel output format (95 and 97). Excel is a very effective output format but these two versions seem to cut the size of text to 256 characters (not so useful when the display limit in current versions of Excel for text in a cell is 1024 (even though content stored can be much greater). Would like to see an option for current Excel format.10 votes
- Don't see your idea?