Feedback by UserVoice

Dolly

My feedback

  1. 3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    7 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Dolly commented  · 

    You can add control dynamically through VBA using the CreateControl Method (https://msdn.microsoft.com/en-us/library/office/aa221167(v=office.11).aspx). Does this not do what you need?

  2. 0 votes
    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 →
    Dolly shared this idea  · 
  3. 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 →
    Dolly commented  · 

    I agree with the suggestion, but have no votes left.

    Here's a function I found a while back to disable it throughout all the forms of the database.

    Sub DisableDatePicker()
    On Error GoTo Error_Handler
    Dim ctl As control
    Dim frm As AccessObject

    For Each frm In CurrentProject.AllForms
    DoCmd.OpenForm frm.Name, acDesign

    For Each ctl In Forms(frm.Name).Form.Controls
    Select Case ctl.ControlType
    Case acTextBox
    ctl.ShowDatePicker = 0
    End Select
    Next ctl

    DoCmd.Close acForm, frm.Name, acSaveYes
    Next frm

    Error_Handler_Exit:
    On Error Resume Next
    Set frm = Nothing
    Exit Sub

    Error_Handler:
    LogError Err.Number, Err.Description, _
    sModName & "/DisableDatePicker", _
    , True
    Resume Error_Handler_Exit
    End Sub

  4. 2 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 →
    Dolly commented  · 

    I long ago ditched the status bar (far too small that users simply don't even notice it) and started to use a form which I control the visibility of a series of texboxes (colored background) which simulate a progress bar very nicely. I open it modal/pop-up while processing various things and the users can see the progress and can't miss it.

    All of this to say, I think Alan is correct that there are some very good alternative already out there and they're probably better than any MS will put forth.

    It doesn't hurt to make the request, but don't let that stop you right now from implementing a solution.

    A Quick Google finds many solutions:

    http://www.utteraccess.com/wiki/index.php/Progress_Meter
    http://stackoverflow.com/questions/11956834/progress-bar-in-in-ms-access
    http://www.granite.ab.ca/access/progressbar.htm

  5. 7 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 →
    Dolly commented  · 

    +1 I'd vote but no votes left.

  6. 11 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 →
    Dolly commented  · 

    Look at the post and samples provided by Daniel Pineault found at: http://www.utteraccess.com/forum/index.php?showtopic=1992179&st=0&p=2276028&#entry2276028

  7. 8 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    9 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Dolly commented  · 

    I agree with Mark. Since PK have no meaning, the fact that they jump should have no importance.

    Performing a C&R resets them to the greatest taken number, so you could always do that to get back into sequence.

    You seem to have a specific scenario in which you are reliant on the values of autonumber which seems wrong. Why not create your own numeric field then you can populate it as you see fit with whatever sequence you wish.

  8. 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 →
    Dolly commented  · 

    Valid point George.

    Dolly commented  · 

    Same idea as https://access.uservoice.com/forums/319956-access-desktop/suggestions/14833125-buy-fishers-find-and-replace-and-incorporate-it . Make real suggestions for features, rather than buy this, ... Say we need a better Find and Replace Utility that work throughout the entire databse, .... Say, improve VBE/VBA to enable better error reporting to automatically include Module Name, Procedure Name, Line Number instead of buy this....

    Considering the level of engagement MS has put forth on this site's suggestions, I wouldn't hold my breath on this one!

  9. 1 vote
    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 →
    Dolly commented  · 

    "Storing the path would NOT work on a different machine" why not? Create a subdirectory in the db directory to house your files and copy the whole thing. I VBA you can easily reference such files.

    Another alternative is to house them in a table and then at runtime extract them locally to use them as you need.

    Either way, there truly is no problem here.

  10. 4 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 →
    Dolly commented  · 

    +1 here, but out of votes!!! If you want to set default value on fields, then you should give us the ability to define what the default values will be, but 0 would not be one in my books.

  11. 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)  ·  Flag idea as inappropriate…  ·  Admin →
    Dolly commented  · 

    You can already incorporate various HTML editors directly through the native webbrowser control.

  12. 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 →
    Dolly commented  · 

    A properly designed database does not fluctuate in size too much. Normally such fluctuations and bloating are indication of errors in design/usage, such as the use of temporary tables, repetitive insertions/deletions, the use of attachment data types, etc.

  13. 4 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 →
    Dolly commented  · 

    At the very least report them in plain English.

  14. 0 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 →
    Dolly commented  · 
    Dolly commented  · 

    This is what a library database is useful for. You place your procedures in it and link it like a reference and then you have only one place to make changes, push out an update of your library and all your dbs are updated and in synch.

  15. 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 →
    Dolly commented  · 

    A lot, if not all, of this can already be done using proper table design, validation rules, input masks, formats.

  16. 0 votes
    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 →
    Dolly shared this idea  · 
  17. 13 votes
    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 →
    Dolly shared this idea  · 
  18. 41 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 →
    Dolly commented  · 

    I would vote, but am out of votes, beyond which, based on what we have seen on this site (number of submitted suggestions vs Not Planned vs Planned/Done, I've basically given up on this site. It was obviously another PR game played by MS and it worked! People are talking and MS is simply not listening.

    But you aren't wrong for asking for a proper solution rather than a workaround!

    Dolly commented  · 

    Just build your own Tab controls, a series of Label, command buttons, ... They all work fine and then you use their click event to control what is visible. Very easy to implement and works flawlessly.

  19. 8 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 →
    Dolly commented  · 
  20. 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 →
    Dolly commented  · 

    Delete this suggestion and instead add your vote to the existing suggestion found at: https://access.uservoice.com/forums/319956-access-desktop/suggestions/11147169-enhance-the-sql-editor

Feedback and Knowledge Base