Feedback by UserVoice

Dolly

My feedback

  1. 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…)
      7 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
      Dolly commented  · 

      You can add control dynamically through VBA using the CreateControl Method (https://msdn.microsoft.com/en-us/library/office/aa221167(v=office.11).aspx). Does this not do what you need?

    • 0 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  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
        Dolly shared this idea  · 
      • 2 votes
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          1 comment  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
          Dolly commented  · 

          I agree with the suggestion, but have no votes left.

          Here's a function I found a while back to disable it throughout all the forms of the database.

          Sub DisableDatePicker()
          On Error GoTo Error_Handler
          Dim ctl As control
          Dim frm As AccessObject

          For Each frm In CurrentProject.AllForms
          DoCmd.OpenForm frm.Name, acDesign

          For Each ctl In Forms(frm.Name).Form.Controls
          Select Case ctl.ControlType
          Case acTextBox
          ctl.ShowDatePicker = 0
          End Select
          Next ctl

          DoCmd.Close acForm, frm.Name, acSaveYes
          Next frm

          Error_Handler_Exit:
          On Error Resume Next
          Set frm = Nothing
          Exit Sub

          Error_Handler:
          LogError Err.Number, Err.Description, _
          sModName & "/DisableDatePicker", _
          , True
          Resume Error_Handler_Exit
          End Sub

        • 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…)
            4 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
            Dolly commented  · 

            I long ago ditched the status bar (far too small that users simply don't even notice it) and started to use a form which I control the visibility of a series of texboxes (colored background) which simulate a progress bar very nicely. I open it modal/pop-up while processing various things and the users can see the progress and can't miss it.

            All of this to say, I think Alan is correct that there are some very good alternative already out there and they're probably better than any MS will put forth.

            It doesn't hurt to make the request, but don't let that stop you right now from implementing a solution.

            A Quick Google finds many solutions:

            http://www.utteraccess.com/wiki/index.php/Progress_Meter
            http://stackoverflow.com/questions/11956834/progress-bar-in-in-ms-access
            http://www.granite.ab.ca/access/progressbar.htm

          • 7 votes
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              3 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
              Dolly commented  · 

              +1 I'd vote but no votes left.

            • 11 votes
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                5 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
                Dolly commented  · 

                Look at the post and samples provided by Daniel Pineault found at: http://www.utteraccess.com/forum/index.php?showtopic=1992179&st=0&p=2276028&#entry2276028

              • 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…)
                  9 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
                  Dolly commented  · 

                  I agree with Mark. Since PK have no meaning, the fact that they jump should have no importance.

                  Performing a C&R resets them to the greatest taken number, so you could always do that to get back into sequence.

                  You seem to have a specific scenario in which you are reliant on the values of autonumber which seems wrong. Why not create your own numeric field then you can populate it as you see fit with whatever sequence you wish.

                • 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  ·  Access (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
                    Dolly commented  · 

                    Valid point George.

                    Dolly commented  · 

                    Same idea as https://access.uservoice.com/forums/319956-access-desktop/suggestions/14833125-buy-fishers-find-and-replace-and-incorporate-it . Make real suggestions for features, rather than buy this, ... Say we need a better Find and Replace Utility that work throughout the entire databse, .... Say, improve VBE/VBA to enable better error reporting to automatically include Module Name, Procedure Name, Line Number instead of buy this....

                    Considering the level of engagement MS has put forth on this site's suggestions, I wouldn't hold my breath on this one!

                  • 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…)
                      3 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
                      Dolly commented  · 

                      "Storing the path would NOT work on a different machine" why not? Create a subdirectory in the db directory to house your files and copy the whole thing. I VBA you can easily reference such files.

                      Another alternative is to house them in a table and then at runtime extract them locally to use them as you need.

                      Either way, there truly is no problem here.

                    • 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…)
                        3 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
                        Dolly commented  · 

                        +1 here, but out of votes!!! If you want to set default value on fields, then you should give us the ability to define what the default values will be, but 0 would not be one in my books.

                      • 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  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
                          Dolly commented  · 

                          You can already incorporate various HTML editors directly through the native webbrowser control.

                        • 0 votes
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            1 comment  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
                            Dolly commented  · 

                            A properly designed database does not fluctuate in size too much. Normally such fluctuations and bloating are indication of errors in design/usage, such as the use of temporary tables, repetitive insertions/deletions, the use of attachment data types, etc.

                          • 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…)
                              4 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
                              Dolly commented  · 

                              At the very least report them in plain English.

                            • 0 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  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
                                Dolly commented  · 

                                This is what a library database is useful for. You place your procedures in it and link it like a reference and then you have only one place to make changes, push out an update of your library and all your dbs are updated and in synch.

                              • 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…)
                                  1 comment  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
                                  Dolly commented  · 

                                  A lot, if not all, of this can already be done using proper table design, validation rules, input masks, formats.

                                • 0 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  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
                                    Dolly shared this idea  · 
                                  • 13 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  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
                                      Dolly shared this idea  · 
                                    • 41 votes
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        4 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
                                        Dolly commented  · 

                                        I would vote, but am out of votes, beyond which, based on what we have seen on this site (number of submitted suggestions vs Not Planned vs Planned/Done, I've basically given up on this site. It was obviously another PR game played by MS and it worked! People are talking and MS is simply not listening.

                                        But you aren't wrong for asking for a proper solution rather than a workaround!

                                        Dolly commented  · 

                                        Just build your own Tab controls, a series of Label, command buttons, ... They all work fine and then you use their click event to control what is visible. Very easy to implement and works flawlessly.

                                      • 7 votes
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          1 comment  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
                                          Dolly commented  · 
                                        • 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…)
                                            1 comment  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
                                            Dolly commented  · 

                                            Delete this suggestion and instead add your vote to the existing suggestion found at: https://access.uservoice.com/forums/319956-access-desktop/suggestions/11147169-enhance-the-sql-editor

                                          Feedback and Knowledge Base