Search results for query: *

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

PHV, I tried your code and I'm getting a following error. Run-time error '3315': Field 'tblProduct.ShopPN' cannot be a zero-length string. The "frmProductReg" updates tblProduct. Thank you for your answer ahead.

THWatson, Thank you for the reply but I need to open PR form(Product Registration)to register a NewPartNumber. What I want to do is when PR form is opened, new part number is already there and click Save button to register new part number. I want to avoid retype part number from PR. I...

Hi, I have a comboBox for part number and set to LimitToList "Yes". Following is my NotInList Event Handler. If the part number hasn't registered yet, click Yes, then product registration(PR) form's opened and register part number. My question is that when the PR form's opened, new part...

Golom, It's good to know that. I appreciate your reply. Have a good day.

Hi CautionMP, That works great. Thank you.