[AccessD] In a legacy system how control a Vba MsgBox

Max Wanadoo max.wanadoo at gmail.com
Thu Jan 28 14:12:02 CST 2010


> If msgbox(...) = vbYes then
>end If

Oh, maybe I misread the requirement.  Sorry

I don't think he  wants the  handle though.

Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mike Mattys
Sent: 28 January 2010 20:02
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] In a legacy system how control a Vba MsgBox

Hi Edward,

I think you just want to say:

If msgbox(...) = vbYes then
end If

If you want to actually get the window handle,
you'll need to use the Windows API ...

-
Michael R Mattys
MapPoint and Database Dev
www.mattysconsulting.com
-
----- Original Message ----- 
From: "Edward Zuris" <edzedz at comcast.net>
To: <accessd at databaseadvisors.com>
Sent: Thursday, January 28, 2010 2:39 PM
Subject: [AccessD] In a legacy system how control a Vba MsgBox


> 
> Dear AccessD Forum
> 
> I am doing a little automation work within a legacy
> environment.
> 
> From inside some VBA code, a form is opened, given some
> data, where buttons and controls are clicked.
> 
> The opened form, ft001CreateTasks, has a MsgBox asking
> a Yes/No question.
> 
> What kind of handle do I use to click the YES button
> on the message box modal form ?
> 
> Or are there some other way of tackling this issue ?
> 
> Thanks.
> 
> Sincerely,
> Ed Zuris.
> 
> 
>    ====================================================
>                 Example Vba Code snippet
>    ====================================================
> 
>    strVar = ""
>    DoCmd.OpenForm "ft001CreateTasks", , , strVar
> 
>    strVar = "Rake Yard"
> 
>    Forms("ft001CreateTasks").cboTaskType.Value = strVar
> 
>    Call Forms("ft001CreateTasks").cboTaskType_Click
> 
>    . . . . now a message box open on the form . . . . .
> 
> 
>    ====================================================
>    ====================================================
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list