page up and down restrcition

[rog]

Hello

Please reply at (e-mail address removed).

I have this standalone Access application. I have a form
wherein the vistors to the museum enter their contact
info.

After say visitor a enters and the info the vis b enters
and so on. What is happening is that after say fills out
the form and he clisk continue the data must commit and
must not be available to be seen by visitor F. He must
just be able to ente his data and then click sumitt and
then visitor G must not be able to see tha record. Somehoe
in my design visitor g can scroll thru the records and can
see what a entered and b entered etc.

What must I do to prevent this? can i put a limitation
whereby the page up and page down buttons would not work
on the keyboard.

PLease reply at (e-mail address removed)

 

[Rick Brandt]

Hello

Please reply at (e-mail address removed).

I have this standalone Access application. I have a form
wherein the vistors to the museum enter their contact
info.

After say visitor a enters and the info the vis b enters
and so on. What is happening is that after say fills out
the form and he clisk continue the data must commit and
must not be available to be seen by visitor F. He must
just be able to ente his data and then click sumitt and
then visitor G must not be able to see tha record. Somehoe
in my design visitor g can scroll thru the records and can
see what a entered and b entered etc.

What must I do to prevent this? can i put a limitation
whereby the page up and page down buttons would not work
on the keyboard.

Bind your form to a query similar to...

SELECT * FROM YourTableName WHERE 1 = 0

This will cause the form to open showing only a blank record (since 1 does not = 0).
This blank can still be used to enter new records. In the AfterInsert event of the
form issue a Requery command...

Me.Requery

This will cause the record that was just entered to be removed from the form's
RecordSource.

 

[roger]

Thanks Rick.

I am not completely clear...I do not want the records
entered to bedeleted...I just want the users not to be
able to scroll up and down the records by pressing the
pageup and pagedown buttons.

Will your idea work then?

 

[Rick Brandt]

Thanks Rick.

I am not completely clear...I do not want the records
entered to bedeleted...I just want the users not to be
able to scroll up and down the records by pressing the
pageup and pagedown buttons.

Will your idea work then?

Yes. Essentially the form is bound to a query that will never return
records, but it allows you to add new ones. The Requery simply removes the
added records from the form because the query is rerun and the new records
don't satisfy the criteria. The records are still in the table.