I need to have the controls (images) in the form, frmName evaluated to find
out which ones will be made visible. The names of the controls are
Image51X, Image51Z, Image52X, Image52Z, etc. The code needs to read:
Do While...
Forms![frmName].[??????].Visible = True
.MoveNext
Loop
I am unable to get the syntax correct to increment to image names.
--
Bob Rice www.geocities.com/arrice.geo 3 1749
If you've got the control name stored in a variable strControl, try:
Forms![frmName].Controls(strControl).Visible = True
--
Doug Steele, Microsoft Access MVP http://I.Am/DougSteele
(No private e-mails, please)
"Bob Rice" <ar*****@comcast.net> wrote in message
news:CeUrb.117019$mZ5.790066@attbi_s54... I need to have the controls (images) in the form, frmName evaluated to
find out which ones will be made visible. The names of the controls are Image51X, Image51Z, Image52X, Image52Z, etc. The code needs to read:
Do While... Forms![frmName].[??????].Visible = True .MoveNext Loop
I am unable to get the syntax correct to increment to image names.
-- Bob Rice www.geocities.com/arrice.geo
Still can't get it.
site = 51X
Do While site = .[Site Name]
If (.[DateIn] >= indate And .[DateIn] < outdate) Or (.[DateIn] <
indate And .[DateOut] > indate) Then
'Forms![frm Park].[Image51X].Visible = True --- *****
This line works fine
goodtext = "Image" & site
Forms![frm Park].[goodtext].Visible = True
End If
.MoveNext
Loop
goodtext won't work. Trying "Forms![frmName].Controls(strControl).Visible =
True" won't do it either.
--
Bob Rice www.geocities.com/arrice.geo
"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl... If you've got the control name stored in a variable strControl, try:
Forms![frmName].Controls(strControl).Visible = True -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (No private e-mails, please) "Bob Rice" <ar*****@comcast.net> wrote in message news:CeUrb.117019$mZ5.790066@attbi_s54... I need to have the controls (images) in the form, frmName evaluated to find out which ones will be made visible. The names of the controls are Image51X, Image51Z, Image52X, Image52Z, etc. The code needs to read:
Do While... Forms![frmName].[??????].Visible = True .MoveNext Loop
I am unable to get the syntax correct to increment to image names.
-- Bob Rice www.geocities.com/arrice.geo
Reread what I suggested.
Forms![frmName].Controls(strControl).Visible = True
In other words,
Forms![frm Park].Controls(goodtext).Visible = True
not
Forms![frm Park].[goodtext].Visible = True
--
Doug Steele, Microsoft Access MVP http://I.Am/DougSteele
(No private e-mails, please)
"Bob Rice" <ar*****@comcast.net> wrote in message
news:fBUrb.119366$275.345950@attbi_s53... Still can't get it.
site = 51X Do While site = .[Site Name] If (.[DateIn] >= indate And .[DateIn] < outdate) Or (.[DateIn] < indate And .[DateOut] > indate) Then 'Forms![frm Park].[Image51X].Visible = True --- ***** This line works fine
goodtext = "Image" & site Forms![frm Park].[goodtext].Visible = True End If .MoveNext Loop goodtext won't work. Trying "Forms![frmName].Controls(strControl).Visible
= True" won't do it either.
-- Bob Rice www.geocities.com/arrice.geo "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message news:%2****************@TK2MSFTNGP09.phx.gbl... If you've got the control name stored in a variable strControl, try:
Forms![frmName].Controls(strControl).Visible = True -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (No private e-mails, please) "Bob Rice" <ar*****@comcast.net> wrote in message news:CeUrb.117019$mZ5.790066@attbi_s54... I need to have the controls (images) in the form, frmName evaluated to find out which ones will be made visible. The names of the controls are Image51X, Image51Z, Image52X, Image52Z, etc. The code needs to read:
Do While... Forms![frmName].[??????].Visible = True .MoveNext Loop
I am unable to get the syntax correct to increment to image names.
-- Bob Rice www.geocities.com/arrice.geo
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: dont bother |
last post by:
Hey,
I have these attributes:
index
which is a numerical value value
vector
which is a numerical float value
and I want to concatenate like this:
|
by: foodic |
last post by:
i am fresher to C++ programming, and I just
want to learn Concatenating Calls, I have
written a program,
class SetMe {
public:
void setX(int x) {_x = x;}
void setY(int y) {_y = y;}
void...
|
by: nwheavyw8 |
last post by:
I am currently trying to write a simple PHP script that will split an
uploading file up into 500kb "chunks", then read and concatenate them
back together when accessed for download. I can't seem...
|
by: Dixie |
last post by:
I have a problem using Dev Ashish's excellent module to concatenate the
results of a field from several records into one record.
I am using the code to concatenate certain awards onto a...
|
by: Juan |
last post by:
Does any one know if there are reported bugs when concatenating strings?
When debugging each variable has the correct value but when I try to
concatenate them some values are missing (I canīt see...
|
by: ebobnar |
last post by:
I need to call the function LoadImage which take a LPCTSTR argument to
specify the path to the image to load. However, I need to create this
path dynamically from user input by concatenating...
|
by: FB's .NET Dev PC |
last post by:
Interesting note, the code below as is will attempt to cast what is clearly
indicated as a string into a double. This is becuase the use of + as a
concatenation operator. The error message...
|
by: bob brar |
last post by:
hi,
I have the following function in a class.
Public Function getCustomers() As DataSet
Dim Db As New CDatabaseAccessor
getCustomers = Db.getData("SELECT A.*, RTRIM( A.TITLE)+', '+ RTRIM...
|
by: Richard L Rosenheim |
last post by:
Is there any built-in method or mechanism for concatenating two arrays of
byte together?
I haven't come across anything to do this, and was just checking before I
implement some code.
Richard...
|
by: Mary |
last post by:
I have a student who has a hyphenated first name. If I concatenate the
name like this: StudentName:( & ", " &
), it works as expected. If, however, I try to get
the first name first by...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |