Feedback by UserVoice

John

My feedback

  1. 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  ·  Access (Desktop Application) » Forms  ·  Flag idea as inappropriate…  ·  Admin →
      John shared this idea  · 
    • 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…)
        John commented  · 

        It is....... setting is "compact on close"

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

                      I noticed this recently when I tried to sync an access table to an azure database. There needs to be an easy way to get the new record ID from a record add into SQL when triggers are firing. My impression is that this may be an ODBC problem but Access needs to be able to figure the right key and supposedly SCOPE_IDENTITY() and NOT @@IDENTITY can work if we can retrieve that value.

                      Thanks for your attention.

                      John supported 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…)
                        2 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
                        John shared this idea  · 
                      • 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 →
                          John commented  · 

                          Yes there is a couple of workarounds as described but taking databases offline whether Access, SQL server or anything else I would not consider "best practices". For those unfamiliar with this behaviour, it can be a bit of surprise.

                          Thanks for your comments.

                          John commented  · 

                          Hi Alphonse, Thanks but I tested in the backend db and it is a problem still in Access 2016 anyway. You can repair and compact but that is not a good work around when dealing with several users who are in the system.

                          John commented  · 

                          @ Dolly. There is no importance to the number. This issue I have is restoring records that have been deleted. When the records are appended back, the autonumber is put to a lower number than the highest existing record so when a user adds a new record, they can get errors because the new record number already exists. I can't take the backend database offline easily so I append another record with the highest record in the table to reset.

                          All I am saying it is not intuitive to have an autonumber value to be reset to a lower value than what is currently based on existing data.

                          Thanks!

                          John commented  · 

                          Hey Mark,

                          Could you point me in the direction to where this behaviour is documented.

                          Thanks.

                          John shared this idea  · 
                        • 24 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 →
                            John supported this idea  · 
                          • 28 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 →
                              John supported this idea  · 
                            • 39 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 →
                                John commented  · 

                                And allow for an image (icon) beside the caption

                              • 21 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) » Other  ·  Flag idea as inappropriate…  ·  Admin →
                                  John commented  · 

                                  As per Joes comment below, if would nice to see the full path and file name of the reference and ideally it should be something we can copy to document or use in code.

                                  Thanks!

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

                                    To clarify, this happens when using datasheet subforms on a main form.

                                    John commented  · 

                                    Users need to be able to control the datasheet columns as they usually unique to each person.

                                    Thanks,

                                    John shared this idea  · 
                                  • 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  ·  Access (Desktop Application) » Forms  ·  Flag idea as inappropriate…  ·  Admin →
                                      John shared this idea  · 
                                    • 27 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) » Local Data  ·  Flag idea as inappropriate…  ·  Admin →
                                        John commented  · 

                                        I would include a field for to define type of note (user notes, developer notes, system generated audit notes) so you could toggle between them if in development mode and only user notes showing when user is running the app.

                                        John 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…)
                                          4 comments  ·  Access (Desktop Application) » Local Data  ·  Flag idea as inappropriate…  ·  Admin →
                                          John shared this idea  · 
                                        • 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…)
                                            1 comment  ·  Access (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
                                            John shared this idea  · 
                                          ← Previous 1

                                          Feedback and Knowledge Base