AdminMicrosoft Access Product Team
(Microsoft Access Product Team, Microsoft)
My feedback
-
235 votes
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 -
37 votes5 comments · Access (Desktop Application) » External Data Connectivity · Flag idea as inappropriate… · Admin →Need more info ·AdminMicrosoft Access Product Team
(Microsoft Access Product Team, Microsoft)
responded
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=0We 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=0We 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!
-
20 votesAdminMicrosoft Access Product Team
(Microsoft Access Product Team, Microsoft)
supported this idea
·
-
412 votes
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.
AdminMicrosoft Access Product Team
(Microsoft Access Product Team, Microsoft)
supported this idea
·
-
22 votesAdminMicrosoft Access Product Team
(Microsoft Access Product Team, Microsoft)
supported this idea
·
-
22 votes1 comment · Access (Desktop Application) » External Data Connectivity · Flag idea as inappropriate… · Admin →AdminMicrosoft Access Product Team
(Microsoft Access Product Team, Microsoft)
supported this idea
·
-
37 votesAdminMicrosoft Access Product Team
(Microsoft Access Product Team, Microsoft)
supported this idea
·
-
170 votesAdminMicrosoft Access Product Team
(Microsoft Access Product Team, Microsoft)
supported this idea
·
-
9 votes
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? -
29 votes
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?
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[