coding navigation buttons

[HB]

Since there seems to be no way to "turn off" the built in navigation buttons
from adding a new record when it gets to the end of the record set, I'll need
to code it myself, but I don't know how to know if I'm at the end of the
recordset in the form. Can someone supply some "air" code on how to check, or
send me to a website where this has been done. I'd hate to re-invente the
wheel and I'm sure someone has done this already.

tia.

HB

 

[Fred Boer]

Dear HB:

You might not need any code: if you are using a form, you can set the form's
"Allow Additions" property to "No". Post back if you need instructions on
how to do this!

HTH
Fred Boer

 

[HB]

I don't, but the user may have to add a new record (and I have a button for
that). If I turn off this property, it will also invalidate my button won't
it? I remember seeing an "allow add" property somehwere, is this the same as
what you're talking about?

What I really want are buttons that just navigate through the recordset.

Thanks

H.B.

 

[HB]

I found the Allow additions on the Data tab of the form, but does this turn
off all additions? (I guess I should just test it).

 

[HB]

Your idea sparked a solution. I have the property off. When the add record
button is pressed, i have code on the event to turn it on, add the record,
then turn it back off.

Now the user can still use the nav. buttons, but only add records by using
the add record button. Thanks for the spark!

 

[Fred Boer]

Dear HB:

You are too quick for me! Glad you found your own solution - I would have
suggested something that myself, if I had been faster on the draw...

Cheers!
Fred

 

[Stephen Lebans]

See:
http://www.lebans.com/recnavbuttons.htm
RecordNavigationButtons is an MDB containing code to replace the
standard Navigation Buttons. The custom buttons exactly emulate the
standard navigation bar including the autorepeat property.
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.