Access (Desktop Application)

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. Enrich VBA, take it out of maintenance mode

    So VBA was put into maintenance mode, Microsoft moved programmers to .NET. That was years ago. Office Desktop apps are still selling with VBA and yet VBA has not been enhanced - the two environments do not compete and I have not seen .NET intrinsically replace VBA and packaged as Office's internal programming language. There are so many ways that VBA can be enhanced. Linq can be added so that we are not typing mutiple quotes in unverified statements isolated in a string. String Interpolation. Managing large chunks of text in strings etc.. etc...

    23 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
    • access 2016 crosstab

      Crosstables should never have been removed.
      It just doesn't make sense to have to export the data to Excel and if the data changes, we need to export again.
      Please bring it back

      17 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        1 comment  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
      • Leave right-click menu searching options available in runtime

        The right-click menu on DS forms contains BOTH design and user elements. Rather than removiing the entire menu in runtime mode, just remove the design options and leave the user-friendly searching features available.

        22 votes
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          0 comments  ·  Runtime  ·  Flag idea as inappropriate…  ·  Admin →
        • Increase visibility when using higher resolutions

          Make adaptations in resizing reports and wizards etc. to ensure readability in higher display resolutions.

          For example in the linked table manager but also when using interactive graphs in forms and some wizards the text becomes unreadable: The line width is too small to show the whole letter.

          If I reduce display resolution it all works fine again.
          Also due to the inability in wizards and linked table manager to change the line width I cant use access at the preferred resolution.

          13 votes
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
          • Dedicated Lookup Control

            Just like a combo but without a drop down button and does not allow editing. It would be bound to a FK but display a selected column from the related table but not be editable and would not have a drop down button.

            This would save having to add related tables to a form's record source when you only want to display a column. And you definitely don't want to allow the user to modify it.

            An example would be on a continuous form bound to tblInvoice, The control is bound to tblInvoice.CustomerID but displays tblCustomer.CustomerName.

            This could possibly be…

            3 votes
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              0 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
            • ComboBox and Listbox Property Enhancements

              Suggest adding properties to allow configuration of ComboBox and ListBox highlighted text colors. Similar to lstOptions.HighlightedText.BackColor = xxx and lstOptions.HighlightedText.ForeColor = xxx

              5 votes
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                0 comments  ·  Flag idea as inappropriate…  ·  Admin →
              • Create a truly locked down FE format

                ULS was a pain and way too many people implemented it incorrectly but it did serve a function which we have lost. People who develop Access apps for others need a way to completely lock down the FE. The .accde doesn't cut it because users can still modify tables, queries, and macros. We need something that acts like the .accdr but which isn't a trick. I understand why creating an .exe is not an option but you should be able to create a "permanent" format that acts like .accdr but which can't be undone by simply renaming the file. That…

                10 votes
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  1 comment  ·  Runtime  ·  Flag idea as inappropriate…  ·  Admin →
                • Allow users to change the default setting for the "Search Fields As Formatted" box.

                  Allow users to change the default setting for the "Search Fields As Formatted" box on the Find and Replace Dialogue form native to Access. Currently it is checked and the user must in-check it manually... My users want it left uncheck by default.

                  2 votes
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                  • Add capability for telephone (#tel:+) hyperlinks in Access Tables

                    Click to dial is available in many applications and all phone apps, but Access does not have the capability to create a clickable Phone hyperlink, as is done for emails. I needed to create a Maro to add this to the current phone field.

                    I would like the capability to create a Phone hyperlink that automatically adds "#tel:+phone number" to the hyperlink, as is currently done for emails

                    2 votes
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                    • Debug Compile Keyboard Shortcut

                      Most Key Controls have simple keyboard shortcuts however Dubug-> Compile does not. This would make using the VBA editor just that little bit more bearable.

                      4 votes
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                      • Fix rendering of VBA UserForms with Parent controls (eg. Frames) in Access 2003+ file formats

                        The Access 2000 mdb format supports VBA UserForms with normal and parent controls, but all database formats beyond Access 2003 (ACCDB) only render UserForms that do not include Parent controls.

                        Being able to reuse UserForms across VBA hosts is a very useful way of reusing code and User Interfaces, but a runtime error (Error 75) occurs when trying to render a UserForm in an ACCDB database format, when there is a Parent control (such as a Frame or MultiPage control) present.

                        Parent controls enable rich functionality and more intuitive UI, but Access fails to render the forms, with an error…

                        24 votes
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          0 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
                        • Create a stand alone file independently version of Access or Runtime and 32 or 64 bit architecture

                          Due to the currently conflicts between versions, I think it would be necessary to create a stand alone file that can be run independently of the version of Access or Runtime and 32 or 64 bit architecture, that the user has installed!!

                          12 votes
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                          • ComboBox and Listbox Property Enhancements

                            Suggest adding properties to allow configuration of ComboBox and ListBox highlighted text colors. Similar to lstOptions.HighlightedText.BackColor = xxx and lstOptions.HighlightedText.ForeColro = xxx

                            1 vote
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                            • compress memo fields with a real compression decreasing the size of the accdb file

                              it would be great if Memo fields would be compressed automatically with a real compression alogorithm. Decresing the file size could increase the Performance and avoid Problems with bloated files.

                              1 vote
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                              • pin to taskbar access db in windows 10

                                Unable to pin to taskbar my access db application

                                1 vote
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                                • 1 vote
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                                  • 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
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      0 comments  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Fix/remove the 'Powered by Microsoft Access' button

                                      Since 2016 clicking the 'Powered by' button in the bottom right corner of the runtime goes to a web page that no longer exists. Looks like it is the same link from Access 2013...

                                      2 minute fix to make things look a little more professional - OR - remove the feature altogether as I don't see the point if you are not going to promote Access.

                                      1 vote
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        0 comments  ·  Runtime  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Refresh tables/queries while in Query Design View

                                        Add a way to refresh the columns listed in tables and queries being shown in the graphical layout of the Query Design View. A right-click, hotkey, or ribbon button would be nice.

                                        This scenario takes place when you are designing a new query that is dependent on other tables and queries. As you are working in Design View, you realize you need to make a change to a dependent table/query such as adding or renaming a column. Without closing the current query, you go and update the dependent object and come back to the open query. Now you want to…

                                        3 votes
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
                                        • term dates

                                          Please add the ability to set term dates, like quarters can be done (so like spring, summer, winter) and possibly add holiday versions as well/customisable amounts.

                                          3 votes
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 29 30
                                          • Don't see your idea?

                                          Access (Desktop Application)

                                          Feedback and Knowledge Base