Navigation Buttons, Preventing inadvertant record creation 
Author Message
 Navigation Buttons, Preventing inadvertant record creation

I have a form that is bound to a data table.

The user has the ability to filter the table, and I want them to be able
to move from one record to the next, but don't want to use the
navigation buttons because I don't want them to inadvertantly create a
new record.

Can I prevent a new record from being created by coding on an event, or
do I need to turn the navigation buttons off and provide some other way
to move between records (Cmd Btn, menu items)?  If I have to turn off
the navigation buttons and window, how do I continue to display the
record number and count of records which match the filter?



Mon, 03 Jul 2000 03:00:00 GMT  
 Navigation Buttons, Preventing inadvertant record creation

Set allow additions for the form to No

Quote:

>I have a form that is bound to a data table.

>The user has the ability to filter the table, and I want them to be able
>to move from one record to the next, but don't want to use the
>navigation buttons because I don't want them to inadvertantly create a
>new record.

>Can I prevent a new record from being created by coding on an event, or
>do I need to turn the navigation buttons off and provide some other way
>to move between records (Cmd Btn, menu items)?  If I have to turn off
>the navigation buttons and window, how do I continue to display the
>record number and count of records which match the filter?



Tue, 04 Jul 2000 03:00:00 GMT  
 Navigation Buttons, Preventing inadvertant record creation

Terry:

Thanks for the quick response.  What I forgot to mention is that I am
using V2.0.  I don't find a property for "allow additions".

Quote:

> Set allow additions for the form to No


> >I have a form that is bound to a data table.

> >The user has the ability to filter the table, and I want them to be able
> >to move from one record to the next, but don't want to use the
> >navigation buttons because I don't want them to inadvertantly create a
> >new record.

> >Can I prevent a new record from being created by coding on an event, or
> >do I need to turn the navigation buttons off and provide some other way
> >to move between records (Cmd Btn, menu items)?  If I have to turn off
> >the navigation buttons and window, how do I continue to display the
> >record number and count of records which match the filter?



Tue, 04 Jul 2000 03:00:00 GMT  
 Navigation Buttons, Preventing inadvertant record creation

Hi
What I forgot to mention is that "allow additions" isn't available under
Access2, but by a duick look in the hlp file for Access2 I find that if you
set the DefaultEditing property to "Can't Add Records", this will achieve
the same effect.

Quote:

>Terry:

>Thanks for the quick response.  What I forgot to mention is that I am
>using V2.0.  I don't find a property for "allow additions".


>> Set allow additions for the form to No


>> >I have a form that is bound to a data table.

>> >The user has the ability to filter the table, and I want them to be able
>> >to move from one record to the next, but don't want to use the
>> >navigation buttons because I don't want them to inadvertantly create a
>> >new record.

>> >Can I prevent a new record from being created by coding on an event, or
>> >do I need to turn the navigation buttons off and provide some other way
>> >to move between records (Cmd Btn, menu items)?  If I have to turn off
>> >the navigation buttons and window, how do I continue to display the
>> >record number and count of records which match the filter?



Tue, 04 Jul 2000 03:00:00 GMT  
 
 [ 5 post ] 

 Relevant Pages 

1. Navigation buttons, Preventing inadvertant record creation

2. Navigation Buttons - Not Allowing New Record Creation with Next Record

3. preventing record navigation with wheel button

4. preventing record navigation with the mouse's wheel button

5. Inadvertant creation of duplicate database relationships

6. My navigation buttons dependent on Access navigation buttons?

7. Disable/Prevent Add New in Navigation button?

8. capturing the record number and total records in a form with no navigation buttons

9. Is There any Form Event for moving from record to record when using Navigation button

10. Prevent ing Record Navigation VIA Wheel Mouse


 
Powered by phpBB® Forum Software © phpBB Group