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.

I suggest you ...

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Table links for Volunteers and Employees which you can assigned to various events

    Process should offer tables therefore allowing assign staff (volunteers & employee) to an event.

    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 →
  2. Export / Import VBA IDE settings (including editor format)

    Export / Import VBA IDE settings (including editor format)

    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 →
  3. Create a new Comprehensive Windows Installer for Access Applications.

    Access needs a quick way to get a good solid installation of Back-end and Front-end databases including a registry edit for Trusted locations and versioning.
    It should also include the ability to:
    Add Icons,
    Add Desktop and other shortcuts,
    Allow user to accept an ELUA (End User License Agreement)
    Run simple scripts,
    Install with full windows trust. (maybe with a certificate?)
    An uninstaller.
    A check for updates function.
    Install support files into specified folders.
    Read simple system values and react accordingly (eg if 64bit systems then install 64 bit ODBC Driver)

    Also it would be nice if it could notify…

    86 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 →
  4. Make the 'Compact and Repair Database' function automatic on saves

    Access file sizes grow rapidly, even if there's no database in use. PC's are fast enough to do the Compact and Repair function with very little delay in saving files. At least make it an option in the Current Database settings.

    4 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 →
  5. try

    create a field to type in my own reminders with a due date

    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 →
  6. Fix Access object executing

    While MS Access is executing code during the object's event, all other events of the object are locked, so they will not be fired.

    Let's say we have the Microsoft Calendar Control 8.0 ( mscal.ocx ) placed to a form and we have the code:
    Private Sub Calendar1_Click()
    Calendar1.Month = 1 + (Calendar1.Month) Mod 12
    End Sub

    Private Sub Calendar1_NewMonth()
    MsgBox "Calendar1_NewMonth event" & Calendar1.Month
    End Sub

    The sample should displays a message box when the user clicks the control. In MS Access, the message box never occurs, as the NewMonth event is called during the Click event. If the…

    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 →
  7. SendObject with html template

    As Sendobject is the unique way to bypass warning security, when will MS fix the bug on docmd.sendobject with html template or provide a real exemple whom works with vba code.

    Does't work under office 2010, 2013, Office 365

    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 →
  8. Provide an Option to Disable the Outlook Warning when using EMailDatabaseObject

    It would be useful to be able to disable the Microsoft Outlook warning that reads "A program is trying to send an email message on your behalf...".

    We currently have to use third-party application such as ClickYes by Context Magic to enable automatic emailing.

    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 →
  9. SendObject - Select the sending mailbox

    For mailing, to have as option the sending mailbox and the target folder to store the email

    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 →
  10. Improve the Event Model

    We have to develop obscure workarounds for simple Events like MouseOver, et al. At least duplicate what is most common in other languages, like JS.

    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 →
  11. Create a distribution mechanism

    This is for applications that use Access as a front-end to SQL Server.

    Create a distribution mechanism in Access where:
    - Developers can release a new version with a version number
    - It automatically creates a secure accde and places it on a file server
    - When a user copy of an accde starts up, the current version can check for a new release
    - If a new version exists, Access closes, the new version is copied, and the new accde restarts

    I have existing code for much of this for my main applications. But I have to rely on…

    8 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 →
  12. Ability to view the Field list in the VBA Code Module

    When you are in the VBA Code Editor, and you want to refer to a field on the form, you have to flip back to the form to find the field name before you can use it.

    It would life so much easier if the field names were listable in the code module in the View option as per the Object Command on the Form's Design View.

    23 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 →
  13. Auto refresh linked tables, when front-end file moved

    Auto refresh linked tables, when front-end file moved. Relink to current folder if back-end not found.
    Best usage is to split front-end from Jet back-end.
    Often we move this 2 files to a new location, but then we have to relink manually. Imho, it would be nice to have an automation\option that detect that we moved the front-end file, and that relink to the back-end in the current new folder (the same as FE folder). Of course it should be optionally, because many times we leave the BE in the same old location on the network LAN. Thanks for reading.

    2 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 →
  14. Remind to ownership automaticly

    We have defined the ownership in database and input it e-mail, so i suggest if we could remind each others when the take is going to overdue date automatic by email

    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. Please provide integration with a Mobile device for Capturing Images & storing them directly into a field

    Hello Team,
    It would be great if we can have a method to directly capture a picture using our mobile phone and have that picture stored directly in the Access database in a specified field. This can help in many industries not just Human Resources.

    Thank you in advance

    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 →
  16. Add Aggregate UDF type to VBA

    Currently writing a UDF to operate on a single record when placed in the formula for the field definition is easy; however there is no way to write a UDF that shows up in the aggregate 'Total' drop down box of a group by query. An example usage would be making a 'JoinASC' UDF which would concatenate all of the aggregated data of the grouped records for the field it was applied to.

    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 →
  17. EXCEL Import via Drag an Drop

    Make it possible to import / link an Excel File/Table via Drag and Drop into MS Access.
    Drag it from Excel - Drop it to e.g. an *accdb.
    MS should asks: Import or Link ... an then do it.

    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. Try to solve the Error 3828 when exporting data from a query to Excel

    I have code exporting data from queries to Excel. All lines but one works. The last line gives the error 3828.
    "Cannot reference a table with a multi-valued field using an IN clause that referers to another database"

    The code line is like this:
    DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "DeliveriesThisMonth", PathToEXTAB, True, "Deliveries"

    But there is no multi-valued field in any of the tables.

    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 →
  19. Allow VBA to set DIsplayControl on linked tables consistently

    Setting the "DisplayControl" property on a field of a linked table using VBA works.

    You can read the value back using VBA, even after closing, compacting and reopening the database.

    Dragging the field onto a form uses the correct control.

    However, the interface still shows the value "Text Box" until manually changed by the user.

    Code:
    With CurrentDB().TableDefs("TABLE").Fields("FIELD")
    Set prp = .CreateProperty(strProperty, "DisplayControl", acComboBox)
    .Properties.Append prp
    Set prp = Nothing
    .Properties("DisplayControl").Value = acComboBox
    End With

    ' You can do this in the immediate window and the value is 111 (acComboBox)
    Debug.Print CurrentDB().TableDefs("TABLE").Fields("FIELD").Properties("DisplayControl").Value

    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 →
  20. Keep trusted location and file across Access version

    When a user trust a file or location, it should be unecessary to re-trust the file or location again after update to new version of Ms Access.

    Two problems with this behaviour:
    1) As mentionend, it is strange for the user having to re-trust Access Application after it is trusted on previous version
    2) I use automation to run utility Access file from main Access app. They reside in same, trusted location as main app. If New version of Access breaks trusted location, then it will not help if user Accepts the main app as trusted - the utility apps…

    8 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 →
← Previous 1
  • Don't see your idea?

Access (Desktop Application)

Feedback and Knowledge Base