Functional ... Crashes

[Question Boy]

I have a database running on WinXp and Office 2003 SP3 on my laptop and
everything works great!

Once deployed on a pc running WinXp and Office 2003 SP3 there are 2 forms
that cause access to crash whenever they are activated. Even if I try to
open them in design mode, access crashes. Every single time.

I have done a compile, compact and repair. No change.

Can anyone guide me on resolving this.

Thank you,

QB

 

[NTC]

major bummer;

import all objects - - except those 2 forms - - into a new db. and sanity
check if all opens/works ok

then import those forms - - 1 at a time - - and check the first before you
go on to the second....

 

[NKTower]

Several things you might look at...

a) open code view of a form that isn't a problem. TOOLS, then REFERENCES
and list the things that have checks. Compare with TOOLS/REFERENCES on the
machine with the problem. Are you missing a library, or have a "MISSING:"
tag on an item in the problem machine?

b) On the good machine, examine the form in design view and see if it is
using any 3rd-party objects, or objects not normally found in the standard
toolbox. For example, COMDLG32 for supporting BROWSE (FILE/OPEN, FILE/SAVE
etc.) or maybe the CALENDAR control? Usually if you have this omission you
get something like "Control contains no object" error message, but not a
full-blown crash.

c) I once ran into a client-developed application where they had one
'master' form with about a dozen pages (using tab control) and each page had
several dozen bound cntrols on it. They hit the wall with having too many
controls in the complex form. Are the problematic forms very complex?
However, this problem occurred on all machines, not just some.