dialog form difference between access97 and access2007

#1

I have a form opened with acDialog, with a command button that does
that
DoCmd.OpenForm "frmSRView", acFormDS, , strSql, acFormEdit,
acDialog
With Forms("frmSRView")
If (Not (.blnCancel)) Then
lngFreightId = .lngFreightId
blnCancel = False
End If
End With

DoCmd.Close acForm, "frmSRView", acSaveNo

in access97, the 'with' line is not executed until frmSRView is made
invisible
in access2007, it executes immediately, closing the form right after
it is opened
is there a workaround for this ?

#2

Roger <lesperancer (AT) natpro (DOT) com> wrote in
news:5b9883f0-8172-4be8-be90-97b53e6813da (AT) x21g2000yqa (DOT) googlegroups.co
m:

Quote:

I have a form opened with acDialog, with a command button that
does
that
DoCmd.OpenForm "frmSRView", acFormDS, , strSql, acFormEdit,
acDialog
With Forms("frmSRView")
If (Not (.blnCancel)) Then
lngFreightId = .lngFreightId
blnCancel = False
End If
End With

DoCmd.Close acForm, "frmSRView", acSaveNo

in access97, the 'with' line is not executed until frmSRView is
made invisible
in access2007, it executes immediately, closing the form right
after it is opened
is there a workaround for this ?

I think you need to decompile your code and recompile it. There is
no difference in the treatment of the acDialog switch between A97
and A2007.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

#3

On Aug 23, 1:09*pm, "David W. Fenton" <NoEm... (AT) SeeSignature (DOT) invalid>
wrote:

Quote:

Roger <lesperan... (AT) natpro (DOT) com> wrote innews:5b9883f0-8172-4be8-be90-97b53e6813da (AT) x21g2000yqa (DOT) googlegroups.co
m:

*I have a form opened with acDialog, with a command button that
*does
that
* * DoCmd.OpenForm "frmSRView", acFormDS, , strSql, acFormEdit,
acDialog
* * With Forms("frmSRView")
* * * * If (Not (.blnCancel)) Then
* * * * * * lngFreightId = .lngFreightId
* * * * * * blnCancel = False
* * * * End If
* * End With

* * DoCmd.Close acForm, "frmSRView", acSaveNo

in access97, the 'with' line is not executed until frmSRView is
made invisible
in access2007, it executes immediately, closing the form right
after it is opened
is there a workaround for this ?

I think you need to decompile your code and recompile it. There is
no difference in the treatment of the acDialog switch between A97
and A2007.

--
David W. Fenton * * * * * * * * *http://www.dfenton.com/
contact via website only * *http://www.dfenton.com/DFA/- Hide quoted text -

- Show quoted text -

done that, no luck

#4

Roger wrote:

Quote:

On Aug 23, 1:09 pm, "David W. Fenton" <NoEm... (AT) SeeSignature (DOT) invalid
wrote:

Roger <lesperan... (AT) natpro (DOT) com> wrote innews:5b9883f0-8172-4be8-be90-97b53e6813da (AT) x21g2000yqa (DOT) googlegroups.co
m:

I have a form opened with acDialog, with a command button that
does
that
DoCmd.OpenForm "frmSRView", acFormDS, , strSql, acFormEdit,
acDialog
With Forms("frmSRView")
If (Not (.blnCancel)) Then
lngFreightId = .lngFreightId
blnCancel = False
End If
End With

DoCmd.Close acForm, "frmSRView", acSaveNo

in access97, the 'with' line is not executed until frmSRView is
made invisible
in access2007, it executes immediately, closing the form right
after it is opened
is there a workaround for this ?

I think you need to decompile your code and recompile it. There is
no difference in the treatment of the acDialog switch between A97
and A2007.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/- Hide quoted text -

- Show quoted text -

done that, no luck

Have you checked you are up-to-date on both service packs and hot fixes?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

dialog form difference between access97 and access2007

comp.databases.ms-access comp.databases.ms-access

dialog form difference between access97 and access2007 - 08-23-2010 , 12:34 PM

Re: dialog form difference between access97 and access2007 - 08-23-2010 , 02:09 PM

Re: dialog form difference between access97 and access2007 - 08-23-2010 , 05:30 PM

Re: dialog form difference between access97 and access2007 - 08-23-2010 , 08:09 PM