List Box

[John G]

How would I get all of the names of the tables in a
database to appear in a list box on a form within that
same database. I need it to happen dynamically because
new tables will be added all of the time.

[derek]

I have seen, on a couple of occations, simular request for
table names in list boxes and I am intreaged as to why you
need a database that requires new tables to be added all
of the time. I have been programing for 8 years and have
never seen any need for it. If I am missing out on
something I would love to know it may be of use.

Thanks

>-----Original Message-----
>How would I get all of the names of the tables in a
>database to appear in a list box on a form within that
>same database. I need it to happen dynamically because
>new tables will be added all of the time.
>.
>

[Jacob]

I am trying to make text boxes appear only if a certain selection in a
list box is made. For instance, I have a list box I will call list1 and a
text box I will call box. On the Box properties, I have set the visible
property to no. When I select a certain option in list1, I want that
property to change to visible = true. How do I do this?

--



Jacob A. Servay
InterMed Inc.
13351 Progress Blvd.
Alachua, Fl 32615
1-800-768-8622 ext 308

[Jacob]

Dan, I have this in the equation, but it does not seem to work. Is there
something going wrong here I am not aware of? He is how I have it in the
After update....


If Me.[Equipment type] = Probe Then
Me.Pdes.Visible = True
Else: Me.Pdes.Visible = False
End If



"Dan Artuso" <dartuso@NoSpampagepearls.com> wrote in message
news:eTX0cxtSDHA.2852@tk2msftngp13.phx.gbl...

> Hi,
>
> IN the AfterUpdate event of List1:
>
> If Me.List1 = whatever Then
> Me.Box.Visible = True
> Else
> Me.Box.Visible = False
> End If
>
>
>
> --
> HTH
> Dan Artuso, Access MVP
>
>
> "Jacob" <jacob@intermed1.com> wrote in message

news:OOwIjntSDHA.2724@TK2MSFTNGP10.phx.gbl...

> > I am trying to make text boxes appear only if a certain selection in

a

> > list box is made. For instance, I have a list box I will call list1 and

a

> > text box I will call box. On the Box properties, I have set the visible
> > property to no. When I select a certain option in list1, I want that
> > property to change to visible = true. How do I do this?
> >
> > --
> >
> >
> >
> > Jacob A. Servay
> > InterMed Inc.
> > 13351 Progress Blvd.
> > Alachua, Fl 32615
> > 1-800-768-8622 ext 308
> >
> >

>
>

[Dan Artuso]

Hi,
You have to enclose strings in quotes
If Me.[Equipment type] = "Probe" Then

--
HTH
Dan Artuso, Access MVP


"Jacob" <jacob@intermed1.com> wrote in message news:O8VUHguSDHA.560@TK2MSFTNGP10.phx.gbl...

> Dan, I have this in the equation, but it does not seem to work. Is there
> something going wrong here I am not aware of? He is how I have it in the
> After update....
>
>
> If Me.[Equipment type] = Probe Then
> Me.Pdes.Visible = True
> Else: Me.Pdes.Visible = False
> End If
>
>
>
> "Dan Artuso" <dartuso@NoSpampagepearls.com> wrote in message
> news:eTX0cxtSDHA.2852@tk2msftngp13.phx.gbl...

> > Hi,
> >
> > IN the AfterUpdate event of List1:
> >
> > If Me.List1 = whatever Then
> > Me.Box.Visible = True
> > Else
> > Me.Box.Visible = False
> > End If
> >
> >
> >
> > --
> > HTH
> > Dan Artuso, Access MVP
> >
> >
> > "Jacob" <jacob@intermed1.com> wrote in message

> news:OOwIjntSDHA.2724@TK2MSFTNGP10.phx.gbl...

> > > I am trying to make text boxes appear only if a certain selection in

> a

> > > list box is made. For instance, I have a list box I will call list1 and

> a

> > > text box I will call box. On the Box properties, I have set the visible
> > > property to no. When I select a certain option in list1, I want that
> > > property to change to visible = true. How do I do this?
> > >
> > > --
> > >
> > >
> > >
> > > Jacob A. Servay
> > > InterMed Inc.
> > > 13351 Progress Blvd.
> > > Alachua, Fl 32615
> > > 1-800-768-8622 ext 308
> > >
> > >

> >
> >

>
>

[Jacob]

Thanks Dan, that did it. I am new to the VBA side of access, but watching
these news groups and leaning more each day.



"Dan Artuso" <dartuso@NoSpampagepearls.com> wrote in message
news:O5mAMvuSDHA.1804@TK2MSFTNGP11.phx.gbl...

> Hi,
> You have to enclose strings in quotes
> If Me.[Equipment type] = "Probe" Then
>
> --
> HTH
> Dan Artuso, Access MVP
>
>
> "Jacob" <jacob@intermed1.com> wrote in message

news:O8VUHguSDHA.560@TK2MSFTNGP10.phx.gbl...

> > Dan, I have this in the equation, but it does not seem to work. Is there
> > something going wrong here I am not aware of? He is how I have it in the
> > After update....
> >
> >
> > If Me.[Equipment type] = Probe Then
> > Me.Pdes.Visible = True
> > Else: Me.Pdes.Visible = False
> > End If
> >
> >
> >
> > "Dan Artuso" <dartuso@NoSpampagepearls.com> wrote in message
> > news:eTX0cxtSDHA.2852@tk2msftngp13.phx.gbl...

> > > Hi,
> > >
> > > IN the AfterUpdate event of List1:
> > >
> > > If Me.List1 = whatever Then
> > > Me.Box.Visible = True
> > > Else
> > > Me.Box.Visible = False
> > > End If
> > >
> > >
> > >
> > > --
> > > HTH
> > > Dan Artuso, Access MVP
> > >
> > >
> > > "Jacob" <jacob@intermed1.com> wrote in message

> > news:OOwIjntSDHA.2724@TK2MSFTNGP10.phx.gbl...

> > > > I am trying to make text boxes appear only if a certain

selection in

> > a

> > > > list box is made. For instance, I have a list box I will call list1

and

> > a

> > > > text box I will call box. On the Box properties, I have set the

visible

> > > > property to no. When I select a certain option in list1, I want that
> > > > property to change to visible = true. How do I do this?
> > > >
> > > > --
> > > >
> > > >
> > > >
> > > > Jacob A. Servay
> > > > InterMed Inc.
> > > > 13351 Progress Blvd.
> > > > Alachua, Fl 32615
> > > > 1-800-768-8622 ext 308
> > > >
> > > >
> > >
> > >

> >
> >

>
>

[Jacob]

I need to know if there is a code that will allow me to select
everything listed in a list box?

[Emilia Maxim]

"Jacob" <jacob@intermed1.com> wrote:

> I need to know if there is a code that will allow me to select
>everything listed in a list box?

Jacob,

here's some code:

Dim I As Integer

For I = 0 To Me![MyListBox].ListCount - 1
Me![MyListBox].Selected(I) = true
Next I

The MultiSelect property must not be 'None'.

Best regards
Emilia

Emilia Maxim
PC-SoftwareService, Stuttgart
[url]http://www.maxim-software-service.de[/url]

[Adrienne]

Gazing into my crystal ball I observed "Krish" <NOSPAM@NOSPAM.org>
writing in news:#bt8C8aZDHA.1816@TK2MSFTNGP09.phx.gbl:

> Hi Gurus,
>
> I have requirement like this..
> List box will have different subject and value will be code for
> respective subject.
> <select class=small name=subject >
> <option value="1000"> Administration</option>
> <option value="1001"> Athelet</option>
> </select>
>
> On click of a subject in the list box , value will be taken and row
> will be inserted into database. But to show users what they have
> selected , instead of value (1000) i need subject (Athelet) like
> that... Pl. help
>
> Thanks,
> krish
>
>

<select class="small" name="subject">
<option value="1000" selected="selected">Administration</option>
<option value="1001">Athelet</option>
</select>

If you're pulling the data from the table, then do an if statement for the
option element(s), <%if condition=condition then%>selected="selected"<%end
if%>


--
Adrienne Boswell
Please respond to the group so others can share
[url]http://www.arbpen.com[/url]

[Bullschmidt]

Here is a line of JavaScript code to get the text in a listbox called
InvDetailProdID:

strInvDetailProdDescr =
frm.InvDetailProdID.options[frm.InvDetailProdID.selectedIndex].text;

Perhaps you could have JavaScript write this value to a hidden field
before the post.

And here's a good JavaScript forum:

[url]http://www.codingforums.com/forumdisplay.php?s=&forumid=2[/url]

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
[url]http://www.Bullschmidt.com[/url]
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Sandra Berland]

Hi,

I am using a list box for annoucing web site
I am writting their name in "labels" but
I can't find a way to write their corresponding internet adress
to alow the opening of their website when you click on their name.

thanks in advance

[Bluetone]

I have a list called WorkList. I have a query named Recordset_Cat. I want to
populate the list box with the results of Recordset_Cat. I want to SELECT
(multiple items) that population with anything that matches to WorkList. I
have this so far: <!--- <SELECT NAME='s_work_cats'
SIZE='5' MULTIPLE CLASS='spaced'
ID='s_work_cats'> <cfoutput
query='Recordset_Cat'> <OPTION
Value='#Recordset_Cat.SCat#' <cfif List.Value eq
listFindNoCase(defaultValue, List.Value)>Selected</cfif>>
#Recordset_Cat.SCat#</option>
</cfoutput></SELECT> ---> Which was kindly provided by a real programmer. I
can't figure out what to do with List.Value and defaultValue. I would assume
the first List.Value should be changed to WorkList.Value but that give me an
error. Suggestions? Thanks!

[Bluetone]

Have made some changes to the code: <!--- <SELECT NAME='s_work_cats'
SIZE='5' MULTIPLE CLASS='spaced' ID='s_work_cats'>
<cfoutput query='Recordset_Cat'> <OPTION Value='#Recordset_Cat.SCat#'
<cfif #Recordset_Cat.SCat# eq listFindNoCase(WorkList,
#Recordset_Cat.SCat#)>selected</cfif>>#Recordset_Cat.SCat#</option>
</cfoutput> </SELECT> ---> This populates the list box but no items are
being selected. Any suggestions?

[Bluetone]

Here is the working code for future reference for whomever: <SELECT
NAME='s_work_cats' SIZE='5' MULTIPLE CLASS='spaced'
ID='s_work_cats'> <cfoutput query='Recordset_Cat'> <OPTION
Value='#Recordset_Cat.SCat#' <cfif listFindNoCase(WorkList,
#Recordset_Cat.SCat#)>selected</cfif>>#Recordset_Cat.SCat#</option>
</cfoutput> </SELECT>

[Rob]

Copy and paste browser source into a post.