Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Access Training and help » Running queries

Running queries

ResolvedVersion 2007

Thu 3 Dec 2009, 12:56 Delegate Laura said...

Laura has attended:
Access Introduction course
Word Intermediate course

Running queries

I have just converted our old data base to Access 2007. Now however when I try to run the queries I am unable to as I get the following message:

Action or event has been blocked by Disabled mode.

What can I do in this situation?

Kind regards,

Laura

Thu 3 Dec 2009, 15:44 Trainer Andrew said...

RE: Running queries

Hi Laura

Thank you for your question. It looks like Access is not sure if it should trust your data or not. You may find the following article helpful from the Microsoft website.

http://office.microsoft.com/en-gb/access/HA102564031033.aspx?pid=CH100645771033

Let me know how you get on or if you have any further questions.

Kind regards,
Andrew

Wed 9 Dec 2009: Automatically marked as resolved.

Access tip:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Running queries

Running queries

RE: Running queries

Access articles

Access tip:

Hiding Multiple Table columns