Feedback by UserVoice

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.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Problem "Error 3040 Query is corrupt"

    Problem "Error 3040 Query is corrupt" request for fix earlier than December 10. This bug causes a lot of problems for my customers!

    This problem should not be underestimated and is huge.

    KB4484127, KB4484119 en KB4484113

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  2. suggest this workaround for "query is corrupt" error

    I wrote this code snippet (you may have to adjust it to match the tables in your database), and within a minute the whole program worked again. Hope this helps someone else, too:

    Public Sub RenameAllTables()
    Dim dbs As Database
    Dim tdf As TableDef
    Set dbs = CurrentDb
    For Each tdf In dbs.TableDefs
    If InStr(1, tdf.Name, "tbl_") > 0 Then ' this way we don't change system tables
    tdfName = tdf.Name
    tdfNewName = Replace(tdfName, tdfName, "dbo_" & tdf.Name)
    DoCmd.Rename tdfNewName, acTable, tdfName

    strSQL = "SELECT * FROM " & tdfNewName
    Set qdf = CurrentDb.CreateQueryDef(tdfName, strSQL)
    End If
    Next
    End Sub …

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. Develop a mobile version of Access so it can be installed on a lightweight android device.

    Develop a version of access that can be run on a lightweight android device or an application that can be run from the cloud.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  4. 3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  5. Microsoft Accessで、2019年11月の更新プログラムが適用されると、「クエリが破損しています。」というエラーが発生し、処理が動かなくなる事象

    Microsoft Accessで、2019年11月の更新プログラムが適用されると、「クエリが破損しています。」というエラーが発生し、処理が動かなくなる事象が発生しています。

    対応アップデートパッチは
    office2016:KB4484113
    office2013:KB4484119
    office2010:KB4484127
    による現象のようで、当該アップデートをアンインストールしたところ、現象は起きなくなりました。
    また、現象が発生している箇所ではdocmd.runsql文によるクエリ実行を行っており、そのポイントでabendしている様です。
    (ランタイム版でしか動作を見ていないので、厳密にステップ実行トレースしたわけではありませんが。)

    ご確認頂きたいです。
    よろしくお願いします。
    以上です。

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Runtime  ·  Flag idea as inappropriate…  ·  Admin →
  6. Split forms in popup mode getting uncontrollable size

    Split forms in popup mode getting uncontrollable size as they spread out of the screen if the datasheet on bottom. is it Possible to make it desired size.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  7. Put a date on your replies to feedback

    Could you please change the Feedback software so that it shows a date on all of your replies, so that we can see it your reply is current or old.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. Have the ability to save in One drive

    Ability to save in One Drive

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. Un petit bug dans le reporting Access

    I think there is a small bug in Access Reports…
    When a report contains a png or embedded image, this is not printed if you print it directly on the printer. If I create a Pdf, and then print the pdf report, the logo is visible.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  10. make it a little more easy

    kids don't understand this so give some explainment in the app

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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.

    28 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  12. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. give users a warning when an update statement fails to add a new record to a recordset

    When using an update statement (via Excel VBA) to add records to a database no error message is given when the update statement fails to add the record.

    Using a loop to add records to a recordset, when one of the addnew statements fail no error message is given to the users and none of the other items in the loop following the record that fails get processed.

    EG_If the loop has 100 records to add, if the 50th record fails, then the records 51 to 100 in the loop don't get processed. BUT NO ERROR MESSAGE!!!

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
  14. Fix cursor alignment when editing USysRibbons XML text.

    Custom UI xml is uneditable from within Access at the table level, from queries or forms, due to the cursor not being properly aligned with the text. I would love to be able to manage my content controls from within the application, instead of copy pasting the xml from external applications and hiding/unhiding the USysRibbons table. It's not an overly complicated task to validate XML from vba, but the inability to easily edit the text, makes it impossible to incorporate this workflow.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
  15. Add a TreeGrid Control

    A TreeGrid control could be used in forms, or as just a Tree control. This should be a somewhat customizable look and feel.

    40 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  16. please add active/inactive students. also fees collection with bill format.

    need separate active students & Report. also fees collection with bill for the month. if possible due students list. promotion & grade for students.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. 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,…

    18 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  18. Field Properties in Table Design, needs to be on the right, like it is for Forms and Reports

    Table deign is a huge waste of screen real estate - the field property dialog should be on the right side of the screen, like it is in report and form design, with the drop down button right next to the property's text, not on the other side of the screen. Not a single property is longer than the name of the property choices available, and the ones that could be longer, just bring up the Expression Builder dialog anyway. The idea being to get as much usable information on the screen as possible - like all of my field…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. Add a transposed view option to query design - columns and rows swapped.

    The standard view is hard to use... being able to see all of my fields in query design at one time and the very few, rarely used; sort, criteria, table, etc options to one side would be much easier to use/maintain. Too much scrolling and resizing involved. We currently have 6 default row options in a Select query, but can only see 11 fields at the default size meaning any long field names or expressions are truncated or push related fields off the screen, that you need to see while editing the other.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  20. MS Outlook - Add option in Rules to redirect email according to domain extension

    Rules in Outlook allow for a lot of email redirecting, but not by domain extension. I was starting to get a lot of junk email from domain extension, ".de" which refers to the Republic of Germany. I don't have anything to do with that are of the world. I just want to 'mark as read'/delete any email with that domain extension.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Access (Desktop Application)

Categories

Feedback and Knowledge Base