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. In some Access export commands path length is limited. Could you remove those limitations?

    In some Access export commands path length is limited. Could you remove those limitations?

    ' works:
    DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "Mitarbeiter", "C:\Users\Gerrit.Viehmann\Desktop\Very looooooooooooooooooooooooooooong directory\Very loooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooong filename.xlsx"
    ' Error 2006:
    DoCmd.TransferText TransferType:=acExportMerge, TableName:="Mitarbeiter", FileName:="C:\Users\Gerrit.Viehmann\Desktop\Very looooooooooooooooooooooooooooong directory\Very loooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooong filename.txt"
    ' works. Add one ‘o’ and it doesn’t:
    DoCmd.TransferText TransferType:=acExportMerge, TableName:="Mitarbeiter", FileName:="C:\Users\Gerrit.Viehmann\Desktop\Very looooooooooooooooooooooooooooooooooooooooooong filename.txt"

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for posting.
    The limitation in this case is on the filename itself, not the path. For file types, the database engine treats the file name as the table name in an external data source, so it enforces the limit on table name length, which is 64 characters.
    At this point we have no plan of changing such a fundamental behavior in Access.

  2. Re-Instate Pivot table view in Access 2016

    Please restore this feature, clearly by the number of ignored CUSTOMER requests in the past to restore, you clearly dont value your user are are technically unable to honor their wishes !!!

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →

    As you are probably aware, Pivot Charts and Pivot Tables have been removed from Access 2013 because the technology they relied on was deprecated (Office Web Components).

    Since Pivot Charts as we all know them, will not come back to Access, we are updating the status accordingly and would like to encourage you to continue and use your free votes to support other suggestions.

    Thanks,
    Michal [MSFT]

  3. Collecting Data via Email

    this feature was removed from office 2013 and I dont understand why as its much easier for users to fill out a form that comes as outlook email.
    Don't see any other feature we can use that are as simple and straight forward as that!

    52 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    No Current Plan  ·  1 comment  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
  4. Naming

    Naming rules
    When creating forms and report Access use the standard naming
    Labels as LabelsXX
    Buttons as CommandXXX
    And so ON
    What users do is that they rename this after own preferences

    Labels as lbl_NameofControl
    Buttons as btn_MyName

    This naming option should be customizable for each user so they can set their own rules for how the labels or buttons or other controls should get their name in MS Access

    30 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
  5. Fix Docmd.Transferspreadsheet

    Microsoft Access and Microsoft Excel you would think would be hand in hand... but the problem has persisted for years that it has always been problematic getting the correct data types between Access and Excel columns when Importing and Exporting to and from Access to Excel and vice versa.

    69 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →

    Excel doesn’t support data types which makes it very hard for Access to recognize data types from Excel when importing.
    When using the wizard to import data from Excel, you can determine the column types and save the steps – this could be a workaround to mitigate the issue.

    Access Team.

  • Don't see your idea?

Access (Desktop Application)

Categories

Feedback and Knowledge Base