A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

one label all forms



 
 
Thread Tools Display Modes
  #1  
Old November 27th, 2009, 09:37 PM posted to microsoft.public.access.forms
seeker
external usenet poster
 
Posts: 133
Default one label all forms

I want to put a label on all my forms that says YOU ARE IN ARCHIVE. Can I do
this without placing a label on each form? Thanks.
  #2  
Old November 27th, 2009, 10:07 PM posted to microsoft.public.access.forms
Douglas J. Steele[_3_]
external usenet poster
 
Posts: 3,143
Default one label all forms

You could set the form's Caption to that. That would mean that it would
appear in the bar at the top of the form. However, you'd have to set it, so
I don't know whether that'll save you anything.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"seeker" wrote in message
...
I want to put a label on all my forms that says YOU ARE IN ARCHIVE. Can I
do
this without placing a label on each form? Thanks.



  #3  
Old November 28th, 2009, 12:05 AM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default one label all forms

On Fri, 27 Nov 2009 13:37:01 -0800, seeker
wrote:

I want to put a label on all my forms that says YOU ARE IN ARCHIVE. Can I do
this without placing a label on each form?


You can't: a Label control resides on a form and you can't have one label
simultaneously on every form.

About the best I can think of is to have a small startup form with nothing but
that label on it; have it open all the time, and arrange that none of your
other forms overlap it on the screen.

--

John W. Vinson [MVP]
  #4  
Old November 28th, 2009, 02:36 PM posted to microsoft.public.access.forms
Linq Adams via AccessMonster.com
external usenet poster
 
Posts: 1,474
Default one label all forms

Which is probably going to be a lot of trouble, since, as John said, it'll
have to appear in front of each form, and you'll have to worry about
***where*** on any given form it appears, so as not to block important data.

I would:

Making a label on Form1
Copy the Label
Minimizing Form1
In turn, for each form, paste it in place
Minimizing each form
Repeat for all forms
When done, click to exit the database
Access will prompt you to save all forms that you've added the label to, and
you can do so, all at once.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com

  #5  
Old November 29th, 2009, 04:41 AM posted to microsoft.public.access.forms
David W. Fenton
external usenet poster
 
Posts: 3,373
Default one label all forms

=?Utf-8?B?c2Vla2Vy?= wrote in
:

I want to put a label on all my forms that says YOU ARE IN
ARCHIVE. Can I do this without placing a label on each form?


You can't do it without doing *something* in all forms. I often use
color to distinguish versions of the same database, and also set
captions of forms on load. This requires code in each form, but
since it's built into these apps that loading a form sets
colors/etc. it's easy for me to do.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:15 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.