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

access+training - supress macro security

Forum home » Delegate support and help forum » Microsoft Access Training and help » access+training - Supress Macro Security - MS Access

access+training - Supress Macro Security - MS Access

ResolvedVersion Standard

Timothy has attended:
Excel VBA Intro Intermediate course
Excel VBA Intro Intermediate course
Access Intermediate course
Access Advanced course

Supress Macro Security - MS Access

Can you supress the Macro security prompt at startup other than by changing the individuals security option?

RE: Supress Macro Security - MS Access

Hi Timothy

One way to supress the Macro prompt at StartUp is to manually reset the computer's Macro security level. To do this:

1. Open Tools / Select Macro. In the Sub menu Click Security

2. On the Security dialog box select Low

3. Click OK

Although not recommended this allows all databases to open, without a prompt, even if they contain Macros.

Hope this helps

Carlos

Access tip:

Dsum

You can create percentage values based on individual products / items by using a Dsum function (used with a grouped query)

[Each value column] / Dsum[field:total for the column needed to be calculated],[tablename]

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.