Calculating prices on a form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rye1982 - 30 Jul 2008 20:32 GMT

I would like to make an invoice form in which, when loaded, it calculates
prices.

For example, the user has entered the number of products into a table and
the form multiplies the number by the price, housed in another table.
I'm also thinking I'll need an IF statement somewhere as well, as I need to
check whether the customer is based in the US or Canada, since prices vary
depending on the country. Any help on this point would be useful.

Thanks a lot!

Reply to this Message

Damon Heron - 30 Jul 2008 21:19 GMT

No need to re-invent the wheel. Look at the various Access templates and
examine one of the dbs that have invoicing. I believe there is one called
"Orders" or "Order Inventory" or something like that. Then just import the
forms and/or code into your db.

Damon

>I would like to make an invoice form in which, when loaded, it calculates
> prices.
[quoted text clipped - 7 lines]
>
> Thanks a lot!

Reply to this Message

Klatuu - 30 Jul 2008 21:53 GMT

The Northwind Database that comes with Access.
They are the Orders and Orders Subform Forms

To be able to use multiple price lists, you would need to have a table
structure that supports them and then modify the code in the Orders Subform
ProductID After Update event to select the correct price.

Signature

Dave Hargis, Microsoft Access MVP

> No need to re-invent the wheel. Look at the various Access templates and
> examine one of the dbs that have invoicing. I believe there is one called
[quoted text clipped - 14 lines]
> >
> > Thanks a lot!

Reply to this Message