1. Selecting field with "enter"; 2. permanently accepting macros

[Robert McN]

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?

 

[Fred Boer]

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

 

[Robert McN]

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

Bob