Urgent access help!!

gareth.e · 16 Dec 2008 at 13:39

When I click the command button 24 I want it to subtract 1 off the quantity in stock and add 1 to the quantity sold...

How do I do this in the expression builder or in terms of code!

This project is due in 3 hours

GravyMonster · 16 Dec 2008 at 13:50

hit the '...' button on the property pane for onclick and in the code window type the below in cmd #24 handler

Code:

[quantity field name].value = [quantity field name].value -1

I accept payment in Krispy Kremes and/or KFC.

gareth.e · 16 Dec 2008 at 14:07

Spunkey said:
hit the '...' button on the property pane for onclick and in the code window type the below in cmd #24 handler

Code:

[quantity field name].value = [quantity field name].value -1

I accept payment in Krispy Kremes and/or KFC.

I was about to propose marrige to you... But it doesn't do anything..

I've entered:

Code:

[handset-quantity-in].[Value]=[handset-quantity-in].[Value]-1

GravyMonster · 16 Dec 2008 at 14:25

you dont need the []'s

gareth.e · 16 Dec 2008 at 14:28

Spunkey said:
you dont need the []'s

made it so it's this

Code:

[handset-quantity-in].[Value]=[handset-quantity-in].[Value]-1

and still doesnt work... I CBA I'll let them sort it out themselves!!!

edit: it automatically puts them back

Dolph · 16 Dec 2008 at 14:44

Is the form based on an updatable query or table in the first place? if it's not, you won't be able to edit the bound fields within the text.

gareth.e · 16 Dec 2008 at 16:38

Dolph said:
Is the form based on an updatable query or table in the first place? if it's not, you won't be able to edit the bound fields within the text.

based on a table.. I scrapped the idea

hand in is in 20 mins... It's looking alright considering im the old peson who has a clue about databases in my group.. I've got some pretty sales charts and everything lol

edit the whole the stock control system was the only fall down of the db..