Group:  Microsoft Outlook ยป microsoft.public.outlook.program_vba
Thread: OpenForm Action Cancelled error only when using Vista

Geek News

OpenForm Action Cancelled error only when using Vista
Crossh 12/19/2008 7:51:02 PM
I have an 2003 access database that works fine on Windows XP, but errors out
on the docmd.openform line of code (OpenForm action was cancelled) after
upgrading to Vista. Strangely enough, this is only a problem for one form, so
far. All the other forms that have identical code work fine. Basically, I
have
the user select a record from a subform and then click on a command button
(which
rebuilds the query for another form, saves it, and then opens the form to
allow editing of the selected record).

Here's the code:
DoCmd.OpenForm "frmNameOfForm", , , , , , "Edit"

Thanks for your help.

Re: OpenForm Action Cancelled error only when using Vista
"Ken Slovak - [MVP - Outlook]" <kenslovak[ at ]mvps.org> 12/19/2008 9:29:01 PM
This is an Outlook group, you might have better luck posting in an Access
group.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"Crossh" <Crossh[ at ]discussions.microsoft.com> wrote in message
news:78789110-3308-46EB-9ECA-35CD85FD6ACE[ at ]microsoft.com...
[Quoted Text]
>I have an 2003 access database that works fine on Windows XP, but errors
>out
> on the docmd.openform line of code (OpenForm action was cancelled) after
> upgrading to Vista. Strangely enough, this is only a problem for one form,
> so
> far. All the other forms that have identical code work fine. Basically, I
> have
> the user select a record from a subform and then click on a command button
> (which
> rebuilds the query for another form, saves it, and then opens the form to
> allow editing of the selected record).
>
> Here's the code:
> DoCmd.OpenForm "frmNameOfForm", , , , , , "Edit"
>
> Thanks for your help.
>

Re: OpenForm Action Cancelled error only when using Vista
Crossh 12/30/2008 6:51:47 PM
Sorry, my mistake. FYI, posted in Access, still no answers.

"Ken Slovak - [MVP - Outlook]" wrote:

[Quoted Text]
> This is an Outlook group, you might have better luck posting in an Access
> group.
>
> --
> Ken Slovak
> [MVP - Outlook]
> http://www.slovaktech.com
> Author: Professional Programming Outlook 2007.
> Reminder Manager, Extended Reminders, Attachment Options.
> http://www.slovaktech.com/products.htm
>
>
> "Crossh" <Crossh[ at ]discussions.microsoft.com> wrote in message
> news:78789110-3308-46EB-9ECA-35CD85FD6ACE[ at ]microsoft.com...
> >I have an 2003 access database that works fine on Windows XP, but errors
> >out
> > on the docmd.openform line of code (OpenForm action was cancelled) after
> > upgrading to Vista. Strangely enough, this is only a problem for one form,
> > so
> > far. All the other forms that have identical code work fine. Basically, I
> > have
> > the user select a record from a subform and then click on a command button
> > (which
> > rebuilds the query for another form, saves it, and then opens the form to
> > allow editing of the selected record).
> >
> > Here's the code:
> > DoCmd.OpenForm "frmNameOfForm", , , , , , "Edit"
> >
> > Thanks for your help.
> >
>
>

Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net