(Msg. 1) Posted: Fri Jul 04, 2008 3:00 am
Post subject: List box Full warning! Add to elertz Archived from groups: microsoft>public>access (more info?)
If my list box is full my vertical scroll bar appears! If I had a label
[lblWarnimg] is it possible to become visible once my list box becomes full?
--
Thanks in advance for any help with this......Bob
WindowsXP..MS Access 2007
(Msg. 2) Posted: Fri Jul 04, 2008 3:00 am
Post subject: Re: List box Full warning! Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On Jul 3, 8:07 pm, "Bob Vance" <rjva... RemoveThis @ihug.co.nz> wrote:
> If my list box is full my vertical scroll bar appears! If I had a label
> [lblWarnimg] is it possible to become visible once my list box becomes full?
>
> --
> Thanks in advance for any help with this......Bob
> WindowsXP..MS Access 2007
I guess you could fake it by getting the ListCount and if it's over a
certain number, declare it "full". Doesn't make sense, because you
can scroll a listbox, but anyway...
(Msg. 3) Posted: Fri Jul 04, 2008 3:00 am
Post subject: Re: List box Full warning! Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
It is a warning that some clients have not paid but as I only have room to
show 6 on my form , by glancing at it sometimes I don't see there is a 7th.
So hence the warning arrow to show me there is more than
6..............Regards Bob
<pietlinden.DeleteThis@hotmail.com> wrote in message
news:fc4323ce-4bbf-4105-8e7a-a772e15b3c20@56g2000hsm.googlegroups.com...
On Jul 3, 8:07 pm, "Bob Vance" <rjva....DeleteThis@ihug.co.nz> wrote:
> If my list box is full my vertical scroll bar appears! If I had a label
> [lblWarnimg] is it possible to become visible once my list box becomes
> full?
>
> --
> Thanks in advance for any help with this......Bob
> WindowsXP..MS Access 2007
I guess you could fake it by getting the ListCount and if it's over a
certain number, declare it "full". Doesn't make sense, because you
can scroll a listbox, but anyway...
(Msg. 4) Posted: Fri Jul 04, 2008 3:00 am
Post subject: Re: List box Full warning! Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On Jul 3, 9:33 pm, "Bob Vance" <rjva....TakeThisOut@ihug.co.nz> wrote:
> It is a warning that some clients have not paid but as I only have room to
> show 6 on my form , by glancing at it sometimes I don't see there is a 7th.
> So hence the warning arrow to show me there is more than
> 6..............Regards Bob<pietlin....TakeThisOut@hotmail.com> wrote in message
>
> news:fc4323ce-4bbf-4105-8e7a-a772e15b3c20@56g2000hsm.googlegroups.com...
> On Jul 3, 8:07 pm, "Bob Vance" <rjva....TakeThisOut@ihug.co.nz> wrote:
>
> > If my list box is full my vertical scroll bar appears! If I had a label
> > [lblWarnimg] is it possible to become visible once my list box becomes
> > full?
>
> > --
> > Thanks in advance for any help with this......Bob
> > WindowsXP..MS Access 2007
>
> I guess you could fake it by getting the ListCount and if it's over a
> certain number, declare it "full". Doesn't make sense, because you
> can scroll a listbox, but anyway...
why not just show the listcount in the tab? for example "Queries (5)"
(Msg. 5) Posted: Fri Jul 04, 2008 8:20 am
Post subject: Re: List box Full warning! Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
yah dude are you designing an app for handicapped people or
something?
On Jul 3, 6:07 pm, "Bob Vance" <rjva....RemoveThis@ihug.co.nz> wrote:
> If my list box is full my vertical scroll bar appears! If I had a label
> [lblWarnimg] is it possible to become visible once my list box becomes full?
>
> --
> Thanks in advance for any help with this......Bob
> WindowsXP..MS Access 2007
(Msg. 6) Posted: Fri Jul 04, 2008 8:01 pm
Post subject: Re: List box Full warning! Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
OK you caught me out I have 7 list boxes on my Form not all are 6 rows, I
might not remember how many each has , but if I had a "Warning" would make
it so much easier.........Regards Bob
<pietlinden.DeleteThis@hotmail.com> wrote in message
news:1dc9ce78-ae29-41b0-9786-e497a0b3c0c6@m45g2000hsb.googlegroups.com...
> On Jul 3, 9:33 pm, "Bob Vance" <rjva....DeleteThis@ihug.co.nz> wrote:
>> It is a warning that some clients have not paid but as I only have room
>> to
>> show 6 on my form , by glancing at it sometimes I don't see there is a
>> 7th.
>> So hence the warning arrow to show me there is more than
>> 6..............Regards Bob<pietlin....DeleteThis@hotmail.com> wrote in message
>>
>> news:fc4323ce-4bbf-4105-8e7a-a772e15b3c20@56g2000hsm.googlegroups.com...
>> On Jul 3, 8:07 pm, "Bob Vance" <rjva....DeleteThis@ihug.co.nz> wrote:
>>
>> > If my list box is full my vertical scroll bar appears! If I had a label
>> > [lblWarnimg] is it possible to become visible once my list box becomes
>> > full?
>>
>> > --
>> > Thanks in advance for any help with this......Bob
>> > WindowsXP..MS Access 2007
>>
>> I guess you could fake it by getting the ListCount and if it's over a
>> certain number, declare it "full". Doesn't make sense, because you
>> can scroll a listbox, but anyway...
>
> why not just show the listcount in the tab? for example "Queries (5)"
(Msg. 7) Posted: Fri Jul 04, 2008 8:01 pm
Post subject: Re: List box Full warning! Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
"Full" being a relative term, it's probably better to follow the suggestion
offered to show the exact number of items in each list.
You can create a text box next to, or above, each of the list boxes to
display that information. Make it's control source:
=[lstAssociatedListBox].[ListCount]
Obviously, you'll need to change the names from lstAssociatedListBox to the
names of the list boxes in your form.
If you are using Access 2003 or 2003, you can apply conditional formattting
to the textboxes to change the background or foreground colors if you want
to highlight themwhen they have values over a target.
George
"Bob Vance" <rjvance.TakeThisOut@ihug.co.nz> wrote in message
news:%23mssawa3IHA.4036@TK2MSFTNGP02.phx.gbl...
> OK you caught me out I have 7 list boxes on my Form not all are 6 rows, I
> might not remember how many each has , but if I had a "Warning" would make
> it so much easier.........Regards Bob
> <pietlinden.TakeThisOut@hotmail.com> wrote in message
> news:1dc9ce78-ae29-41b0-9786-e497a0b3c0c6@m45g2000hsb.googlegroups.com...
>> On Jul 3, 9:33 pm, "Bob Vance" <rjva....TakeThisOut@ihug.co.nz> wrote:
>>> It is a warning that some clients have not paid but as I only have room
>>> to
>>> show 6 on my form , by glancing at it sometimes I don't see there is a
>>> 7th.
>>> So hence the warning arrow to show me there is more than
>>> 6..............Regards Bob<pietlin....TakeThisOut@hotmail.com> wrote in message
>>>
>>> news:fc4323ce-4bbf-4105-8e7a-a772e15b3c20@56g2000hsm.googlegroups.com...
>>> On Jul 3, 8:07 pm, "Bob Vance" <rjva....TakeThisOut@ihug.co.nz> wrote:
>>>
>>> > If my list box is full my vertical scroll bar appears! If I had a
>>> > label
>>> > [lblWarnimg] is it possible to become visible once my list box becomes
>>> > full?
>>>
>>> > --
>>> > Thanks in advance for any help with this......Bob
>>> > WindowsXP..MS Access 2007
>>>
>>> I guess you could fake it by getting the ListCount and if it's over a
>>> certain number, declare it "full". Doesn't make sense, because you
>>> can scroll a listbox, but anyway...
>>
>> why not just show the listcount in the tab? for example "Queries (5)"
>
>
(Msg. 8) Posted: Sat Jul 05, 2008 3:00 am
Post subject: Re: List box Full warning! Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Why would you like one!
"a a r o n . k e m p f @ g m a i l . c o m" <aaron.kempf.DeleteThis@gmail.com> wrote in
message
news:75954be1-6d00-4b33-a0af-579385499d6a@q24g2000prf.googlegroups.com...
yah dude are you designing an app for handicapped people or
something?
On Jul 3, 6:07 pm, "Bob Vance" <rjva....DeleteThis@ihug.co.nz> wrote:
> If my list box is full my vertical scroll bar appears! If I had a label
> [lblWarnimg] is it possible to become visible once my list box becomes
> full?
>
> --
> Thanks in advance for any help with this......Bob
> WindowsXP..MS Access 2007
All times are: Eastern Time (US & Canada) (change) Goto page 1, 2
Page 1 of 2
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Search
Profile
Private Messages
Log in/Register/Password
Office Other