Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Action Or Event Has Been Blocked By Disabled Mode - Access 2007 Issue?

Discussion in 'Information Technology' started by jasonshohet@gmail.com, Jul 28, 2006.

  1. jasonshohet@gmail.com

    Expand Collapse

    working with the new beta, I want to do an update statement on a field
    that has text data that looks like this: 20050310

    I want it to be 03102005 - and a date field.
    But access won't change the text field to type 'date' without deleting
    the data. So I was going to try this

    UPDATE TRANS SET DEATHDT = Format(Date(),"yyyymmdd");
    and then try to convert the field to type date, and then do a second
    UPDATE TRANS SET DEATHDT = Format(Date(),"mmddyyyy");

    to get me to where I really want to be.
    First, I'm not sure if this is the right strategy. Second, I keep
    getting an error in access "action or event has been blocked by
    disabled mode" and i don't know how to enable it! I'm the only owner
    / admin of this database. So i'm not sure why Access 2007 (beta 2) is
    doing this.

    Thanks for any help
    Jason Shohet
  2. Loading...

    Similar Threads Forum Date
    Movies Ashdoc's Short Review---Action Jackson Theatre, Movies & Cinema Dec 12, 2014
    Arts/Society What Are Your Thoughts On The Interaction Of Male / Female Relationship Of Marriage? Language, Arts & Culture Oct 15, 2013
    Opinion US Must Take Substantial Military Action In Syria Now Breaking News Aug 30, 2013
    Opinion Facing Adversity - Different Reactions Breaking News Aug 18, 2013
    Controversial Former President Of Delhi Sikh Gurdwara Management Committee Could Face Religious Action Hard Talk Jul 21, 2013

Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     

Share This Page