[AccessD] Form doesn't work on new laptop

Hello Dwylene,

i have seen this weird stuff to on a complicated form on a laptop.
In this case the combobox will not show all the records that are present in
the
rowsource table (5000 records), only a few hundred. My solution is beginning
typing a fake record (not fake in the recordsource table) like zzzzz in the
combobox. Because its the last record, it then shows all the records.
It isn't a elegant solution, but it works fine. Other solutions are welcome.

Pedro Janssen


----- Original Message -----
From: "Dwylene Garcia" <garciad at kentri.org>
To: <accessD at databaseadvisors.com>
Sent: Monday, January 26, 2004 9:45 PM
Subject: [AccessD] Form doesn't work on new laptop


> I have an odd problem that has managed to stump several IT people.  We
> are on the verge of giving up but I thought I would make an attempt to
> ask this group if anyone has seen such a problem.
>
> I have a fairly complicated form (one-to-many-to-many relationship,
> Main form with two subform, one subform filters the other subform) and
> this form has worked for 2 years and still does work on every desktop in
> our office.  However, one employee received a new laptop this week
> running Windows 2000, Office XP and Access 2000 (the same as all the
> desktops) and the database opens and it appears that the less
> complicated forms work fine but this one form which is the main form
> used will not populate the subforms correctly.  It recognizes there are
> records but it won't show them in the combo box... I have found this
>
http://support.microsoft.com/default.aspx?scid=kb;en-us;208866&Product=acc20
00
> in the knowledge base that seems to restate the problem exactly.
> However, I'm looking for a solution that does not involve altering my
> form since it does work on the desktop computers.   Why will it work on
> a desktop and not a laptop????
>
> I don't have time to alter the database to make it work on this one
> laptop when 7 other desktop computers run the database fine.  I'm
> wondering if anyone else has ever experienced this and I'm hoping that
> it's something silly that I overlooked while troubleshooting.  I think
> we have hit all the obvious troubleshooting points like reinstalling MS
> Office, I took the database off the network and tried to run from the
> C:/.  When it first happened we received an error "Object invalid or no
> longer set.", that error is not showing up now.
>
>
>
> Dwylene Garcia
> Computer Applications Trainer
> Kent Hospital, Department of Education
> Email: garciad at kenthospital.org
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>