ordre system

NOSPAMeksperten@santhell.dkNOSPAM

I'll take a look and see if its something I can do

remove NOSPAM

Tak :-) Sendt

Received, will get back soon

I have sent a mail with a couple of questions

sendt tilbage ;-)

OK

solution is sent

have you received the dB?

ja jeg har modtaget den sorry. jeg kigger stadig på den men det ser ud til at virke perfekt. Det er små simple funktioner som du kendte jeg manglede for at få den til at køre. men skal lige kigge færdig giv mig lige ca. 30 min  :-)

No problem :o)

terry > din løsning er god men der er et lille problem i den. jeg ved ikke om det er noget du kan løse når du vælger et produkt under frmbestilt. Skriver den automatisk prisen i felte "stk". hvis jeg så vælger et produkt mere nede under. tag den stk prisen for den og sætter den i begge "stk"'s celler. kan du ændre det kig selv efter ;-)

I'll take a look and see what the problem is

I've now had a look and dont think I understand the problem! Are you using the example I sent or have you made your own? The field StkPris MUST be bound to the field in the dB (control source = StkPris) If it is not then when you choose a produkt then the stkpris WILL effect ALL records!

Can you maybe exaplain?

I'm off shortly so will take a look tomorrow!

I dont have a problem here, so I am guessing you have changed something

sorry det er min fejl jeg hade ikke bundet det til stk pris..! Hvor virker det kun når den er det..?

hvor virker = hvorfor virker

udover det har jeg et lille spm. nu har jeg en i alt pris for hver produkt men hvordan får jeg lavet en alt i alt pris for hele Bestillingen..?

Properties in detail sections apply to all records, so if you change the background colour of a field it wil change in ALL records. Unbound fields are the same.



To make a total (stk and pris). The stk-pris at the moment is for only ONE item, you should perhaps change this so that it is the total for that product (stk-pris*antal), this makes the next calculation easier.

Now you will need to add a field on (for example) the the footer of the form. Then use Dsum to calcaulate. Something like this. (NOT Testes) and in this case becuae it isnt on the detail it can be unbound.

Put this code in the after update event of the form.

Me.TotalPris = Dsum("StkPris", "TableName", "ID = " & Me.ID)

You need to change the following values so tey apply to your fields.


Me.TotalPris = the name of the new field on the footer.
StkPris = the name of the field in the table which currently holds the stk. pris
TableName = The name of the table (Ordre I think).
ID = Primary key from the Bestilt table.

Just remembered!
You also need this code in the forms On Current event!

Me.TotalPris = Dsum("StkPris", "TableName", "ID = " & Me.ID)

terry > jeg har lige prøvet din kode af og den virker (after update ) men hvor mere mener du at der skulle være en event..? jeg kan ikke lige finde en dansk oversættelse til din "On Current event" i Access..?

ved aktuel eller noget i denne stil

Tak terry jeg har sat koden ind på "ved aktuel" men den kommer med fejlen at ordre nummer ikke er sat (min Primay ID) på ordre

once again I think it is because you have changed something!
Make sure that the sub forms link fields are BOTH used (child, parent)

okay. jeg har fundet fejlen. men nu virker alt omkring det så det er kanon. Mange tak for din hjælp ;)

selv tak