Action or Event has been blocked by Disabled Mode - Access 2007 issue?

J

jasonshohet

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The action or event has been blocked by Disabled Mode 1
Access 2007 Date field shows Now instead of Date 4
Access 2007 Disable Mode 1
Disable Mode?! 3
action query blocked by disabled mode 4
Event has been blocked by disable mode 0
Datepicker issue after changing Windows' short date time format 5
Blocked by disabled mode 0

Top