Feedback by UserVoice

Mark Jaskula

My feedback

  1. 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…)
      4 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
      Mark Jaskula supported this idea  · 
    • 30 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 →
        Mark Jaskula commented  · 

        This would be a great addition instead of what I currently do which is putting a label above it with all that column names, but doesn't really work now for me due to DPI issues ect.

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

            What I'm doing is creatng a VB.Net DLL and adding it as a reference to the Access DB. Create and I/O interface, and get all the riches of Visual Studio with Entity Framework, parallel processing etc.
            No brainer consider the snail's pace progress of fundamental MS Access functionality.

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

              Pitty this won't go anywhere. You can always use SSMS to create your queries and then use passthrough SQL queries using something like the following hack:

              Dim qdf As DAO.QueryDef
              Set qdf = CurrentDb.CreateQueryDef("")
              qdf.connect = "ODBC;Database=tsfe;FileDSN=C:\settings\tsfe.dsn;"
              qdf.sql = queryStr
              qdf.ReturnsRecords = True
              qdf.ODBCTimeout = 0
              Set SQLOpen = qdf.OpenRecordset
              Set qdf = Nothing

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

                One obvious way to improve the Linked Table Manager is to allow Shift key to work so that you can select a range of tables in one go instead of doing Control click on every table, very poor design. Also remove all the sql internal tables not relevant to an Access Database would be a bonus, but the shift select would be a boon.

                Mark Jaskula commented  · 

                You could automate this process. I only link to one SQL server, but no limitation on retrofitting the below hack function:

                Function ReLinkSQLDatabase()
                Dim i As Long
                Dim tableName As String
                Dim rec As Recordset
                Dim r As Long

                For i = 0 To CurrentDb.TableDefs.count - 1
                tableName = LCase(CurrentDb.TableDefs(i).name)

                If InStr(1, tableName, "msys") = False And InStr(1, tableName, "~") = False And InStr(1, tableName, "temp_") <> 1 And tableName <> "name autocorrect save failures" And tableName <> "paste errors" Then
                DoCmd.DeleteObject acTable, tableName
                DoCmd.TransferDatabase acLink, "ODBC Database", "ODBC;DRIVER=ODBC Driver 13 for SQL Server;UID=administrator;DATABASE=tsfe;WSID=razorbladeAPP=2016 Microsoft Office system;Trusted_Connection=Yes;SERVER=razorblade;DESCRIPTION=MSSQL_TSFX", acTable, tableName, tableName, False, True
                End If
                Next

                MsgBox "SQL Relink Completed"
                End Function

              • 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 →
                  Mark Jaskula commented  · 

                  Joe/Mark, I'll give your suggestions a go, thanks. I also redesigning the Access Front end to be more "organic" (some of the code is 15 years old), to not require dynamically generated (or pre-generated) controls to exist.

                  Mark Jaskula commented  · 

                  Hiding/unhiding existing controls is exactly what I do at present, it's just a real pain to create many hundreds of controls for certain "dynamic" forms to cover the worst case scenarios. Just would be nice and easier to programmatically create the correct amount through code in real time.

                  Mark Jaskula commented  · 

                  URL is https://msdn.microsoft.com/en-us/library/office/aa221167(v=office.11).aspx

                  If I'm not mistaken, from my quick test, CreateControl only works when you are in design or layout mode not a live mode. Perhaps you could create a form live using CreateControl and save and open it, but what I'm after is having a pre-existing form where you can dynamically add new controls as you see fit in a live situation.

                  Please correct me if I'm wrong.

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

                        I can confirm Anders comment, it's a fantastic titbit particularly when you get referential integrity errors and want to know the culprit easily.

                      Feedback and Knowledge Base