Recent content by acnovice

From Customer Inquiry form, I want to copy mainForm frmCustInqPOLog2 with subform sfrmInqSubTBL1. There are QNo fields which are text type on mainform and subform and they are Primary Key as well (table InquiryLog and InqSubTBL1). When I click "Duplicate" command btn from main form, I want to...

Hi TheAceMan1, Thank you so much ... it works great. BTW, What are you doing out there on Christmas day ? You save my day ... thank you again and have a great holiday. Everyone above... especially pointed out effeciency of the Inventory system... I will get back to you after holiday. Thank...

Still I have a problem on this code. When I create an Invoice, it seems like doesn't check the Current q'ty and return the following message. Ship Quantity is greater than Current Quantity! "Can't save Invoice!" I checked there are enough q'ty in inventory. Following is the...

PHV, I changed the sub form control and got following error.

MichaelRed, Similar but Invoice is always working on true q'ty which is greater than 0 but consider SafetyQ'ty.

I'm stuck in follwing error. Thank you.

Hi MichaelRed, You're right. I fully agree with your suggestion with more detail and deep consideration. Actually, we don't need to say to our customer the products are out of stock. The Inventory tells not only CurrentQ'ty but also SafetyQ'ty and ExtraQ'ty. They are all linked to Stock...

Hi TheAceMan1, Hope you're still there. I'm getting another compiler error from following line of your code. hilighted Msg and it says "Compile error. Invalid qualifier."

Hi guys, Thank you for all of postings and I will review later. Let me get back to you after Christmas. TheAceMan1... I really appreciate your posting... Thank you so much. Talk more detail later. Merry Christmas.

Hi TheAceMan1, I tried your code and I'm getting following error. Compile error: Statement invalid outside Type block. and highlighted I disabled afterUpdate of the form. Thank you.

Hi, I have small inventory system using access. When I create an invoice, shipp q'ty is subtracted from inventory. What I want to do is if q'ty is 0 or less than shipQty, give the warning message and not to allow to create an invoice until inventory has enough q'ty. For an Invoice...

WildHare, You're right. I need a DLookup function to be re-executed not a form refreshing. I can put a code in On_Current event but one thing that I'm considering is "causing performance issues". If I can control the event refreshing interval, it would be nice. Thank you.

GingerR, I tried yours but it doesn't change anything at all. Thank you.

Hi, Is there any way to refresh DLookup function in my subform ? I have a main form(frmQchart) with a sub-form(sfrmSIsummary) with datasheet format and I'm using DLookup to bring up few fields (fob1,fob2,,,) from tblFOB. Once I brought up the fields from sfrmSIsummary and change the data...

Hi, Subform refresh problem. I have a main form with data sheet sub-form. There is a SPN combo box in sub-form to bring up part number if it is registered. If the part number is not registered yet, open part number registration form. My problem is after register a new part number, it...