running queries

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

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

Running queries

resolvedResolved · High Priority · Version 2007

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

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:

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.



View all Access hints and tips


Server loaded in 0.08 secs.