Search results

Hi Paul, Following your advice, I may be getting there but encountered some catches seeking your further advice. I attached a sample file to illustrate the situation. I successfully called the data from vlookup table but not the last row. Secondly, I repeated the method for the column...

Thanks for your prompt advice! Removing duplicates can be achieved as per the said feature. However, it has a challenge to leave the latest one, not any one.:confused:

I would like to remove the old duplicates leaving distinct list with the latest info. Can someone help advise the way to accomplish it. sample file is attached for reference. Thanks!

Paul, Thanks for your advice!

I have two spreadsheets: A sheet contains sku no, unit price and other details of each sku no and B sheet contains sku nos and order quantities of last month. I need to get the details of skus from sheet A into matching skus in sheet B for further analysis. Can someone advise me how to...

Hi CJ, Could you please advise what the below two statements do especially "between 1 and 50" Select Case Company case company between 1 and 50 Thanks!

Hi CJ, I tried to modify the code as below but still not working. Your further help is greatly appreciated. Private Sub txtSKU_Enter() If Me.Brand like “*GoGo*” Or Me.Brand like “*Mango*” Then txtSKU.ValidationRule = ">=0000001 and <=9999999" txtSKU.ValidationText...

Hi CJ, I believe Company is the check field to determine the validation rule. I update the 2nd row of statement to case company like "*Sony*" Select Case Company case company between 1 and 50 It did not work as intended and always applied case else validation rule. Is there...

I have a validation rule in a control of form: between 1 and 999999. Now I need to have different criteria subject to the value of other control, say between 1 and 9999999 if the value of A company in company control. Is it beyond the capability of validation rule? If so, any other idea to...

Hi The_Doc_Man, Many thanks for your good advice that I might neglect it in the past. It is good for practicing it again.

Thanks for your advice. I have got a reference sample to achieve what you said. However, when I completed the project, the remaining mandatory fields must be filled as well. How can the system to check if the mandatory fields have been filled when the project is completed?

Hi Dennis, Yes, the form is linked with a query.

Below should read as the example given.

Thanks for your response. There is a reason for the check that put in this field. The data is entered while the progress from the beginning to the end. When the project is completed, this field must be completed as an end of the project. The check cannot be put in the form, otherwise the...

I tried to check if all required fields have been filled before saving the record using the following code. Private Sub txtReportNo_BeforeUpdate(Cancel As Integer) If IsNull(Me.cboMainCat) Then Cancel = True MsgBox ("Please enter Data for Main Cat")...

Hi spikepl, I need the help to show all records when I do not select any names in the listbox and select other report format based on current listbox form.

Thanks for your suggestion. I will try it later.

Hi Paul, I now understand your suggestion fully and tried it successfully. Many thanks!

Hi Ranman256, Thanks for your suggestion. I have not set up the pick table yet. Is it complicated to it setup? Any further reference to set up this feature. Thanks!

Currently I am using a multiple select list box in a form to select the engineer names for a report. I am looking for some enhancement. Firstly when I do not select any name, there is no records displayed. I need to show all records if I do not select any name in the dropdown list. I...