Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     

Share This Page