Topics Search


Views: 2
The Northwind database has an Orders form which has an Order Details subform. In the subform, there is a field called "UnitPrice".

When a new record is added in the Order Details subform, the "UnitPrice" field is first displayed with "0" (the default value for the [Order Details].UnitPrice field), and then immediately updates that value with the value contained in the [Products].UnitPrice field.

This has the desired result of copying the value in the [Products].UnitPrice field to the [Order Details].UnitPrice field.
Sponsored Links:

More topics


problems with "before update event"

I have searched the forum and have not had any luck finding a similarly related post and I hope someone can spare a moment to help out.

I can't get a Before Update Event on a form to execute correctly in a function. The error I get is:
"The expression BeforeUpdate you entered as the event property setting produced the following error: The object doesn't contain the Automation Object 'AuditTrail' "

As part of my attempt to find out why, I opened up the mystical Northwind MDB, created an identical function, tried it out and it works fine.

I used the documenter to compare properties of the forms in my mdb versus the Northwind MDB and didn't see any big show stoppers there.

The only difference I can see is that in my mdb, On the Form properties, Event tab, Before Update line, I try to enter "AuditTrail()" and the system replaces what I type with "[AuditTrail]".

In the Northwind MDB it doesn't replace what I type and keeps it as "Audit Trail()".

Does anyone have an idea if the [ ] is causing the problem and if it is what property setting do I have to change or whatever to make it work?

Tom in a very hot Austin, Texas

Northwind - how to load

In my 2000 version of Access, Northwind was easy to find. According to the book in 2010, I should be able to click on Sample Templates and see several databases including Northwind.

Nothing is listed behind this tab. What do I need to do to load these samples (hopefully, without loading a security number - this caused great difficulty originally)? It seems that using the 2000 version will not the most beneficial.

Also, where can I find out what those little icons mean?

Where can I get Northwind db?

I'm looking for copy of Northwind db

or I also have Access 2007 Bible in .PDF format (1400 pages) if anybody has the sample dbs or whatever else is on the included cd.

Find or Filter Data on Forms

We will look into the Finding or Filtering records using three different methods on the same Form. You can use any one of the three methods or all of them in your Project. We will use the Products Table from the Northwind.mdb sample Database.

Northwind sample database query

I want to ask about the Order form of northwind database that how address, city, postal code and country name of customer appears as the user select Customer ID in the combo box.

Adapting Northwind, Subform Error

They adapted Northwind to do a shirt purchase db. on the Orders/Order Subform, when they select the "Color" listbox a parameter prompt keeps appearing asking for the current ProductID.

He has to type in the product number to get the set of colors specific to a shirt selection.

Another thing that happens, is when a new row is added to the subform, no matter what new shirt is selected, the previous selected product ID "sticks" and only the filtered colorselections from the first selection appear.

but then again I don't know Northwind that well,

working with northwind template

I am trying to use the northwind template and need to know how to edit the data that comes with the template to put in mine. I have been able to edit the logo and name on the forms but in, for example, the inventory list- I can't delete the products listed.

Amending northwind template

I am trying to create my own db from the northwind template. Generally it has all the elements I need, but also several I don't, such as 'shipping'. How can I remove these without causingthere deletion to provoke error messages?

Northwind from 2007 to 2010

I've been using for a while northwind 2007.
How can I keep my records and upgrade it to the new 2010 version.??

Find something simular to "Northwind Trading" that is unlocked

I want to do find something simular to "Northwind Trading" that is unlocked, or has not data in it yet. Northwind has all the things I need, I just can not find a way to replace the existing data, and enter mind.