Question
Thread display: Collapse - |
All Answers
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
auto populate and move data for inventory db
E.g. I will enter starting sequence 301 in a field and 100 as pieces on another field and AfterUpdate should be able to populate my table (tbl1) with 301 to 400 series.
Q2. I need to move data from one table (tbl1) to another table (tblStockOut) by entering starting sequence of items to move and ending with last sequence.
e.g. I will enter starting sequence 340 on the FROM Field and sequence 359 on the TO Field and AfterUpdate should move sequence 340 to 359 to tblStockOut leaving 301 to 339 and 360 to 400 series in tbl1.
i'm using ms access 203.
hope somebody can help.