Help on Help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Billy - 14 May 2007 02:32 GMT

I am lost. Please direct me.

In the Microsoft Access 2007 Help, under Access Developer Home >
Access Macro Actions > OpenForm Macro Action the following reference
excerpt exists:

Examples
Set the value of a control by using a macro
The following macro opens the Add Products form from a button on the
Suppliers form. It shows the use of the Echo, Close, OpenForm,
SetValue, and GoToControl actions. The SetValue action sets the
Supplier ID control on the Products form to the current supplier on
the Suppliers form. The GoToControl action then moves the focus to the
Category ID field, where you can begin to enter data for the new
product. This macro should be attached to the Add Products button on
the Suppliers form.

I would like to review the macro referenced here but don't know where
to look. What database has the Suppliers form and the Add Products
form? Is this a downloadable sample database they are speaking
about? If it is downloadable, what is the link or how do I open it
from Access?

Reply to this Message

Maurice - 14 May 2007 07:37 GMT

That would be the Northwind database. When you startup Access look on the
left side of the screen. You see template categories, under the option from
Microsoft Online you'll find the option to choose the Northwind DB. When you
click on it it will be downloaded to your hard drive (internet connection
required...)

Maurice

> I am lost. Please direct me.
>
[quoted text clipped - 18 lines]
> about? If it is downloadable, what is the link or how do I open it
> from Access?

Reply to this Message

Billy - 14 May 2007 09:30 GMT

> That would be the Northwind database. When you startup Access look on the
> left side of the screen. You see template categories, under the option from
[quoted text clipped - 26 lines]
> > about? If it is downloadable, what is the link or how do I open it
> > from Access

Thanks for letting me know this. I have downloaded the Northwinds
sample database from Microsoft and opened the Northwinds database.
Once Opened, I have went to the navigation bar on the left and dropped
down the button next to "Northwind Traders" and chosed to see FORMS.
Under that, there are no forms called Supplier. There is a form
called "Supplier Details" and a form called "Supplier List". Neither
of these appear to have a "Add Products" button. Where should I be
looking?

Reply to this Message

Maurice - 14 May 2007 19:22 GMT

Billy,

I've done som checking and you are right I don't see a button "Add Product"
on the suppliers forms.

I do see a button "Add Product" however on the "Inventorylist form". On the
top left you'll find a button (picture and label) called "Add Product".

Rightclick on the label and look under "On Click". There you'll find the
embedded macro to play around with.

Hope this helps

Maurice

> > That would be the Northwind database. When you startup Access look on the
> > left side of the screen. You see template categories, under the option from
[quoted text clipped - 35 lines]
> of these appear to have a "Add Products" button. Where should I be
> looking?

Reply to this Message