Feedback by UserVoice

Tom Wickerath

My feedback

  1. 21 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Access (Desktop Application) » Forms  ·  Flag idea as inappropriate…  ·  Admin →
    Tom Wickerath supported this idea  · 
  2. 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) » Queries  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Tom Wickerath commented  · 

    You should be able to call any of the Excel functions from within Access, using a little VBA code. Not what you asked for, but better than nothing. If you are interested, I have an old sample from 2007 that uses MS Access to call two Excel functions. These calculate the probability and NORMINV. Both early binding and late binding (no checked reference to Excel required) is available--the sample is currently set to use late binding.

    http://www.accessmvp.com/TWickerath/downloads/Statistics.zip

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

    Note that typically the reason this happens is that there is code behind the datasheet form that modifies properties on the form or controls (e.g. Textbox.Locked). Access intends to save the datasheet column widths without saving the properties changed in code, and that process was not working as expected. We are planning to fix this, but in the meantime, you may be able to work around this if you can avoid changing form/control properties in code (e.g. by using Conditional Formatting instead)

    Tom Wickerath supported this idea  · 
  4. 190 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    20 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Tom Wickerath supported this idea  · 
  5. 76 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  Access (Desktop Application) » Forms  ·  Flag idea as inappropriate…  ·  Admin →
    Tom Wickerath supported this idea  · 
  6. 50 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Access (Desktop Application) » Forms  ·  Flag idea as inappropriate…  ·  Admin →
    Tom Wickerath supported this idea  · 
  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 →
    Tom Wickerath supported this idea  · 

Feedback and Knowledge Base