Recent content by Anouk

The reason I have 3 prices, is because we give 10% discount as from 50 euros on normal products, we don't give discount on glass, and books are a different VAT rate. Ofcourse I know that the calculations I make in a foottext will not be shown in a table. Northwind DOES show what a customer has...

test dbase. Please help Here is my test db. (4 tables, 2 forms.) I hope somebody can have a look at it, and make it work. All I want is when I have placed an order is to see it in my orderdetails. Now its all zero. Also if I change the price of a product in my product table, I only want it to...

Oh dear, now I have to find out how to do that....

Sorry, I DID zip it....

post database I tried to, but allthough its completly empty and only has 4 tables and 2 forms, it exceeds the amount allowed here. Its 240 and you are only allowed 100.

form details stored in tables You seem to be a very patient person, and quite an expert of what I can see in this forum. My compliments. Could I please make a small database example and send it to you as a zipfile. Then you can see where I go wrong. It is probably a simple thing what needs to...

I give up Well I done everything you said, and I dont have items in my tables, because I made a test db, just to try it out. (empty) so no need for an upate query. In the AfterUpdate I put: Me.Price=Me.cboProductID.Column(4) which is the 5th. Thanks anyway, I think I will hang myself :o

vallues do not show up in subform This is driving me crazy. I managed to get the prizes in the form, done this with the cbo bit. But now they dont show up in my subform table...Even if I make a query I cant see anywhere what people have ordered. I take it that the Me. thing is the same as the...

overwriting tables Thank you so much for your reply, I understand the first part. (I am Dutch and my ACCESS is in Dutch). I added the prize to the Orderdetails table (it's called VerkEx ). I added the fields on the form. Now the hard bit. I asked for the details of the box ProductID and...

HELP!!! I am getting quite desperate. I am a novice. I have made a database for customers, products, etc. They all have good relations. I have made a query where I can see who bought what and when and how much it costs. Now here's the problem. When my prices in my product list (this is the table...