Customizing Navigation buttons

[laura]

Is there any way to modify the navigation buttons?

Basically I want all the functionality except for the "add new record". I've
tried writing my own navigation button, but have a problem with the text box
that shows the current record number. It works fine for showing current
record number but I cannot enter a record number to skip to. I have the text
box control source set to =[CurrentRecord] - therefore I cannot enter a
number in the box the same way as on the normal navigation bar.

Another drawback is that I cannot hold the mouse down on the skip forward,
back buttons and scroll through the records rapidly, or is there a way?

Seems such a lot of work just to do away with one of the functions of the
standard navigation bar. Any help and suggestions appreciated.

Laura TD

 

[Neil]

Laura,

If you dont want to allow additions on the form, the goto design view for
the form. Open up the properties for the form (double click the square in
the top left corner where the 2 rulers meet) and then under the data tab
change Allow Additions to be false. This will not remove the button, but it
will disable it so that you will not be able to add new records.

HTH,

Neil.

 

[laura]

Hi Neil,

Thanks for the quick reply - sometimes these things are right in front of
us, but we don't notice them. I tried that method and am achieving what I
want - the "add new record" button remains, but is greyed out. I have my own
"new record" button in which I put the code "myForm.AllowAdditions = true so
that I could allow the addition of a new record when other conditions were
right and then set to false once again afterwards.

I think it does the trick - many thanks.
Laura TD

Laura,

If you dont want to allow additions on the form, the goto design view for
the form. Open up the properties for the form (double click the square in
the top left corner where the 2 rulers meet) and then under the data tab
change Allow Additions to be false. This will not remove the button, but it
will disable it so that you will not be able to add new records.

HTH,

Neil.

Is there any way to modify the navigation buttons?

Basically I want all the functionality except for the "add new record". I've
tried writing my own navigation button, but have a problem with the text box
that shows the current record number. It works fine for showing current
record number but I cannot enter a record number to skip to. I have the text
box control source set to =[CurrentRecord] - therefore I cannot enter a
number in the box the same way as on the normal navigation bar.

Another drawback is that I cannot hold the mouse down on the skip forward,
back buttons and scroll through the records rapidly, or is there a way?

Seems such a lot of work just to do away with one of the functions of the
standard navigation bar. Any help and suggestions appreciated.

Laura TD

 

[Neil]

Hi Laura,

that sounds so familiar. Many a time i have stuggled on with 10-15 lines of
code and posted here for assistance. Some MVP nearly always reduces it to
2-3 lines and you read it and think hmm.... simple...

Glad you found a solution for your problem.

Neil.

Hi Neil,

Thanks for the quick reply - sometimes these things are right in front of
us, but we don't notice them. I tried that method and am achieving what I
want - the "add new record" button remains, but is greyed out. I have my own
"new record" button in which I put the code "myForm.AllowAdditions = true so
that I could allow the addition of a new record when other conditions were
right and then set to false once again afterwards.

I think it does the trick - many thanks.
Laura TD

Laura,

If you dont want to allow additions on the form, the goto design view for
the form. Open up the properties for the form (double click the square in
the top left corner where the 2 rulers meet) and then under the data tab
change Allow Additions to be false. This will not remove the button, but it
will disable it so that you will not be able to add new records.

HTH,

Neil.

Is there any way to modify the navigation buttons?

Basically I want all the functionality except for the "add new

record".
I've

tried writing my own navigation button, but have a problem with the

text
box

that shows the current record number. It works fine for showing current
record number but I cannot enter a record number to skip to. I have

the
text

box control source set to =[CurrentRecord] - therefore I cannot enter a
number in the box the same way as on the normal navigation bar.

Another drawback is that I cannot hold the mouse down on the skip forward,
back buttons and scroll through the records rapidly, or is there a way?

Seems such a lot of work just to do away with one of the functions of the
standard navigation bar. Any help and suggestions appreciated.

Laura TD