Using templete

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Millie30 - 19 Jan 2008 19:20 GMT

Help!
I've found a templete that fits my needs perfectly online. I downloaded it
and it seems to work fine, however, when you first open it you get a few
goofy error messages. How do I fix it so I can use this templete
(membership/2007 ver.)
The messages include "On Got Focus"
This one happens when you move the mouse near the 'Member'
switchboard, which is blank: "On Mouse Move" and continues to pop up until
you close (x) the "member" window.

They both mention macros, and I have a feeling it has something to do with
the security settings (how to I permantly allow to avoid this?)

This program will be used by a public library "friends" group that raises
funds for our library so this has to be user friendly & not require my end
user confusion!

Thanks,
millie30

Reply to this Message

Wayne-I-M - 19 Jan 2008 21:19 GMT

what is the url of the site where you got the template

Signature

Wayne
Manchester, England.

> Help!
> I've found a templete that fits my needs perfectly online. I downloaded it
[quoted text clipped - 15 lines]
> Thanks,
> millie30

Reply to this Message

Millie30 - 19 Jan 2008 21:36 GMT

http://office.microsoft.com/en-us/templates/TC010185841033.aspx?pid=CT102144001033

I am using Access 2007. Is this the problem. I really think it is the "trust
source" issue, but I am really new to using access. I read the "missing
manual" guide to build one from scratch, but I had difficulties building the
relationships and I'm getting too close to my deadline. This templete is so
close to what we need that I decided to use it instead of "reinventing the
wheel".
Thanks,

> what is the url of the site where you got the template
>
[quoted text clipped - 17 lines]
> > Thanks,
> > millie30

Reply to this Message

Tom Wickerath - 20 Jan 2008 10:08 GMT

Hi Millie,

> I am using Access 2007. Is this the problem.

No. Well, maybe, depending on how you look at things. <smile>

> I really think it is the "trust source" issue, but I am really new to using access.

You are correct--it is a trust issue. This sample uses VBA (Visual Basic for
Applications) code. Access 2007, by default, blocks VBA code from running.
This is why the Switchboard form appears empty to you. I verified that the
sample works correctly in Access 2003, but produces the same error you report
when run with the VBA code disabled. I think my Trust Center article should
be helpful for you:

http://www.accessmvp.com/TWickerath/

(This is a brand new web site, so it's a bit sparse at the moment).

Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

> http://office.microsoft.com/en-us/templates/TC010185841033.aspx?pid=CT102144001033
>
[quoted text clipped - 5 lines]
> wheel".
> Thanks,

Reply to this Message

Millie30 - 21 Feb 2008 20:15 GMT

Thanks, btw, for helping out! I ended up allowing all macros since it is an
isolated machine. It works fine, now.

> Hi Millie,
>
[quoted text clipped - 30 lines]
> > wheel".
> > Thanks,

Reply to this Message

Tom van Stiphout - 19 Jan 2008 23:15 GMT

You need to report accurate error messages (my "goofy" is not your
"goofy :-)) as well as the code in the macros. Maybe then we can make
sense of it.

Security settings: Office Button > Access Options > Trust Center.

-Tom.

>Help!
>I've found a templete that fits my needs perfectly online. I downloaded it
[quoted text clipped - 15 lines]
>Thanks,
>millie30

Reply to this Message