B
bobby
I have developed an adp (using Access 2002 Developer Edition on an XP box).
I used the package & deployment wizard to distribute to PCs without Access
installed. This goes fine just as the installation completes successully.
However, I get an odd crash now. On one form there is a subform (continuous
forms) where users can doubleclick on a row to bring up some details. The
VBA code contains one line of code which causes a severe crash (Illegal
operation... Program must now close...) The single line of code is :
docmd.OpenForm "frmMyForm",acNormal, , , acFormReadOnly, acDialog,
Me.OrdreNr
IMHO nothing strange here.
I really don't know what is going on and I cannot recreate on my machines.
Here are some possible leads(?)
- Client machines are all W2K sp4. I have testet on my own W2K sp4 box but
no problem there.
- I extensively use conditional formatting on the form and the 2 subforms
and apparently they are a bit "moody"
- the main form contains two subforms, each in continuous forms mode having
record source set as a parameterized stored procedure.
- all clients are updated to MDAC 2.8
Apart from that I don't have much to go by.
Any ideas out there as to what I should investigate?
I used the package & deployment wizard to distribute to PCs without Access
installed. This goes fine just as the installation completes successully.
However, I get an odd crash now. On one form there is a subform (continuous
forms) where users can doubleclick on a row to bring up some details. The
VBA code contains one line of code which causes a severe crash (Illegal
operation... Program must now close...) The single line of code is :
docmd.OpenForm "frmMyForm",acNormal, , , acFormReadOnly, acDialog,
Me.OrdreNr
IMHO nothing strange here.
I really don't know what is going on and I cannot recreate on my machines.
Here are some possible leads(?)
- Client machines are all W2K sp4. I have testet on my own W2K sp4 box but
no problem there.
- I extensively use conditional formatting on the form and the 2 subforms
and apparently they are a bit "moody"
- the main form contains two subforms, each in continuous forms mode having
record source set as a parameterized stored procedure.
- all clients are updated to MDAC 2.8
Apart from that I don't have much to go by.
Any ideas out there as to what I should investigate?