Access problem....i don't know jack

i am entering a bunch of data into an access file at work. now, in addition to my other illiteracies, i am also illiterate in access. i want to know how to perform a simple task which i thought would be already taken care of by the program itself. i want to press one key and take the cursor to the first column of the next row. when i press tab, of course, it goes to the next column. the same for when i press enter. is one of my function keys depressed and i don’t know about it? how can i get this to do what i want with one key?

Next question. I hate the for dummies books with a passion. *for dummies * what is a good reference tool to use for learning the basics, i.e., word, access, excel, powerpoint? is the video professor cd stuff any good?*video professor *

pas bien!!! let’s try again
i am entering a bunch of data into an access file at work. now, in addition to my other illiteracies, i am also illiterate in access. i want to know how to perform a simple task which i thought would be already taken care of by the program itself. i want to press one key and take the cursor to the first column of the next row. when i press tab, of course, it goes to the next column. the same for when i press enter. is one of my function keys depressed and i don’t know about it? how can i get this to do what i want with one key?

Next question. I hate the for dummies books with a passion. what is a good reference tool to use for learning the basics, i.e., word, access, excel, powerpoint? is the video professor cd stuff any good?

(From memory)

Under Tools go to Options (or possibly Database Options?). In there, SOMEWHERE, is an option that lets you pick what the enter key does. Change that.

that did it! i’m a thankin ye!

wait…back up…it worked once, now it just takes it down one rowwhat happened…?

wait…back up…it worked once, now it just takes it down one rowwhat happened…?

Different database maybe? - some of the settings in Microsoft applications are global to the program, others are peculiar to the file that you currently have open.

MS Access 2000:

Go to Tools/Options/Keyboard

The setting “Move after Enter” has 3 options:

  • Don’t move
  • Next Field
  • Next Record

So it looks like “Next Record” is your baby, but there is a catch: it goes to the next record, but to the same field that you are currently in, not the first field.

I think that’s what you have already discovered.