Max Wanadoo
max.wanadoo at gmail.com
Thu Jul 30 13:59:15 CDT 2009
FWIW I thing multi-user is not a requirement. It should only be run by a competent person, ie the develop for specific purposes and as it runs "UNDER" the project "root" folder and is "date specific" it should never conflict with anything else. What you could do is perhaps put a flag up to say it is "In progress" and stop another invocation starting. Ma -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: 30 July 2009 19:53 To: Access Developers discussion and problem solving Subject: Re: [AccessD] Has anyone ever sen a listbox not display all rows? > Why didn't I think of that.... Speaking of which, I got Eatbloat (my version) populating tables to get around the list control data source 2K string length limitation. I created msys tables in my library container and then populate those tables instead of building up a huge comma delimited string for the list control data source. Now the table can hold as many objects as needed and the lists use the tables as their data source. It just occurred to me that I may need to add "multi-user" handling because my version can theoretically be used in many different FEs at the same time. I'll probably need to track which FE the objects are coming from, something like that. Anyway, it works great so far. John W. Colby www.ColbyConsulting.com Max Wanadoo wrote: > Why didn't I think of that.... > > Max > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby > Sent: 30 July 2009 19:02 > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Has anyone ever sen a listbox not display all rows? > > Export it out to a text file, then import it back in to a new name. Delete > the old, rename the new > back to the old name. That might break the spell. > > John W. Colby > www.ColbyConsulting.com > > > David McAfee wrote: >> 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