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. New Linked Table Manager - quick fix for Escape key

    In the new Linked Table Manager, when I click the Relink/Add/Delete/Edit button a dialog is shown. If I press the Escape key, I expect that dialog to close, which it does, but the Linked Table Manager also closes. This behavior is annoying.

    Please change these dialogs so pressing Escape only closes the top window.

    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 →
  2. 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

    9 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 →

    See support.office.com/en-us/article/access-err..

    For updates, this is fixed for almost all channels now (a fix has been available for most users since 11/18).

  3. 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 →
  4. 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.

    3 votes
    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 →
  5. 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 →
  6. 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 →
  7. Bug fix needed for MS Access Update queries with WHERE clause

    Bug fix needed urgently!

    11/12/19 Office ProPlus 365 Update broke Access UPDATE query with WHERE Clause.

    Queries without WHERE clause still work.

    Can be recreated in new mdb or accdb database with single table. Write a query that tries to Update a value in the table. If the query has a Where clause, the query fails with a message of:

     Query 'qryName' is corrupt
    

    The database is NOT corrupt. Moving the database to another machine that has not been updated with today's Update (16.0.11328.20468, depending on Channel type), allows the query to work.

    Query fails whether table is in the…

    186 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    50 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  8. SIMPLE TRAINING QUESTIONS

    I CANT FIND ANYONE TO HELP ME WITH A SIMPLE QUESTION ON USING ACCESS. VERY FRUSTRATING. YOUR TRAINING M ODULES ARE OF NO HELP. I CALLED MICROSOFT AND NO ONE COULD HELP ME.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. 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 →
  10. Presentacion de tablas de access en Power Point

    Seria necesario que las tablas de accces se puedan visualizar en Power Point sin necesidad de macros (Sin codigos). y tambien en slideshow

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  11. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Mobile  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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 →
  13. 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 →
  14. 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 →
  15. 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 →
  16. 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.

    19 votes
    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. 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 →
  18. 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 →
  19. 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 →
  20. 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 →
  • Don't see your idea?

Access (Desktop Application)

Categories

Feedback and Knowledge Base