Data sheet question

[Guest]

Is there any way to tell access to have the add new record cell of a data
sheet to always be at the top of the sheet as opposed to the bottom. In
other words, to allways add a new record at the top of the data sheet.
Something like this;

New Empty Record
Record With Data
Record With Data
Record With Data etc.

Thanks, Rob

 

[fredg]

Is there any way to tell access to have the add new record cell of a data
sheet to always be at the top of the sheet as opposed to the bottom. In
other words, to allways add a new record at the top of the data sheet.
Something like this;

New Empty Record
Record With Data
Record With Data
Record With Data etc.

Thanks, Rob

No!
And if by Datasheet you mean Table Datasheet, you shouldn't be
entering data in a Table anyway.
Use a Form in Datasheet view.

I've seen posts suggesting using a separate form, as a subform within
the Datasheet view form, just to enter new data. You can search
http://www.groups.google.com for more information.

 

[Guest]

Actually, I do have a sub form that I've developed to look like a data sheet.
Now that I've said that, how can I get the new record cell to always be at
the top (if it is possible at all?)

 

[Douglas J. Steele]

No, it's not possible.

One option that's often used is to have 2 subforms: one above the other. The
top one should be a single row high, and have its "DateEntry" property set
to True. The other one can be as high as you like, but should have its
"AllowAdditions" property set to False.

 

[Guest]

As always, thank you Doug. Have a great week. Rob