controls on form won't set to invisible, can't chg caption property
M.L. Sco Scofield
Some simple newsgroup etiquette.
NEVER EVER attach ANYTHING to a newsgroup message.
First, most people are still using dial up connections and do not want to take the time to download files. They get so annoyed, they
ignore the message and you'll never get an answer. Those of us with high speed connections don't like to waste the bandwidth.
Second, no one in their right mind will ever open an attachment anymore. There are too many viruses going around.
Occasionally, someone may take an interest and request a database. Then, and only then, do you email it directly to the person.
Part of using the newsgroups is to FOCUS on your problem, one piece at a time. If you're having problems with code, describe what is
working, what isn't working, and then copy and paste only the relevant piece in to a message so we can all look at it in plain text.
Do that and you'll find all kinds of people willing to help.
--
Sco
M.L. "Sco" Scofield, MCSD, MCT, MCP, MSS
Useful Metric Conversion #10 of 19: 10 rations = 1 decoration
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
"Rob Nussbaum" <pu_b...@yahoo.com> wrote in message news:049501c0df08$41b3f8e0$9ee62ecf@tkmsftngxa05...
Hello,
I have a series of 100 lbls and txtboxes that I'd like to have the user view only
those which have data and values associated with them. Those which are not
populated, I would like them to remain invisible.
I'm also trying to chg the caption property of each to correspond to a record in
another table, and was using a qry to do this. It works for some of the lbls (15
of them), but not all (I have 18 entries).
I have attached the front and backend dbs which I cannot get the desired result.
Help! If anyone can suggest a way to fix either problem, I would be very
appreciative.
Here is a brief listing and description of the items in the 2 dbs I've attached:
1. DBBACKEND:
tblSecurityDef - I want to use SecurityLevel field to rename the labels on
sfrmSecurityMatrix
tblSecurityMatrix - tbl of 100 "cols" that the user will enter info
2. DBFRONTEND:
qrySecurityDef - simply queries all the items in SecurityLevel field of
tblSecurityDef
qrySecurityMatrix - qrys the info from the tblSecurityMatrix
sfmrSecurityMatrix - form of 100 lbls & txtboxes that I want initially
invisible and then the fields to be visible & renamed based on corresponding
vlaues from qrySecurityDef. I want the same number of fields visible as there
are records in the qry.
*In the code of sfrmSecurityMatrix, I have added funtionality to the event of
Load, and this is area I would like assistance. I can't figure out why the 2
loops I've setup won't:
1. make all the lbls & txtboxes invisible with this line of code:
Me.Controls(strVisLblColNum).Visible = False
2. chg the caption property of ALL the lbls that have an associated value from
the qrySecurityDef
Me.Controls(strLblCaptionColNum).Caption = rst![SecurityLevel]
It works for the first 29 items, then won't for the rest
Thanks,
Rob
Brendan Reynolds
wondering when someone was going to say something like that. The response to
the posting of attachments seems somewhat more subdued here in the Microsoft
newsgroups than at some other newsgroups, and as a relative newcomer to the
Microsoft newsgroups myself, I felt it wasn't my place. So I add anyone who
posts an attachment to my killfile. Intolerant of me, I know, but after some
five years of politely asking people to desist, and often being flamed for
it, I'm out of patience. I'm thinking of adding a line to my sig - if you
want me to read your questions, don't post attachments.
--
Brendan Reynolds
bren...@indigo.ie
http://www11.ewebcity.com/brenreyn
"M.L. Sco Scofield" <S...@ScoBiz.com> wrote in message
news:OmH6GYx3AHA.1372@tkmsftngp04...
M.L. Sco Scofield
It is NEVER inappropriate to let newcomers know what the rules are and to remind "regulars" when they forget.
Just try to do it a litter nicer than I do. I get very frustrated when I donate my time which I normally get $100 an hour for and
people out here think it's their God-given-right to get "free" help and don't need to follow the rules. It's why I used to spend a
hour a day answering questions and now only show up for 10 or 15 minutes a week.
Best of luck.
--
Sco
M.L. "Sco" Scofield, MCSD, MCT, MCP, MSS
Useful Metric Conversion #10 of 19: 10 rations = 1 decoration
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
"Brendan Reynolds" <bren...@indigo.ie> wrote in message news:ud$C9E93AHA.1704@tkmsftngp04...
Mr. Smith
wrote:
>It is NEVER inappropriate to let newcomers know what the rules are and to remind "regulars" when they forget.
>
>Just try to do it a litter nicer than I do. I get very frustrated when I donate my time which I normally get $100 an hour for and
>people out here think it's their God-given-right to get "free" help and don't need to follow the rules. It's why I used to spend a
>hour a day answering questions and now only show up for 10 or 15 minutes a week.
>
With this attitude, you'd better stay in your cave, and continue getting
your $100 an hour, and save us your rants and pathetic attitude, and
bragging about how much you get paid.
No one here cares about what you think, and us other people are willing
to help for those who need the help without the attitude, and for the
people who abuse that, we simply move on without such attitude.
Stephen Lebans
such a public fashion.
Do everyone a favour and go back and hide behind your rock. SCO has
helped many more people then you could ever hope to.
I'd plonk you but twits like yourself that hide behind fake handles will
just reappear under a new guise. Perhaps your next incarnation should be
"IamAJerk".
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Mr. Smith" <jsm...@no-email.com.invalid> wrote in message
news:ruuaht4d22kjkj1kf...@4ax.com...
Arvin Meyer
good advice on these groups as he has, I'm sure we'll value your
contributions as highly as we do his.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
"Mr. Smith" <jsm...@no-email.com.invalid> wrote in message
news:ruuaht4d22kjkj1kf...@4ax.com...
Lookinghawk
"It is a condition of life that all things are a gift. A child, a
freindship, a job, a cutomer, a house , a stereo, a conversation, a
business, any and all material or intangible things of life. Each day we
must remember these things by the constant reminder of their presence and
the circle of life that they come from, as one does not survive without the
other."
"A gift should never be taken for granted,and should always be taken care of
with the greatest respect. One should always bow to humble oneself when
receiving a gift. This is one of the most important rules in life and cannot
be disputed by any mortal being."(At one time this was a custom of all
peoples, but like all important things of life, they have been forgotten by
others.)
"We are not supposed to be conditional, life hands us conditions that we
must accept. That being, that all things in life are a gift."
"A child is born with this knowledge, and gifts his parents with a
unconditional love regardless. It is the parents that teach their children
conditions of life and eventually teach them to be conditional. Teaching
them there is a left or a right , a right from a wrong, an up from a down
etc... Instead of teaching examples of life and how they are all connected
in the circle of life."
"The circle of life has to remain humble, or it will not remain a circle."
"All decisions in life concern the circle and must be taken in careful
thought and consideration to prevent distortion of the circle. In doing so
we humble ourselves to the circle for the circle, a gift from our creator."
Lookinghawk, LAKOTA SIOUX
"Mr. Smith" <jsm...@no-email.com.invalid> wrote in message
news:ruuaht4d22kjkj1kf...@4ax.com...
Mr. Smith
<Stephe...@lebans.com> wrote:
>Well Mr. Smith you certainly are a brave fellow to voice your opinion in
>such a public fashion.
Of course unlike you mr. brown nose.
>Do everyone a favour and go back and hide behind your rock. SCO has
That's where you and your friend belong, or probably under the bridge.
>helped many more people then you could ever hope to.
In your dreams.
>I'd plonk you but twits like yourself that hide behind fake handles will
>just reappear under a new guise.
Translation: You're too stupid to use usenet filter.
>Perhaps your next incarnation should be
>"IamAJerk".
That is reserved for your mom and dad, jackass.
Bob Anderson
newsgroup. Like "Cheap ticket to HONG Kong" BUT, it is more inappropriate
for Mr. Smith to slam SCO in that way.
"Mr. Smith" <jsm...@no-email.com.invalid> wrote in message
news:ruuaht4d22kjkj1kf...@4ax.com...
Bob Anderson
"Lookinghawk" <Looki...@home.com> wrote in message
news:7QqR6.87410$p33.1...@news1.sttls1.wa.home.com...