Feedback by UserVoice

Mark Jaskula

My feedback

  1. 31 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Mark Jaskula supported this idea  · 
  2. 43 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    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  · 
  3. 2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Mark Jaskula shared this idea  · 
  4. 250 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    12 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for the feedback. These requests have been an ongoing discussion with the team, both internally and externally. Especially with our continuously increased focus on establishing a stronger Access-SQL experience, we do plan to have some requests on this work looked further into within the next year. We will keep you posted with specific feature designs in scope as well as timelines. In the interim, you can continue checking our public roadmap for feature updates.

    An error occurred while saving the comment
    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.

  5. 364 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    17 comments  ·  Access (Desktop Application) » Queries  ·  Flag idea as inappropriate…  ·  Admin →

    The Access team is adjusting our status for this request – we are planning to embed the Monaco Editor (support for SQL Editor improvements) into Access, to be released within the next semester (first half of 2021), which will provide capabilities such as syntax highlighting, IntelliSense, SQL comments, and more. We are excited to have this capability released by next year, and we appreciate the energy and enthusiasm on this feature request. We still have a long ways to go to improve our experience with SQL, so please stay tuned as we execute on this objective!

    Thanks,
    -Access Product Team

    An error occurred while saving the comment
    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

  6. 3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    7 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    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.

    An error occurred while saving the comment
    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.

    An error occurred while saving the comment
    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  · 
  7. 413 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    26 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for your feedback. The Access team is currently looking into resizing Access applications, starting with forms. We will provide you with a notification when this is available, and will continue to work on additional resizing/zoom support within different areas of the product at a later time.

    Mark Jaskula supported this idea  · 
  8. 5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Mark Jaskula shared this idea  · 
  9. 11 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    An error occurred while saving the comment
    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