Change position of Navigation Buttons?

[CW]

Is it possible to change the position of the inbuilt navigation buttons? (And
if so, how??) Or can they only be displayed in the bottom left of a form?
Many thanks
CW

 

[fredg]

Is it possible to change the position of the inbuilt navigation buttons? (And
if so, how??) Or can they only be displayed in the bottom left of a form?
Many thanks
CW

As far as I know they can only be displayed at the lower left corner
of the form.
However, you can set the form's Navigation Button property to no, and
then add your own command buttons to the form wherever you wish. The
Button Wizard will write the code for you (under Record Navigation).
To display the record count (x of y), add an unbound control to the
form. Name if "RecCount".
Then code the Form's Current event:

Me.[RecCount] = Me.CurrentRecord & " of " &
Me.RecordsetClone.RecordCount

 

[Al Campagna]

CW,
No.
On main forms, I use my own navigation buttons. They're larger, and
easier to access.
I still use the Access nav buttons on continuous subforms though. Less
space...
If you search the Access newsgroups for "custom navigation" you'll find
numerous solutions.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[CW]

Fred -
Thanks a lot for the quick response. And for the solution, which is working
very nicely except for one thing...I have a form for our Corporate Clients
and a subform on this showing the details of the various contacts at that
company. I have put the code on the Current event of that subform, so that we
can see that there are multiplel Contact records. Most of the records are
populated but we do have a few Corporates where there is no contact person.
When I go to one of those, I get a runtime error saying there is no current
record. If I "End", the form then opens OK, but it's a bit messy having the
error msge appear. Any way around this? (I know this is the cause because I
tried adding a contact on one such Corporate where there wasn't one, and that
prevented the error).
Thanks again
CW

Is it possible to change the position of the inbuilt navigation buttons? (And
if so, how??) Or can they only be displayed in the bottom left of a form?
Many thanks
CW

As far as I know they can only be displayed at the lower left corner
of the form.
However, you can set the form's Navigation Button property to no, and
then add your own command buttons to the form wherever you wish. The
Button Wizard will write the code for you (under Record Navigation).
To display the record count (x of y), add an unbound control to the
form. Name if "RecCount".
Then code the Form's Current event:

Me.[RecCount] = Me.CurrentRecord & " of " &
Me.RecordsetClone.RecordCount

 

[CW]

Thanks, Al. Looks like Fred's suggestion is going to do what I need but I
appreciate the link to those other ones.
CW

 

[fredg]

Fred -
Thanks a lot for the quick response. And for the solution, which is working
very nicely except for one thing...I have a form for our Corporate Clients
and a subform on this showing the details of the various contacts at that
company. I have put the code on the Current event of that subform, so that we
can see that there are multiplel Contact records. Most of the records are
populated but we do have a few Corporates where there is no contact person.
When I go to one of those, I get a runtime error saying there is no current
record. If I "End", the form then opens OK, but it's a bit messy having the
error msge appear. Any way around this? (I know this is the cause because I
tried adding a contact on one such Corporate where there wasn't one, and that
prevented the error).
Thanks again
CW

Is it possible to change the position of the inbuilt navigation buttons? (And
if so, how??) Or can they only be displayed in the bottom left of a form?
Many thanks
CW

As far as I know they can only be displayed at the lower left corner
of the form.
However, you can set the form's Navigation Button property to no, and
then add your own command buttons to the form wherever you wish. The
Button Wizard will write the code for you (under Record Navigation).
To display the record count (x of y), add an unbound control to the
form. Name if "RecCount".
Then code the Form's Current event:

Me.[RecCount] = Me.CurrentRecord & " of " &
Me.RecordsetClone.RecordCount

I have no way of testing this on a subform, however try using error
handling in the Current event to trap that error.

On ErrorGoTo Err_Handler
' your current code here
Exit_Sub:
Exit Sub
Err_Handler:
If err = xxxx then
Else
msgBox "Error: & Err.Number & " " & Err.Description
End If
Resume Exit_Sub

xxxx is whatever the error number that is raised is.