If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Data base page setup
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 |
#2
|
|||
|
|||
Data base page setup
garbogirl,
Are you sure you are working in Access? "spreadsheet" suggests Excel. -- Duane Hookom Microsoft Access MVP "garbogirl" wrote: 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 |
#3
|
|||
|
|||
Data base page setup
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. "Duane Hookom" wrote: garbogirl, Are you sure you are working in Access? "spreadsheet" suggests Excel. -- Duane Hookom Microsoft Access MVP "garbogirl" wrote: 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 |
#4
|
|||
|
|||
Data base page setup
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. -- Duane Hookom Microsoft Access MVP "garbogirl" wrote: 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. "Duane Hookom" wrote: garbogirl, Are you sure you are working in Access? "spreadsheet" suggests Excel. -- Duane Hookom Microsoft Access MVP "garbogirl" wrote: 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 |
#5
|
|||
|
|||
Data base page setup
On Wed, 22 Apr 2009 11:19:02 -0700, garbogirl
wrote: 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 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. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|