[AccessD] Has anyone ever sen a listbox not display all rows?

Well done - way to go man!!

Max



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David McAfee
Sent: 31 July 2009 00:57
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Has anyone ever sen a listbox not display all rows?

I took this bit of advice, deleted the tab control, and all listboxes.

Built a new list box and using buttons, changed the listbox rowsource and it
seems to be working.

David

On Thu, Jul 30, 2009 at 10:06 AM, Max Wanadoo <max.wanadoo at gmail.com> wrote:

> Hmm difficult David, without seeing it.
> What I tend to do is to have the tabs replaced with buttons (make them
look
> similar) and in the main form I have ONE sub form.
>
> Depending which button they click, the embedded sub form name is changed
> and
> it is then requeried.  Effectively this means (for 5 tab items, 5
> same-sized
> sub forms) but each one is only loaded when required (JIT).  This also
> reduces the load time for a form with many tabs with many associated
> populating of controls on them.
>
> Max
>
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David McAfee
> Sent: 30 July 2009 17:59
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Has anyone ever sen a listbox not display all rows?
>
> I have.
>
> I've even completely rebuilt it. I think it may be the form that is some
> how
> corrupt.
>
> I remember reading somewhere that a form can only have 255 controls, even
> if
> its over time (deleting controls, adding controls, deleting controls).
> I have redesigned this form for a department that didnt know what it was
> that they want five times.
>
> I'm wondering if this somehow could be an issue.
>
> I may have to rebuild the whole form...which sucks because it is very
> complex. :(
>
> David
>
>
> On Thu, Jul 30, 2009 at 1:50 AM, Max Wanadoo <max.wanadoo at gmail.com>
> wrote:
>
> > David,
> > Try COPYING a list box that works and then change the attributes to what
> > you
> > need.
> > That sometimes works.
> >
> > Max
> >
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com