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. Document the LoadFromText and SaveAsText methods

    There are two undocumented methods, SaveAsText and LoadFromText, which were originally used for the old SCC integration. Since Access 2013, the source code integration has been removed and we now rely on third party tools (e.g. OASIS-SVN or Ivercy being example). It is my understanding those still rely on the undocumented methods. This request is to ask that Access team document those methods and thus make it supported so that those tools can continue to count on it being available and provide a solution for source code without taking any resources from Microsoft.

    15 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
    • VBA Updates

      '~~~~~~~~~~~~~~~~
      VBA Native line numbering
      '~~~~~~~~~~~~~~~~
      Adding line numbers is something that is a pet peeve. Line numbers should be Native and error trappable by default without having to add them manually.

      '~~~~~~~~~~~~~~~~~~~~
      VBA Accessible Call Stack
      '~~~~~~~~~~~~~~~~~~~~
      A way to read from the call stack, function/sub names in order accessed, times accessed...etc

      '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
      VBA Custom Toolbars to allow custom Macro/Function Calls
      '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
      If I could add my ow custom functions as a toolbar button and have my toolbar exportable and importable for others to use. As opposed to a full Add-In.

      '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
      VBA button and/or right click to open…

      5 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        2 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
      • 4 votes
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
        • To make it possible to make / maintain Table triggers via VBA

          In stead / top of datamacros it would be very nice to have the ability to manage table triggers via VBA (like forms); easier to maintain, all the code in 1 place and more tools/functions etc available.

          1 vote
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
          • 10 votes
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
            • Update the access.Please fix the problem and looking the problem to finding a soution as soon as

              fixing the access Especially
              Create a blank Access Desktop Database (Database.accdb).

              I can't open

              1 vote
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
              • Give us a PDB (Program Debug Database) as in VS

                What I would welcome most is line number information on errors. We all know about error numbers that are not always "self-explanatory"...

                6 votes
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                • make Access easier to use

                  I have an idea that will make (Access) better (easier to use).
                  it will take more than 25 words to explain my suggestion.
                  ?how can I present my idea to someone at Microsoft?
                  jerry gentry (waØh) .. programming professionally since 1963
                  jerrywa0h@sbcglobal.net

                  1 vote
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                  • Access Professional 365 and Access Desktop Two new versions

                    Draw a line under the product. Create 2 products:
                    Express/User version which ONLY has macros. (no VB projects)
                    The express version can be further tweaked to prevent creation of multi user projects

                    Professional/Enterprise Developer version for Developers

                    with the some stripped out features put back

                    The Pro version features:

                    1.The this version should also allow simple targeting of Mobile devices.
                    2.Source control
                    3.AZURE SQL and SQL Server projects

                    This will Sell MORE cloud services

                    4.Improve the crappy forms projects so they are as good as VS.NET (Express....)

                    5.Improve reports and integrate with SQL Server reporting.
                    Create PDF reporting

                    6.Scrap the…

                    1 vote
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                    • Fix a bug in the Application.PlainText() method

                      I found a bug in the Application.PlainText() method. This method "Strips the rich text formatting from a string and returns an unformatted text string."

                      I don't know where else to report a bug like this. I reported the CTRL+A SQL editor bug to UserVoice and it was fixed.

                      I am writing a SQL formatter that will adjust the layout and colorize a SQL statement in a Rich Text box. I expect PlainText() to remove Rich Text formatting without corrupting the SQL statement.

                      You can reproduce this bug in the Immediate Window.

                      ? PlainText("SELECT Record_ID,<BR>'Hello ' & Name")

                      correctly returns:

                      SELECT…

                      1 vote
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                      • Shamsi Calendar

                        Why Microsoft Attached Hijri Calender To Access Application But Forget To Make A Jalali Calendar ... Hijri Is For Arabic People Not For Persian ... I Think Microsoft Can Provide It Or Get Function From Iranian People For DateDiff Or DateAdd

                        1 vote
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          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
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            0 comments  ·  Other  ·  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
                              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
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                0 comments  ·  Other  ·  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
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                                • Put more Access 2007 Background Colour in Access 2016

                                  We find that the background colour selection in Access 2016 are way too restrictive (blinding white). Access 2007 has a light blue background and is pleasing to the eye. Would it be possible to include in Access 2016 along with other colour options?

                                  8 votes
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Navigation Control Bug Causing State Loss and VBA Project Reset

                                    Clicking on two different tabs of Navigation control each tab containing a subform is causing state loss in the VBA environment. Running code is reset, all static and object references are lost.

                                    1 vote
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Developer helpers

                                      1. Fix all the tiny dialogs to at a minimum be sizable.
                                      2. Modify the linked tables manager to sort by data source. Since you can only relink one datasource at a time it makes absolutely no sense to sort alphabetically, especially when the window is so small that you can't even read half the table names, either do this easily by sorting by data source or even better by creating a source drop down and using that to filter so the form only shows tables from a particular source. I have a sample I created for my own use…

                                      1 vote
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Buy out EverythingAccess.com's vbWatchdog add-in and incorporate it into VBA

                                        Error-handling: Buy out EverythingAccess.com's vbWatchdog add-in and incorporate it into VBA. It makes error-handling so much easier and much like that in .NET.

                                        18 votes
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          12 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Please stop Access 2013 from automatically changing the Modified Date on Access files if no changes are made to a file

                                          I have Office Professional 2013.

                                          I have it installed on an Asus Laptop running Windows 8.1.

                                          Also OP 2010 on Windows 7.

                                          I open 99% of my files through "File Explorer" as I have several thousand (files) sorted into numerous sub-folders.

                                          Whenever I open an Access file to check some details and then close it WITHOUT MAKING CHANGES "File Explorer" shows that Access has automatically changed the "Date Modified" to the most recent date and time that I open and then close the file.

                                          This is despite the fact that the last time I may have made a change whether…

                                          14 votes
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            6 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3
                                          • Don't see your idea?

                                          Access (Desktop Application)

                                          Feedback and Knowledge Base