I have recently upgraded to Access 2007 and two characteristics of my former
database are not coming through & I want to get them back. First, in Access
2003, I had set it up so that if I hit "enter" the entire field would be
selected. Now "enter" causes the cursor to jump to the next field. How can
I change this?
Secondly, In my database forms, I had incorporated buttons. Now, each time
I open the database, I am given a warning about macros and I have to manually
tell the program that the macros are trusted. Unfortunately, Access doesn't
accept this and so I have to state that it is trusted every time. How can I
get Access to trust these macros permanently?

Dear Robert:

1. If you wish to select the contents, but not move to the next tab item
when you hit "Enter", you need to change a setting: Click on the big round
Office button (top left), go to "Access Options", then "Advanced", then for
the setting "Move after enter", choose "Don't Move". I think that will give
you what you want.

2. Tell Access that the location in which the file exists is a "trusted"
location. Big round Office button again, "Access Options">"Trust
Centre">"Trust Centre Settings">"Trusted Locations", and then click on
"Trust Centre Settings" and "Add new location". Enter the path to the folder
where the file resides. For example, if you store all your databases in "My
Documents" and make that a trusted location, all the applications will run
without restriction.

HTH
--
Fred Boer - Amateur Access Enthusiast
Interests: Library software / Z39.50 / Web Services
Freeware Small Library Application available here:
http://www3.sympatico.ca/lornarourke/

"Robert McN" <(E-Mail Removed)> wrote in message
news:C6892131-78A5-45FD-9EFA-(E-Mail Removed)...
>I have recently upgraded to Access 2007 and two characteristics of my
>former
> database are not coming through & I want to get them back. First, in
> Access
> 2003, I had set it up so that if I hit "enter" the entire field would be
> selected. Now "enter" causes the cursor to jump to the next field. How
> can
> I change this?
> Secondly, In my database forms, I had incorporated buttons. Now, each
> time
> I open the database, I am given a warning about macros and I have to
> manually
> tell the program that the macros are trusted. Unfortunately, Access
> doesn't
> accept this and so I have to state that it is trusted every time. How can
> I
> get Access to trust these macros permanently?

Thanks very much Fred. These recommendations did the trick. Your help is
most appreciated.

Bob

"Fred Boer" wrote:

> Dear Robert:
>
> 1. If you wish to select the contents, but not move to the next tab item
> when you hit "Enter", you need to change a setting: Click on the big round
> Office button (top left), go to "Access Options", then "Advanced", then for
> the setting "Move after enter", choose "Don't Move". I think that will give
> you what you want.
>
> 2. Tell Access that the location in which the file exists is a "trusted"
> location. Big round Office button again, "Access Options">"Trust
> Centre">"Trust Centre Settings">"Trusted Locations", and then click on
> "Trust Centre Settings" and "Add new location". Enter the path to the folder
> where the file resides. For example, if you store all your databases in "My
> Documents" and make that a trusted location, all the applications will run
> without restriction.
>
> HTH
> --
> Fred Boer - Amateur Access Enthusiast
> Interests: Library software / Z39.50 / Web Services
> Freeware Small Library Application available here:
> http://www3.sympatico.ca/lornarourke/
>
> "Robert McN" <(E-Mail Removed)> wrote in message
> news:C6892131-78A5-45FD-9EFA-(E-Mail Removed)...
> >I have recently upgraded to Access 2007 and two characteristics of my
> >former
> > database are not coming through & I want to get them back. First, in
> > Access
> > 2003, I had set it up so that if I hit "enter" the entire field would be
> > selected. Now "enter" causes the cursor to jump to the next field. How
> > can
> > I change this?
> > Secondly, In my database forms, I had incorporated buttons. Now, each
> > time
> > I open the database, I am given a warning about macros and I have to
> > manually
> > tell the program that the macros are trusted. Unfortunately, Access
> > doesn't
> > accept this and so I have to state that it is trusted every time. How can
> > I
> > get Access to trust these macros permanently?
>
>
>