Data Entry at the Top of a Datasheet

[PercyPercy]

I have a subform that I would like to have people use for data entry. It's in a data sheet view and sorts by date (the most current date at the top).

This works fine -- when there are only a few entries. But as time goes on and the list grows, it means the users will have to scroll to the bottom to get to their data entry field. Yes, I know they can use the record selector, but I want to make it easy and intuitive as the users of this data base have very little formal training and aren't very computer savvy.

I'd like for them to go to the form, and just start typing the new info in the top line. Is there a way to make the "new" line appear at the top of a datasheet?

Thanks all of you for your help on this forum!

 

[RuralGuy]

Use an AutoNumber as the primary key and sort Descending.

 

[PercyPercy]

It sorts correctly, but the "new" row is at the end...

I had it sorted this way -- and yes, it does bring the most recent dates to the top... but the "add" record still is at the bottom. I was hoping that this could be at the top of the datasheet if at all possible -- so if you have any additional ideas, let me know. Thanks!

 

[RuralGuy]

An AutoNumber populates as soon as the record is created so even the *new* records are at the top if you sort descending on the AutoNumber.

 

[Studentos]

You can only set your subform to DataEntry mode to have "add" record blank visible as first record, but you cannot display "add" record at the top and rest records lower

 

[pbaldy]

The hack would be to have 2 subforms, one that was set to data entry and only as tall as needed for the one line, the second just displaying records underneath the first. Requery the second when you insert records with the first, so they display properly. It would appear to the user to be one form with the data entry at the top.

 

[RuralGuy]

Some have gone so far as using a separate SubForm set at DataEntry and placing it above the other SubForm. Then you can enter new data at the top of the other SubForm.

 

[RuralGuy]

Paul and I typing at the same time. Paul wins!

 

[pbaldy]

Fastest fingers in the west!

Actually it's because I'm only at 5,000', so there's more oxygen here.

 

[PercyPercy]

Thanks!

Thanks all of you -- I NEVER thought of that...

 

[Mike-palmer]

Has anyone actually implemented a solution using the two sub-form overlay technique? I havn't been able to quite manage it; How do I get the dataentry form to just show the data entry line?

What we are trying to achieve here seems so basic that I'm amazed Access doesn't have an option to select new record at the top or at the bottom.

An alternate solution would be to sort the items by ascending date and scroll the window down (automatically) to show the latest entries and the data entry line - but how does one do that?

Mike

 

[RuralGuy]

Mike,
Set the DataEntry property on the Data Entry SubForm to Yes!

 

[ansentry]

Have a look at my sample posted here

I could not get it to work using a datasheet, but if you just want a continious form it works fine.

I also have another one that uses 2 subform (I for entry - single row & 1 for display) it can be found here it is called MainFormSubForm SubInput.zip

Hope these are a help to you.

 

[Keith Nichols]

Hi John,

I think you mixed up your links as both jump to the same thread. I chased around in circles a bit trying to track down the link with no success. Could you post the second link again?

Many thanks.

 

[ansentry]

Hi John,

I think you mixed up your links as both jump to the same thread. I chased around in circles a bit trying to track down the link with no success. Could you post the second link again?

Many thanks.

Keith,

Sorry about that see if this one works.<<< HERE >>>

I have checked and this time I have done it correctly. If something goes wrong ,send me a PM with the name of the sample and I will send it to you.

Name of Sample:
MainFormSubFormSub_Input.zip (36.8 KB, 38 views)

 

[Keith Nichols]

Keith,

Sorry about that see if this one works.<<< HERE >>>

John,

Thanks for that. I'm embarrassed to say that I have actually posted on that thread in April and had downloaded the sample db.

I didn't actually understand it at the time and intended to look at it later but didn't find it when I did the search the other day.

Anyway, thanks again. I have moved on considerably since April ands I hope I'll be bale to understand and adapt it this time .