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.
-
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 voteThank 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. -
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 votesAs 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] -
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 -
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 preferencesLabels as lblNameofControl
Buttons as btnMyNameThis 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 votesThank you for posting.
Unfortunately, enforcing a standard way of naming objects isn’t something we see high value in.
Regards,
Access Engineering -
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 votesExcel 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?