Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / July 2006

Tip: Looking for answers? Try searching our database.

Control does not work

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mommio2 - 30 Jul 2006 05:08 GMT
Hi,
    I copied this from a sample database.  I am making a menu form for the
user to decide if he wants to start a new record, edit an old one, or run a
report.  This is supposed to start a new record, and it works in the sample
database, but when I click it in mine, nothing happens.  Any suggestions?
Thanks!

In the On Click event of the control on the form I have:
               Menu_Items Macros.NewStudent : On Click

In the macro group Menu_Items Macros, in the macro NewStudent I have:
    GoToRecord
    Object Type = Form
    Object Name = Students (the table and form name)
    Record = New
tina - 30 Jul 2006 06:42 GMT
in the OnClick event of the control on the form, select the macro name from
the droplist *and do NOT add anything to the name*. i'm guessing the the
actual name of your macro is NewStudent, not NewStudent : On Click.

hth

> Hi,
>      I copied this from a sample database.  I am making a menu form for the
[quoted text clipped - 11 lines]
>      Object Name = Students (the table and form name)
>      Record = New
Mommio2 - 30 Jul 2006 14:31 GMT
Thanks for your reply!  Ok, the plot thickens ...  I tried removing ": On
Click:"  It was also listed in the macro under Macro Name with the ": On
Click" included, so I deleted it there, too.  Now, both the form control and
the macro name are "NewStudent".  When I go to form view and click on the
control, nothing happens.  Do I need to tell it anywhere else that the form
"Students" is a different form from the one my control is on, which is
called "Menu"?

> in the OnClick event of the control on the form, select the macro name
> from
[quoted text clipped - 21 lines]
>>      Object Name = Students (the table and form name)
>>      Record = New
Mommio2 - 30 Jul 2006 14:38 GMT
Wait a minute!  Something is happening!  I see now that (both ways) it does
move the record counter at the bottom to the 13th (1st blank) record.  It
just leaves all the information from the first record on the form.  What do
I need to do to tell it to blank out the form, too?  Thanks!

> in the OnClick event of the control on the form, select the macro name
> from
[quoted text clipped - 21 lines]
>>      Object Name = Students (the table and form name)
>>      Record = New
tina - 30 Jul 2006 20:12 GMT
is the DefaultView property of your form set the Single Form, Continuous
Forms, or Datasheet?

hth

> Wait a minute!  Something is happening!  I see now that (both ways) it does
> move the record counter at the bottom to the 13th (1st blank) record.  It
[quoted text clipped - 26 lines]
> >>      Object Name = Students (the table and form name)
> >>      Record = New
Mommio2 - 30 Jul 2006 23:17 GMT
It is Single Form. Is that my problem?

> is the DefaultView property of your form set the Single Form, Continuous
> Forms, or Datasheet?
[quoted text clipped - 37 lines]
>> >>      Object Name = Students (the table and form name)
>> >>      Record = New
Mommio2 - 30 Jul 2006 23:23 GMT
Yippee!  That was it!  Should I also change that property on the form I went
to (in addition to the form I came from)?  Also, how do I switch the focus
from the first form to the second, i.e. make the second form pop on top of
the other?  THANKS!!!

> is the DefaultView property of your form set the Single Form, Continuous
> Forms, or Datasheet?
[quoted text clipped - 37 lines]
>> >>      Object Name = Students (the table and form name)
>> >>      Record = New
tina - 31 Jul 2006 00:09 GMT
to move the focus to another form, try using the SelectObject action in your
macro.

hth

> Yippee!  That was it!  Should I also change that property on the form I went
> to (in addition to the form I came from)?  Also, how do I switch the focus
[quoted text clipped - 42 lines]
> >> >>      Object Name = Students (the table and form name)
> >> >>      Record = New
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.