vba_php,
Thank you very much for take a look and work on this db. I did download and test but somehow it doesn't work right. When I created new record, it doesn't work for the calculation. Also, if I make a change on existing record, it doesn't work right away unless I go to next record or close...
Please show me how to store/add calculate field in the table. Thank you very much.
I attached the database for review. In the database, I have 3 fields, QtyReceived, QtyRemain, QtyUsed.
The calculation is QtyRemain = QtyReceived - QtyUsed (where QtyUsed is in the subform and it will add total of...
Hi the DBguy,
Thank you very much, this is exactly what I want. But I do have question … If I add more Version of of Software Version List (such as Pro 13, Pro 14 ..)
Then I support to see these new added when I click on the combo box of 'Version Checkout' but I don't see it unless I click on...
theDBguy,
Thanks for checked it out. Here's the situation:
I have mainform which is 'Software'. I have 2 subforms 'software_version' and 'version_checkout'.
The DB relationship is a software can have one or many versions and each version can be check out by one or many people ...
For example if...
Please help ...
I have a Mainform and 2 subforms. In one of subforms, I have a combox box which I would like to get data from a table of another subform. I did select the field I want from that table but it listed everything, how to do it to get only the data base on record selected.
I attached...
isladogs/vba_php,
Continue with the 'sample db', if I have another subform name subform1, this one is also use id to link to Mainform and subform purch. In this subform1, I have combo box name 'Purchase' and I would like to select all the data from 'Purch' in Subform for Purchase combo box in...
Yes if I reduce Qty to 2 then it should let me enter only 2 records or increase Qty then increase number of record. Can you guide me how to do this? Thanks a lot
I have Main Form name MainForm and I have Sub Form named SubForm
In the MainForm I have a field name Quantity and I would like when I enter Quantiy such as 3 then I just let people to enter only 3 rows in
the SubForm, if I enter 1 then I just let people to enter only 1 rows in SubForm.
How do...