Feedback by UserVoice

Joe Anderson (Access MVP, aka DatabaseMX)

My feedback

  1. 1 vote
    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 →
    Joe Anderson (Access MVP, aka DatabaseMX) commented  · 

    As a developer, there are so many ways this can be implemented, as well as so many different 'version number' formats, I'm not sure this would be a good use of the Access Product team's time.

  2. 0 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 →
    Joe Anderson (Access MVP, aka DatabaseMX) commented  · 

    Could be useful, although not something I do all that often. And if I do, it's just 1-3 columns. On the flip side, if the column is way down the list, the clear all would be nice - or if you are not sure there are even any columns hidden.

  3. 1 vote
    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 →
    Joe Anderson (Access MVP, aka DatabaseMX) commented  · 

    ???

  4. 1 vote
    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 →
    Joe Anderson (Access MVP, aka DatabaseMX) commented  · 

    Approximate translation:
    ====

    Error consultation with "As" in search

    Good Morning,
    I'm doing a combination between Access and Excel data, according to which I have a query in Access that seeks data with the following formula:
    Material: IIf ([Product] = "Glass", 1, 0)
    When I call this query in Excel from the menu "Data" -> "From Excel" works well, no problem, I returned all the data.
    The problem comes when the Access query use the following formula:
    Material: IIf ([Product] Like "* glass *", 1, 0)
    Then the query works in Access, but Excel stops working, the cells where the results of the formula should appear are blank.
    I tried on several projects and at all the same thing happens when applying the comparison function "Like".
    Could you please check it out and if true give a solution or tell me what I'm doing wrong?
    Thank you very much.

  5. 1 vote
    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 →
    Joe Anderson (Access MVP, aka DatabaseMX) commented  · 

    Approximate translation:

    ====

    Access pantillas

    Would be a good idea restringuido not have access to templates because now those who have the oficee 365 home subscription can not see templates companies

  6. 0 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 →
    Joe Anderson (Access MVP, aka DatabaseMX) commented  · 

    I agree this should be fixed.

  7. 18 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    12 comments  ·  Access (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Joe Anderson (Access MVP, aka DatabaseMX) commented  · 

    Not to be pessimistic, but this is probably not going to happen ...

    Joe Anderson (Access MVP, aka DatabaseMX) commented  · 

    RE: "the number of the codeline that produces the error would be very useful"
    MZTools, among MANY other thihgs ... does Line Numbering. Then, you can use the ERL function in your error tapping / Message Box to display the Line Number of the Error.

  8. 316 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    16 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Joe Anderson (Access MVP, aka DatabaseMX) commented  · 

    Meanwhile ... we have Peter's ShrinkerStretcher ... a truly awesome product which I have used several times ... check out the fully functional demo ...
    http://peterssoftware.com/ss.htm

  9. 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)  ·  Flag idea as inappropriate…  ·  Admin →
    Joe Anderson (Access MVP, aka DatabaseMX) commented  · 

    Well, ok ... but why not just use DoCmd.MoveSize ?

  10. 27 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 →
    Joe Anderson (Access MVP, aka DatabaseMX) commented  · 

    If you create your own Custom Ribbon, you can certainly prevent the Options menu - and everything except a File>>Exit button from showing for that matter ... consequently not allowing access to the Nav Pane.

  11. 3 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 →
    Joe Anderson (Access MVP, aka DatabaseMX) commented  · 

    Slider? Speed?
    What are you referring to ?

  12. 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)  ·  Flag idea as inappropriate…  ·  Admin →
    Joe Anderson (Access MVP, aka DatabaseMX) commented  · 

    FWIW ... you can use Allen's approach, which I have done several times:

    Managing Multiple Instances of a Form
    http://allenbrowne.com/ser-35.html

    Also, instead of Collections, I used the Dictionary Object.

  13. 1 vote
    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 →
    Joe Anderson (Access MVP, aka DatabaseMX) commented  · 

    Just curious as to how this would be useful?
    Seems it could be different every time you run the query ?

  14. 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 →
    Joe Anderson (Access MVP, aka DatabaseMX) commented  · 

    Probably not going to happen because Decompile (exposed by the late, great Michael Kaplan circa 1995-1995) was never intended to be used by developers. Fortunately, Michael brought this to the forefront - resulting in the saving of 1000s of dbs, which otherwise would have remained toast.
    It would be cool if this was an option like C&R however.

  15. 9 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 →
    Joe Anderson (Access MVP, aka DatabaseMX) commented  · 

    +100000000000

  16. 3 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 →

    Thank you for taking the time to post your suggestions. It is hard to respond as there are multiple items in your single suggestion.

    As for charts – we are actively looking into ways to modernize data visualization in Access.

    Stay tuned.

    Thanks,
    Michal [MSFT]

    Joe Anderson (Access MVP, aka DatabaseMX) commented  · 

    Meanwhile ... you might take a look at Peter's Drag N Drop app ... download the fully function demo. I've used it several times and it's nothing short of astounding, as are all of his tools. Demo has List Box examples :-)

    http://peterssoftware.com/dd.htm

  17. 35 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 →
    Joe Anderson (Access MVP, aka DatabaseMX) commented  · 

    Meanwhile ... you might take a look at Peter's Drag N Drop app ... download the fully function demo. I've used it several times and it's nothing short of astounding, as are all of his tools. Demo has List Box examples :-)

    http://peterssoftware.com/dd.htm

  18. 7 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 →
    Joe Anderson (Access MVP, aka DatabaseMX) commented  · 

    MZTools does this and a LOT more. Used to be free, but it's still worth a million dollars ... must have.

    http://www.mztools.com/v8/download_trial.aspx

  19. 6 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Access (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Joe Anderson (Access MVP, aka DatabaseMX) commented  · 

    Do you mean MDI ?

  20. 8 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 →
    Joe Anderson (Access MVP, aka DatabaseMX) commented  · 

    I've never come remotely close to even 255. As already noted ... please give a real life example.

Feedback and Knowledge Base