Feedback by UserVoice

isladogs

My feedback

  1. 2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Access (Desktop Application) » Forms  ·  Flag idea as inappropriate…  ·  Admin →
    isladogs supported this idea  · 
  2. 388 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    23 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    isladogs commented  · 

    Potentially, that's excellent news.
    If you can add support to zoom forms & reports in design view that will be great.
    In the meantime I will continue to use my automatic form resizing & zoom form functionality as that works well: http://www.mendipdatasystems.co.uk/automatic-form-resizing-1/4594554784

    An error occurred while saving the comment
    isladogs commented  · 

    I also have free code to automatically resize forms. This is based on open source code originally written by Jamie Czernik back in 2003. However it has been extensively updated since to allow for different monitor form factors, tabbed documents as well as overlapping windows and now also includes a zoom form feature.
    For a full explanation, sample database and all necessary code, see my automatic form resizing tutorial at http://www.mendipdatasystems.co.uk/automatic-form-resizing-1/4594554784

    isladogs supported this idea  · 
  3. 57 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Access (Desktop Application) » Queries  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    isladogs commented  · 

    Crosstab queries are still available in Access
    You may be confusing them with Pivot Tables/Charts both of which were deprecated in A2013

  4. 6 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    isladogs commented  · 

    BigInt support already exists as an option in Access 2016/2019/365.
    However, once switched on, the database cannot be opened in earlier versions of Access.
    Better to leave it as an optional item

  5. 5 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Access (Desktop Application) » Forms  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    isladogs commented  · 

    A common reason why this fails is if you have another hidden control partly or wholloy covering the control whose control tip text you want to see.
    SOLUTION: move the hidden control to the back

  6. 2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Access (Desktop Application) » Queries  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    isladogs commented  · 

    A View SQL menu item already exists in design view. However that means first opening in design view then switching. This means two button clicks rather than one
    It isn't currently possible to directly open a query in SQL view (unless it is a union, passthrough or DD query.
    Please can a View SQL option be added to the right click context menu for all queries

  7. 4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Access (Desktop Application) » Local Data  ·  Flag idea as inappropriate…  ·  Admin →
    isladogs supported this idea  · 
  8. 17 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    isladogs supported this idea  · 
  9. 29 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)

    This is great feedback that we are actually working on providing now. Using the comments below, we’d love to hear thoughts about solely focusing on SQL as a stepping stone to Power Apps for data migration purposes, or also investing in another way for you to connect to Power Apps through the Common Data Service (CDS). This database allows you to store, share and manage your data over the web, and eventually the phone (current MS investment). CDS is also Power Apps’ central underlying storage unit, as well as the entire Power Platform team’s key investment.
    Please see following link for information about CDS, and let us know: if Access created a data export & linked table capability from our platform to CDS, would you use it?:
    https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowerapps%2Fmaker%2Fcommon-data-service%2Fdata-platform-intro&data=04%7C01%7CEbo.Quansah%40microsoft.com%7C32c26c86b7fe4f3162a508d7f069896d%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637242208373640123%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C-1&sdata=GuvQ6o2aqKiBMs%2B1z2nvv0sNtAHNl8MPQqiOvsh0D1U%3D&reserved=0

    We will still continue to make investments in SQL connection either way, but we are also happy to…

    isladogs supported this idea  · 
  10. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    isladogs shared this idea  · 
  11. 16 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    isladogs commented  · 

    Hi Anders
    Yes of course there are many legitimate uses for importing/exporting data using VBA.
    However, when an FE is distributed as an ACCDE, I think it less likely that end users will be doing that. What I'm requesting is an option to prevent tables/queries being copied/ exported /imported to/from ACCDE files when these are created
    I am in no way disagreeing that for higher level security SQL Server should be used

    isladogs shared this idea  · 
  12. 340 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    15 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

    isladogs supported this idea  · 
    An error occurred while saving the comment
    isladogs commented  · 

    Also allow users to move direct to SQL view from the ribbon rather than first selecting design view

  13. 114 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    An error occurred while saving the comment
    isladogs commented  · 

    I've previously voted for similar suggestions:
    a) add a JSON.dll
    b) add an Access equivalent of Excel Power Query (Get & Transform)

    However, its done, the important thing is that it is done.
    In the meantime, I will continue / developing using my JATFA (JSON Analyse & Transform for Access) app which is available from http://www.mendipdatasystems.co.uk/json-analyse-transform/4594138310

    Of course, if MS adds this functionality, my app may well become redundant

Feedback and Knowledge Base