Feedback by UserVoice

AdminMicrosoft Access Product Team (Microsoft Access Product Team, Microsoft)

My feedback

  1. 226 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    24 comments  ·  Access (Desktop Application)  ·  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,
    Ebo [MSFT[

    An error occurred while saving the comment

    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,
    Ebo [MSFT[

  2. 30 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…

    An error occurred while saving the comment

    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 consider investing more in improving the SQL integration experience instead of also providing the CDS route. Please let us know thoughts!

  3. 17 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 →
  4. 396 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 →
  5. 22 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Access (Desktop Application) » Forms  ·  Flag idea as inappropriate…  ·  Admin →
  6. 22 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
  7. 35 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Access (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
  8. 170 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Access (Desktop Application) » Cloud  ·  Flag idea as inappropriate…  ·  Admin →
  9. 9 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment

    When you add a new number field, the Default Value property is set to 0, but you can change that (either in table design view in the lower property pane, or table datasheet view using the Default Value button in the Fields ribbon).
    Is that not sufficient?

  10. 29 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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

    It's true that applying formatting to a field in a continuous form or a column in a datasheet applies to the control in every row, but that is not true for conditional formatting. If you set background color, for example, to a different color based on a value, it applies to the controls only in those records that match the criteria. Am I misunderstanding what you are asking for?

Feedback and Knowledge Base