Simple Form Question 3

[devagupt]

I have a form with many fields. We have around 500 + records. WHen a supervisor makes an entry , he has to scroll all the way down and enter the information. I wanted to know if he could start entering in all the information in each record from top and after every record , it would create another record right below it for the next record , so and and so forth and continue to display all the other remaining records which have been entered in the past ( the remaining 500 + records).

Please help!

 

[Remou]

I think that two subforms may suit, one for data entry and the other for history. This can be achieved by setting the Data Entry property of the first form to Yes.

 

[devagupt]

The supervisors need to view the past information as and when they enter in the new information. I was wondering if we could view the records from top and as soon as something is entered into a record , another blank one would show up on top of the existing record like it happens when we do it in the bottom of the form.

 

[Remou]

No, it is not possible, that is why I suggested two forms. You can set the existing form to Data Entry with a command button and set it back when data entry is done. This means that the line for entering data will be at the top, but there will not be any other records showing until the subform is set back. However, it seemed to me that the better solution would be to use two subform, one short one for data entry and one long form for history records.

 

[TheAceMan1]

How are ya devagupt . . .

Yes its possible! . . . I've already done so for a few clients in the past who were adamant about this.

What you need to do:
[ol][li]Base the [blue]RecordSource[/blue] of your [blue]continuous form[/blue] on a query thats [blue]sorted decending[/blue] on a field that increases with [purple]unique[/purple] values (numeric primarykey, date, or other equivalent numeric).[/li]
[li]Here's the trick: [purple]In the forms header underneath the labels for the fields, add a row of unbound textboxes.[/purple] [blue]This is your input line at the top of the form![/blue] . . . and since its in the header it stays at the top! If you close-up the detail section properly you wont know the difference in form view![/li]
[li]Now its a simple matter of [blue]a little code to polish it off[/blue], the sequence of which should be:
[ol a][li]In the last unbound textbox [blue]validate key fields[/blue] before appending the unbound data.[/li]
[li]Append the data.[/li]
[li]Requery the form.[/li]
[li]Clear the unbound data.[/li]
[li]Set focus to the 1st unbound control[/li][/ol][/li][/ol]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

 

[SgtJarrow]

Nice AceMan....wish I would have thought of that for a couple clients in the past.

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer

 

[devagupt]

Thanks Aceman. I will give it a try and get back to you. Thanks for the help.