Feedback by UserVoice

John Partyka

My feedback

  1. 227 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
    John Partyka commented  · 

    Even Notepad has a search/replace capability.

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

    Also, please include a search & replace text capability. (This has been requested in other SQL view suggestions.)

  2. 14 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    John Partyka supported this idea  · 
    An error occurred while saving the comment
    John Partyka commented  · 

    It could be a new User Interface option under Access Options, General.

    An error occurred while saving the comment
    John Partyka commented  · 

    The user would choose their mode of course. Beginners (like Jack perhaps) would default to novice and more experienced users could save time and unnecessary pre-processing by choosing expert mode.

    John Partyka shared this idea  · 
  3. 19 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 →
    John Partyka supported this idea  · 
  4. 9 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 →
    John Partyka supported this idea  · 
  5. 9 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 →
    John Partyka supported this idea  · 
  6. 5 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    John Partyka shared this idea  · 
  7. 32 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    John Partyka supported this idea  · 
    An error occurred while saving the comment
    John Partyka commented  · 

    All good suggestions. Another feature I'd like is search/replace capability in the SQL view.

    I see there are other good SQL view suggestions posted on this site that should be combined.

  8. 23 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
    John Partyka commented  · 

    Also, Excel should stop impulsively converting occasional text field values (that look like digits) into numeric values even though the column was defined as text. We use a 4 char encrypted string identifier for our students which Excel often destroys by converting what appear to be exponential numeric values (eg: the text value "45E7" gets converted into a number automatically by Excel).

    John Partyka supported this idea  · 
  9. 12 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 →
    John Partyka supported this idea  · 
    An error occurred while saving the comment
    John Partyka commented  · 

    I'm using my last vote on this one, plus the comment added by Mark Burns. I've wasted too many hours (probably months by now) on trying to find that one bogus row out of 50,000+ others in my input data.

Feedback and Knowledge Base