By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,667 Members | 2,084 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,667 IT Pros & Developers. It's quick & easy.

Re-using Navigation Buttons in Many Forms?

P: n/a
MX1
Hi,

I've created a series of navigation buttons to be used as a standard across
many forms in an Access DB. Does anyone know an easy way to cut and paste
these navigation buttons into each new form I create. Re-creating them is
VERY Painful and regular cut and paste doesn't work. I've read something
about making a standard module for each button but I don't know how to
assign that to the new buttons on each form. Help.... :(
Nov 12 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
"MX1" <mx*@mx1.abc> wrote in message news:mlFnb.41203$ao4.90866@attbi_s51...
Hi,

I've created a series of navigation buttons to be used as a standard across
many forms in an Access DB. Does anyone know an easy way to cut and paste
these navigation buttons into each new form I create. Re-creating them is
VERY Painful and regular cut and paste doesn't work. I've read something
about making a standard module for each button but I don't know how to
assign that to the new buttons on each form. Help.... :(


Put them on a sub-form and modify the code so that it works against the parent
form instead of the one the buttons actually reside in. When set up correctly
you can just drop that sub-form onto any other form and the buttons will work
without doing anything else.

I even set mine up so that the tag property of the sub-form control can be used
to establish the BackColor, Font Color, Font, FontSize, and whether the record
counter text appears to the left, right, above, or below the buttons.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 12 '05 #2

P: n/a
Have a look how it is done in this sample MDB:
http://www.lebans.com/recnavbuttons.htm
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"MX1" <mx*@mx1.abc> wrote in message
news:mlFnb.41203$ao4.90866@attbi_s51...
Hi,

I've created a series of navigation buttons to be used as a standard across many forms in an Access DB. Does anyone know an easy way to cut and paste these navigation buttons into each new form I create. Re-creating them is VERY Painful and regular cut and paste doesn't work. I've read something about making a standard module for each button but I don't know how to
assign that to the new buttons on each form. Help.... :(


Nov 12 '05 #3

P: n/a
Thanks! This seems to be working. I can't believe MS did not make it
easier to cut and paste code between forms. Especially for such a nice DB
program...
"Stephen Lebans" <Fo****************************************@linval id.com>
wrote in message news:tN*******************@ursa-nb00s0.nbnet.nb.ca...
Have a look how it is done in this sample MDB:
http://www.lebans.com/recnavbuttons.htm
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"MX1" <mx*@mx1.abc> wrote in message
news:mlFnb.41203$ao4.90866@attbi_s51...
Hi,

I've created a series of navigation buttons to be used as a standard

across
many forms in an Access DB. Does anyone know an easy way to cut and

paste
these navigation buttons into each new form I create. Re-creating

them is
VERY Painful and regular cut and paste doesn't work. I've read

something
about making a standard module for each button but I don't know how to
assign that to the new buttons on each form. Help.... :(

Nov 12 '05 #4

P: n/a
Hey, with folks like Stephen Lebans (and many others) providing such great
freebies to support the Access user community, that omission is only a minor
irritation.

Stephen's work is a superb resource, to which I refer people needing
"extensions to Access" on a continuing basis. They, and I, thank him for all
the time and effort he has put in to make the extensions freely available to
us all.

Larry Linson
Microsoft Access MVP
"JBrow" <j@jdp.coj> wrote in message
news:3sHnb.54285$e01.150054@attbi_s02...
Thanks! This seems to be working. I can't believe MS did not make it
easier to cut and paste code between forms. Especially for such a nice DB
program...
"Stephen Lebans" <Fo****************************************@linval id.com>
wrote in message news:tN*******************@ursa-nb00s0.nbnet.nb.ca...
Have a look how it is done in this sample MDB:
http://www.lebans.com/recnavbuttons.htm
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"MX1" <mx*@mx1.abc> wrote in message
news:mlFnb.41203$ao4.90866@attbi_s51...
Hi,

I've created a series of navigation buttons to be used as a standard

across
many forms in an Access DB. Does anyone know an easy way to cut and

paste
these navigation buttons into each new form I create. Re-creating

them is
VERY Painful and regular cut and paste doesn't work. I've read

something
about making a standard module for each button but I don't know how to
assign that to the new buttons on each form. Help.... :(


Nov 12 '05 #5

P: n/a
j@jdp.coj (JBrow) wrote in <3sHnb.54285$e01.150054@attbi_s02>:
I can't believe MS did not make it
easier to cut and paste code between forms. Especially for such a
nice DB program...


Well, I can't see that I can criticize MS for not making it easier,
given that the design principle of creating a single object and
re-using it in multiple contexts is so obviously superior in the
first place. That is, why should MS have made the conceptually
wrong way to do things easier?

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 12 '05 #6

P: n/a
MX1
David,

I agree with your comments. This concept sunk in while I was thinking about
it off-line. Thanks for your feedback...

:)

"David W. Fenton" <dX********@bway.net.invalid> wrote in message
news:94***************************@24.168.128.78.. .
j@jdp.coj (JBrow) wrote in <3sHnb.54285$e01.150054@attbi_s02>:
I can't believe MS did not make it
easier to cut and paste code between forms. Especially for such a
nice DB program...


Well, I can't see that I can criticize MS for not making it easier,
given that the design principle of creating a single object and
re-using it in multiple contexts is so obviously superior in the
first place. That is, why should MS have made the conceptually
wrong way to do things easier?

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

Nov 12 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.