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.

  1. 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.

    16 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…)
      12 comments  ·  Other  ·  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…

      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…)
        3 comments  ·  Other  ·  Admin →
      • STOP Teaching Students BAD Practices

        OK I get it... you supposedly don't need to be a developer to use Access and that's great. But really you should stop training everyone who doesn't know any better that it's ok to do things like place spaces and weird character in object names. It will eventually bite you even within Access as soon as you move to VBA or a SQL Server backend.

        Just because it can be done doesn't mean it should. It's just all around bad practice and eventually everyone who continues on to use Access will learn the hard lesson that is not taught in…

        14 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…)
          5 comments  ·  Other  ·  Admin →
        • Enable Password Decryption using a different Password

          Users having the ability to Decrypt the Database is a huge security liability. Unencrypted databases enable Remote Queries which are very simple to create. Even the System Tables can be access by Remote Queries from another database.

          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…)
            5 comments  ·  Other  ·  Admin →
          • Create a new Requery method which returns to the current record

            When you requery a form after updating another form or another table, Formname.Requery goes to the first record. On a continuous form it is a real nuisance to have to return to the original record. We need a Form.RequeryReturn function to bring us back to the original record. Obviously, isf the record is deleted it should return to the previous record.

            66 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…)
              4 comments  ·  Other  ·  Admin →
            • Integration with Cortana for navigation purposes

              Add navigation commands such as “Open”, “First Record”, “Next Record”, “Previous Record” and “Last Record”.
              The “Open” command would be followed by the Form or Report…”Open Sales Order”…”Open Purchase Order”.
              If possible a “Find” command would really rock. “Open Contact Maintenance”, “Find Jane Smith”.

              These commands would be very useful in a mobile environment.

              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…)
                1 comment  ·  Other  ·  Admin →
              • Make Access an SDI program

                I mis-wrote yesterday. What I propose is that Access offer an SDI user interface - Forms etc.. don't have to be modal and display in separate windows. Word and Excel have been upgraded to that mode of display, why not Access.

                6 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…)
                  2 comments  ·  Other  ·  Admin →
                • VB Code References Dialog Box should be sizable

                  If we open any VBA module (either a module or the one in code-behind-forms), one of the choices we have is pointing the Jet or Ace engine to the correct Reference Library. This dialog box is very small and should be bigger by default. Ideally it should be sizable and Access should remember the size where we left it. That would be NICE!

                  19 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…)
                    2 comments  ·  Other  ·  Admin →
                  • Add a suffix to copies of objects instead of the prefix 'Copy of '.

                    When a copy of an object is made, 'Copy of ' is added to the front of its name, separating it from the original when sorted alphabetically. It would be much easier to find the copy in relation to the original if a suffix was used instead. That way it would be right after the original object when sorted alphabetically.

                    75 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…)
                      9 comments  ·  Other  ·  Admin →
                    • Add a VBA method to the Navigation Pane so the Search Bar text can be cleared or set

                      I have developed a few Access Add-ins that I use to extend the development environment (like a Navigation Pane replacement with features like Access 2003). I'm able to use VBA to select an object on the Navigation Pane, but only if it's visible in the current Search filter. I'd like you to add a method to the Navigation Pane so I can clear the Search Bar, or even better allow me to set the value. Does adding a method like this cause a lot of heartache for the Access team?

                      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…)
                        0 comments  ·  Other  ·  Admin →
                      • Search and replace on all database objects.

                        Queries, Forms, Reports, Macro, VBA, possibly even tables.

                        Today I do this by exporting all database objects to text files, using a utility that I built, and then using a customer text search app that I built to find strings using regex matches. Then I have to go and open the objects and manually make the changes.

                        53 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…)
                          6 comments  ·  Other  ·  Admin →
                        • bring it into conformance with high DPI design standards

                          Need to clean up all the UI to scale properly on high DPI displays. E.g., Navigation pane vertical object spacing, low res navigation pane object and navigation (expand/contract) icons, and "Save changes to the following objects" dialog box.

                          (Hate to spend precious votes on what is basically a set of defects, but there it is.)

                          38 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…)
                            Planned  ·  5 comments  ·  Other  ·  Admin →
                          • Create and promote a website for Access developers to list their applications and services.

                            MS already has a website for Access MVP's, but other ISV's, VAR's and developers who are not MVP's need a centralized place for consumers to search for a solutions provider. MS can provide a disclaimer on this website stating they're not responsible or endorsing any particular listing.

                            .. And while you're at it, create a separate category or page for "Access Marketing" ideas so that we don't have to mix these kinds of ideas with product improvements.

                            59 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…)
                              10 comments  ·  Other  ·  Admin →

                              Thanks for posting and for the interesting conversation.

                              Without taking an active part in this discussion, or making a corporate statement, I’ll just say that the Access team values our MVPs and their on-going contribution to both the product team and the broader community.

                              as for Frank’s suggestion – it’s a great one, and we’ll look into it. Thanks!

                            • Local Help

                              Enable Local Help Files as it used to be. The web help is slow, often leads to incorrect correct.

                              28 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…)
                                3 comments  ·  Other  ·  Admin →
                              • Future of MS Access

                                Hello
                                My post is a general post about which way should MS Access take in the future. I have used Access as a professional tool in my company against large and small companies from the early versions of Access. I believe that this is the most common use of Access although Microsoft from the beginning of the product have added this at the Office package as a low-threshold entry to the database worlds. Microsoft has reduced the availability of Access in its Office suites from early beginnings. In view of this, I mean Microsoft should let go of Access as…

                                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…)
                                  2 comments  ·  Other  ·  Admin →
                                • VBA Application Add-Ins

                                  Create a new type of VBA add-in (*.accda) that loads before the database is loaded, can display its own ribbon and is unloaded after the database is unloaded. This would enable VBA programmers to build application add-ins like in Excel or Word.

                                  7 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  ·  Admin →
                                  • Provide an easy way to share Rich text between Access and other Office Applications

                                    Access 2007 added the Rich Text control so we can store rich formatted text in Access. What it forgot to add was an easy way to share that formatted text in Excel or Word. Please add a means to share the rich text data in at least other Office apps and a easy way to strip the formmatting when exporting to formats like .csv.

                                    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…)
                                      3 comments  ·  Other  ·  Admin →
                                    • Import from Access to hide and ignore Msys tables

                                      If you have set your nav pane options to show system objects, they should not show in the Import list.

                                      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…)
                                        2 comments  ·  Other  ·  Admin →
                                      • file corruption. make access more robust. even with sql server backend is frontend corruption a problem

                                        I would think after all these years MS has a pretty good knowldge about reasons for file corruption. It is quite the joy when The dreaded dialog that deletes Your vba Project appears...

                                        9 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  ·  Admin →
                                        • Support strong-typed nullable data types.

                                          In VBA, we can only store nulls in a Variant data type. But I hate this because this lacks information whether this is a string, a number or date. In SQL, those data types are all nullable but we have to constantly do Nz(), IsNull(), to avoid the nefarious error "Invalid use of Null".

                                          Please make it possible for us to specify a nullable data type so that we also know this can be only either a null or a number (and thus prevent invalid entries of string in addition to writing self-documenting code).

                                          7 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…)
                                            4 comments  ·  Other  ·  Admin →
                                          ← Previous 1
                                          • Don't see your idea?

                                          Access (Desktop Application)

                                          Feedback and Knowledge Base