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.
-
Coloured Tabs in Tabbed Forms
The only way to make a tabbed form have a colour is to resort to some trick like using a coloured background behind a transparent tab or pasting an image onto it. These cause problems when moving controls around.
It would be nice for the tab control to have the same functionality as a form where one can set the background colour.
41 votesThe team has reviewed this request and seems like different people are commenting about different things.
@Nigel, can you please elaborate what you meant in this request?
-
Make it easier to select and change printers
Especially important if user has runtime Access and/or maybe using an accde file.
40 votes -
Drag & Drop for listbox
I want to drag multiple files from explorer window onto the listbox to add the filenames to the rowsource (tried mscomctl.ocx: huge problem with other programms that register other versions of the ocx-file)
38 votes -
Custom naming on message boxes
When using the vbYesNo message box you can only have 'Yes' or 'No' options. I would like to be able to rename these options. Currently the only way round it is to create a form to look like a message box.
38 votes -
BugFix: Combo Datatype bug
Please fix the combo box RowSource datatype binding bug.
The bug is as follows:
1. Create a table [Table1] with two columns:
- [NumberField], datatype: Number, Double
- [TextField], datatype: Short TextAdd 1 Row to the table:
[NumberField] = 10
[TextField] = "Some Text 10"- Create a combo box:
Set the RowSource of the combo box to this:
SELECT NumberField, TextField FROM Table1;Add a Button to the form: [cmbErrorExample]
Add On Click Event:
If Me.cmbErrorExample.RowSource = "SELECT NumberField, TextField FROM Table1;" Then
Me.cmbErrorExample.RowSource = "SELECT TextField, NumberField FROM Table1;"
Me.cmbErrorExample.DefaultValue = "Some Text 10"
Me.cmbErrorExample.Value = "Some Text…
38 votes -
Fix the comparison of strings with Unicode Latin Extended-D characters
Could you please improve the handling of Unicode Latin Extended-D characters in MS Access queries and filters. Currently, chars in this range (introduced in Unicode 5.1 back in 2008) are incorrectly compared. Thus SELECT (ChrW(42786)=ChrW(42841)) AS Expr1; falsely returns a True value although two different chars are compared. The same is true for any two signs in this Unicode range. The problem only exists in Queries; in VBA Code these strings are compared correctly (except the StrComp function with vbDatabaseCompare option). See MSDN c76d9e5f-adbc-41f3-a2ed-dc25edf34a14
37 votes -
Document the LoadFromText and SaveAsText methods
There are two undocumented methods, SaveAsText and LoadFromText, which were originally used for the old SCC integration. Since Access 2013, the source code integration has been removed and we now rely on third party tools (e.g. OASIS-SVN or Ivercy being example). It is my understanding those still rely on the undocumented methods. This request is to ask that Access team document those methods and thus make it supported so that those tools can continue to count on it being available and provide a solution for source code without taking any resources from Microsoft.
37 votes -
Integrate MS Access with Power Apps
I've been looking more into Power Apps, and I think it would be great for you to work with the Power Apps team to provide a web and mobile solution to what Access can do today on the premises of a server. Because there is unfortunately no web version of Access, maybe Power Apps can help solve this problem? Ideally, we should be able to continue moving (and linking) Access data into SQL and then create a Power App on top of the "Access-created" data from SQL; essentially viewing a Power Application that looks exactly like access but online and…
37 votesNeed more info ·AdminMicrosoft Access Product Team (Microsoft Access Product Team, Microsoft) responded
This is great feedback that we are actually working on providing now. Using the comments below, we’d love to hear thoughts about solely focusing on SQL as a stepping stone to Power Apps for data migration purposes, or also investing in another way for you to connect to Power Apps through the Common Data Service (CDS). This database allows you to store, share and manage your data over the web, and eventually the phone (current MS investment). CDS is also Power Apps’ central underlying storage unit, as well as the entire Power Platform team’s key investment.
Please see following link for information about CDS, and let us know: if Access created a data export & linked table capability from our platform to CDS, would you use it?:
https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowerapps%2Fmaker%2Fcommon-data-service%2Fdata-platform-intro&data=04%7C01%7CEbo.Quansah%40microsoft.com%7C32c26c86b7fe4f3162a508d7f069896d%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637242208373640123%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C-1&sdata=GuvQ6o2aqKiBMs%2B1z2nvv0sNtAHNl8MPQqiOvsh0D1U%3D&reserved=0We will still continue to make investments in SQL connection either way, but we are also happy to…
-
When a query fails due to data type mismatch - tell us what field in the error message.
When a query fails due to data type mismatch or some other field specific error - tell us what field in the error message.
36 votes -
accde should also remove the ablity to modify tables and queries
When one creates an accde database, Ms access 2007 SP3 up to 2016 should also remove the ability to modify tables and queries.
34 votes -
Support PDF output with password encryption like Word
We should be able to generate reports as PDFs with a password. MS Word has an encryption option when saving a Word Doc to PDF.
For security reasons, more and more organizations want to have encrypted data at rest and in emails. ACCDBs support encryption, so it'd be helpful if it's PDF outputs could too.
It should be available from the user interface and as an option programmatically (DoCmd.OutputTo acFormatPDF).
34 votes -
Provide an easy way to share Rich text between Access and other Office Applications
Access 2007 added the Rich Text control so we can store rich formatted text in Access. What it forgot to add was an easy way to share that formatted text in Excel or Word. Please add a means to share the rich text data in at least other Office apps and a easy way to strip the formmatting when exporting to formats like .csv.
33 votes -
bring back replication.
I know it's hard to believe but there are a lot of us in the world (yes, even in the United States) that must occasionally work disconnected from a network. At our site we've nursed Jet 4.0 replication along for as long as we can and now it's starting to break as MS has backed away from supporting it. We are moving to a centralized SQL database with mobile hotspots but there are some places this simply will not work reliably. We will be forced to 'roll our own' replication method or bring on significant additional SQL expertise to see…
33 votes -
Increase the number of table references from 2048
With comprehensive applications, it isn't hard to get the dreaded "Can't open any more databases" error message.
When this message is encountered, bad things happen internally and the database should be restarted.
If this isn't possible, at least give us a handle so we can determine the number the system currently thinks exist.
32 votes -
Make SQL and QBE Smarter
- When a query that selects identifiable rows joins to a query that aggregates data, allow rows in the identifiable part to be updated rather than making the query non-updateable. Extend this to heterogeneous joins so if one table in the join is updateable but another is not, allow updates to the updateable one.
- Stop smothering expressions with excessive numbers of parentheses. There is no reason that I can think of that would require an individual column name to be enclosed all by itself in parentheses.
- Stop reformatting MY SQL strings. I have a work-around for this but it is iffy.…
32 votes -
Allow linked tables to be set to Read Only
When building a system that shares its data with other systems - I've built an ERP system with Access - you often want to share certain Master data (from the HR system for example), but want to keep it that only HR can modify the data.
If we could set linked tables to be read only, that would remove the need for a lot of 'protectionist' coding.32 votes -
Upgrade Access SQL dialect to current ANSI standards
MS Access's ACE SQL engine continues to run with a variant form of ANSI-89 with some ANSI-92 features while the rest of the relational database world has adopted more recent ANSI standards and at the very least fully comply to the universal, lowest common denominator standard accepted in the industry: ANSI-1992.
Being a highly used, worldwide database for small to medium-sized shops and its popularity with the Office suite, enhancing Access's dialect to industry standards will add value to current and future users including the Microsoft brand. Even SQLite, a similar, very popular file-level database as open-source counterpart to Access,…
32 votes -
Editable Crosstab Control (Bound to underlying tables)
My idea is similar to the one called "Provide a native grid control similar to the visual studio gridview or even the old flexgrid" EXCEPT I want it to be a BOUND crosstab that is editable. This blog describes how to fake an editable crosstab, but it is a lot of work http://alisadev.blogspot.com/2009/06/how-to-fake-editable-crosstab-in.html. My best example is that for a school, they want to view the grades in a grid, but be able to edit them. Classes go down the side, Quarters go across the top, and Grades will be in the middle. When the user is hand-entering the…
31 votes -
All the 32 bit dll and ocx should work in 64 bit os and office
We are working with 32-bit add-ins for access. But it is not possible to work in 64 bit system which I am using.
31 votes -
Allow Wrap Text (like in Excel) for the headings in Datasheet view
Often the Datasheet heading is much longer than the values in the column under the heading. Making the column narrower (to see more columns) means I can no longer read the heading.
31 votes
- Don't see your idea?