Hi all,

I'm using Access 2002 and am having trouble creating a button to open
another form.

I've done a bit of research but am just starting out with all this so
am having trouble.

Can someone advise me in basic terms how to do this?

Thanks.

Kim

Kim <(E-Mail Removed)> wrote in news:3a69d53e-bffc-42ed-b4d7-
(E-Mail Removed):

> Hi all,
>
> I'm using Access 2002 and am having trouble creating a button to open
> another form.
>
> I've done a bit of research but am just starting out with all this so
> am having trouble.
>
> Can someone advise me in basic terms how to do this?
>
> Thanks.
>
> Kim
>

In design view for the form, make sure to enable the wizard on the
toolbbox, then drag a command button from the bar to the form. Select
form operations from the wizard, select open form from the options then
select your target form. You can choose to open the form to a specific
record, or all records..



--
Bob Q.
PA is y I've altered my address.

On Apr 4, 9:45*am, Bob Quintal <rquin...@sPAmpatico.ca> wrote:
> Kim <anast...@gmail.com> wrote in news:3a69d53e-bffc-42ed-b4d7-
> f0fa12dbb...@k10g2000prh.googlegroups.com:
>
> > Hi all,
>
> > I'm using Access 2002 and am having trouble creating a button to open
> > another form.
>
> > I've done a bit of research but am just starting out with all this so
> > am having trouble.
>
> > Can someone advise me in basic terms how to do this?
>
> > Thanks.
>
> > Kim
>
> In design view for the form, make sure to enable the wizard on the
> toolbbox, then drag a command button from the bar to the form. Select
> form operations from the wizard, select open form from the options then
> select your target form. You can choose to open the form to a specific
> record, or all records..
>
> --
> Bob Q.
> PA is y I've altered my address.

Thanks so much Bob.

Worked perfectly. )

On Apr 4, 9:45*am, Bob Quintal <rquin...@sPAmpatico.ca> wrote:
> Kim <anast...@gmail.com> wrote in news:3a69d53e-bffc-42ed-b4d7-
> f0fa12dbb...@k10g2000prh.googlegroups.com:
>
> > Hi all,
>
> > I'm using Access 2002 and am having trouble creating a button to open
> > another form.
>
> > I've done a bit of research but am just starting out with all this so
> > am having trouble.
>
> > Can someone advise me in basic terms how to do this?
>
> > Thanks.
>
> > Kim
>
> In design view for the form, make sure to enable the wizard on the
> toolbbox, then drag a command button from the bar to the form. Select
> form operations from the wizard, select open form from the options then
> select your target form. You can choose to open the form to a specific
> record, or all records..
>
> --
> Bob Q.
> PA is y I've altered my address.

Oops... all the steps seemed to work but when I press the button while
it's running I get the message "The expression On Click you entered as
the event property setting produced the following error: Object or
class does not support the set of events.

Any advice on how to fix this?

Thanks again!!!

On Sun, 3 Apr 2011 17:13:31 -0700 (PDT), Kim <(E-Mail Removed)> wrote:


>
>Oops... all the steps seemed to work but when I press the button while
>it's running I get the message "The expression On Click you entered as
>the event property setting produced the following error: Object or
>class does not support the set of events.
>
>Any advice on how to fix this?
>
>Thanks again!!!

Please open the form in design view; select the button; click the ... icon by
its Click event; open the code window and copy and paste the code to a message
here. Also post the Name property of the form that you're trying to open.

One suggestion: don't use blanks, punctuation, or special characters
(particularly parentheses, apostrophes and quotes) in the names of objects. If
you're doing so try changing the name of the form to contain only letters,
numbers and underscores and see if it works better.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/For...-US/accessdev/
http://social.answers.microsoft.com/.../en-US/addbuz/
and see also http://www.utteraccess.com

On Apr 4, 10:21*am, John W. Vinson
<jvinson@STOP_SPAM.WysardOfInfo.com> wrote:
> On Sun, 3 Apr 2011 17:13:31 -0700 (PDT), Kim <anast...@gmail.com> wrote:
>
> >Oops... all the steps seemed to work but when I press the button while
> >it's running I get the message "The expression On Click you entered as
> >the event property setting produced the following error: Object or
> >class does not support the set of events.
>
> >Any advice on how to fix this?
>
> >Thanks again!!!
>
> Please open the form in design view; select the button; click the ... icon by
> its Click event; open the code window and copy and paste the code to a message
> here. Also post the Name property of the form that you're trying to open.
>
> One suggestion: don't use blanks, punctuation, or special characters
> (particularly parentheses, apostrophes and quotes) in the names of objects. If
> you're doing so try changing the name of the form to contain only letters,
> numbers and underscores and see if it works better.
> --
>
> * * * * * * *John W. Vinson [MVP]
> *Microsoft's replacements for these newsgroups:
> *http://social.msdn.microsoft.com/For...-US/accessdev/
> *http://social.answers.microsoft.com/.../en-US/addbuz/
> *and see alsohttp://www.utteraccess.com

Every time I go into "view code" my access crashes. I think I need to
reinstall first.

On Sun, 3 Apr 2011 18:46:36 -0700 (PDT), Kim <(E-Mail Removed)> wrote:

>On Apr 4, 10:21*am, John W. Vinson
><jvinson@STOP_SPAM.WysardOfInfo.com> wrote:
>> On Sun, 3 Apr 2011 17:13:31 -0700 (PDT), Kim <anast...@gmail.com> wrote:
>>
>> >Oops... all the steps seemed to work but when I press the button while
>> >it's running I get the message "The expression On Click you entered as
>> >the event property setting produced the following error: Object or
>> >class does not support the set of events.
>>
>> >Any advice on how to fix this?
>>
>> >Thanks again!!!
>>
>> Please open the form in design view; select the button; click the ... icon by
>> its Click event; open the code window and copy and paste the code to a message
>> here. Also post the Name property of the form that you're trying to open.
>>
>> One suggestion: don't use blanks, punctuation, or special characters
>> (particularly parentheses, apostrophes and quotes) in the names of objects. If
>> you're doing so try changing the name of the form to contain only letters,
>> numbers and underscores and see if it works better.
>> --
>>
>> * * * * * * *John W. Vinson [MVP]
>> *Microsoft's replacements for these newsgroups:
>> *http://social.msdn.microsoft.com/For...-US/accessdev/
>> *http://social.answers.microsoft.com/.../en-US/addbuz/
>> *and see alsohttp://www.utteraccess.com
>
>Every time I go into "view code" my access crashes. I think I need to
>reinstall first.

That's not going to help, I fear. I don't think it's the Access executable
that's corrupt; it's probably your database.

Try Tools... Database Utilities... Compact and Repair (after making a backup).

If that doesn't work try the suggestions at
http://www.granite.ab.ca/access/corruptmdbs.htm
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/For...-US/accessdev/
http://social.answers.microsoft.com/.../en-US/addbuz/
and see also http://www.utteraccess.com