vba - ms-access tricky situation in product entry -
i have 2 access tables access 1 make entries products
whitepapter | pen | startdate | enddate 5 | 10 | 31/jan | 02/feb
stock product table:
whitepapter | pen 10 | 20
my goals is: when user enters data, application check against stock product , date: if end date 1st january show 5 papers , 10 pens minus main stock, if today 03 february put them main stock:
what best way approach this? know relation i'm asking how apply in best way... users use db not professionals i'm looking best way give them feature....
you can calculate number of products needed select query:
select sum(whitepaper) sumofwihtepapers, sum(pen) sumofpens eventtable between startdate , enddate;
also in access can use afterupdate
events of textboxes in order perform logic.
as rest: @ stackoverflow when got stuck while trying programm something, must show effort. have tried? can show code? did not work expected? did error message?
please read section get answers practical, detailed questions here
Comments
Post a Comment