Prev: play boy pink pyjamas £ 1. 45
Next: Edit textbox
From: Kim Wennerberg Kim on 25 Apr 2010 13:35
MS Access 2007
How can I make an event occur on a form without the user OK'ing the the code
be run?
At the top of the Access screen there is Security Warning saying, "Certain
content in the database has been disabled. Options..."
I am observing that if the user doesn't go into Options and enable content,
none of my VBA runs.
The VBA is simply code that timestamps the records when created and edited
and captures the username.
From: Dirk Goldgar on 25 Apr 2010 13:41
"Kim Wennerberg" <Kim Wennerberg(a)discussions.microsoft.com> wrote in message
news:EFC27B40-C41D-41CC-BD93-E2DEC8786064(a)microsoft.com...
> MS Access 2007
> How can I make an event occur on a form without the user OK'ing the the
> code
> be run?
> At the top of the Access screen there is Security Warning saying, "Certain
> content in the database has been disabled. Options..."
> I am observing that if the user doesn't go into Options and enable
> content,
> none of my VBA runs.
> The VBA is simply code that timestamps the records when created and edited
> and captures the username.


Put the database in a Trusted Location, or use the Trust Center to designate
the database's current location as trusted.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

From: Kim Wennerberg on 26 Apr 2010 08:16
Thanks... just like Excel, I see.

"Dirk Goldgar" wrote:

> "Kim Wennerberg" <Kim Wennerberg(a)discussions.microsoft.com> wrote in message
> news:EFC27B40-C41D-41CC-BD93-E2DEC8786064(a)microsoft.com...
> > MS Access 2007
> > How can I make an event occur on a form without the user OK'ing the the
> > code
> > be run?
> > At the top of the Access screen there is Security Warning saying, "Certain
> > content in the database has been disabled. Options..."
> > I am observing that if the user doesn't go into Options and enable
> > content,
> > none of my VBA runs.
> > The VBA is simply code that timestamps the records when created and edited
> > and captures the username.
>
>
> Put the database in a Trusted Location, or use the Trust Center to designate
> the database's current location as trusted.
>
> --
> Dirk Goldgar, MS Access MVP
> Access tips: www.datagnostics.com/tips.html
>
> (please reply to the newsgroup)
>
 | 
Pages: 1
Prev: play boy pink pyjamas £ 1. 45
Next: Edit textbox