|
| 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
April 22nd, 2009, 07:19 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
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
April 22nd, 2009, 07:41 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
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
April 22nd, 2009, 08:58 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
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
April 22nd, 2009, 09:56 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
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
April 23rd, 2009, 12:55 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
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 | |
|
|
Linear Mode
