By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,067 Members | 1,274 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,067 IT Pros & Developers. It's quick & easy.

A Level Help

P: 2
hi im an alevel student and need help with my database.

basically im doing a school art stock system and my table looks like this,

Product Code xyz
Upper School Stock 10
Lower School Stock 23

i want 2 command buttons that:
- will deduct one from stock when i select a stock field
- will add one etc etc

so example - click the deduct command button when mouse is placed in Upper school - and stock goes down to 9 automatically.

how can i achieve this? can ne one help?

Feb 1 '08 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 446
I hope this is not homework !!

You need 4 buttons to do this, two for Upper school and two for Lower school; they can be small as only need '+' and '-' captions

The code for adding to Upper school is;
Expand|Select|Wrap|Line Numbers
  1. Me.[Upper School Stock] = Me.[Upper School Stock] + 1
You can work out the others yourself!

Feb 5 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.