Search results

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...

Thank you for advising, I'm using 2013 and attached is the db with .mdb

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...

Got it, thank you very much, appreciate all your help!

Thank you for making it in different way, it's cool.

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...

I think if they reduce qty, they have to manually delete what they don't need. Thank for thinking about the different cases ...

Thank you for modified, it really helped.

Yeah, you're right if they reduce qty then they have to manually delete record. You sample is what I need. Thank you very much.

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...

Thank you very much. You made my day's very good. First time in this forum and found out it's very useful.

Again, thanks for quick responding. I found out why it didn't work ... My access sw set Security Warning which disabled VBA Macro, I set it enable then it works. I don't know if you familiar with this, everytime I open access sw, there're a bar on the top say 'Security Warning Cetain content in...

First, I would like to say thanks for quick responding. I'm attaching db for your consider. You're welcome to fix anything on the db. What I would like to do is open rptMaverick report and click on the link of part no, for example '3384305', then it'll open another report named rptPart-list...

Hello, I got the same problem, I tried what you explain but It still doesn't work. I have no ideal. Can you take a look on my database? If so, I'll post it Thank you very much.