Data base page setup

  • Thread starter Thread starter garbogirl
  • Start date Start date
G

garbogirl

I am working on a rather lenghty database and would like to know how I can
set up my spreadsheet to take me to the next available line without scrolling
through the existing lines
 
You're right.. spreadsheet wasn't the correct way to address this issue. My
data base is in access and I am just trying to input new data with out having
to scroll thru the data to get to the next line.
 
You shouldn't be allowing users to access your tables directly. You can add a
button on a form that moves to a new record if that is what you want. You can
use the code generated by the command button wizard in the On Open event of
the form.
 
I am working on a rather lenghty database and would like to know how I can
set up my spreadsheet to take me to the next available line without scrolling
through the existing lines
Click to expand...

Not in a table or query datasheet, no. You can click on the *> "new record"
navigation button.

You *should* be doing all of your data entry using a Form, not directly in
Tables. On a Form you can set the form's Data Entry property to Yes if you
ONLY want to add new records, and not see any existing ones (you can use a
separate form for editing if you wish); or you can use the toolbox command
button "Record Operations" option to add a button to go to the blank new
record.
 
Back
Top