Recent content by cyliyu

Sure. Thanks for your help.

Attached file the sample and would like to seek help. In the frmRMA, the field LRU (combo box) and TextBox624 where I get stuck. When a product was selected from the LRU and TextBox373 (Result based on Combo box319), I would like to have the result as shown in post 1 (Text Box 2).

Thanks, theDBguy. will try again the query method as I don’t get it works. will check where goes wrong.

I am using a single view form

Need help, please! I have a Combo box in the Form when the field was selected from the list. I want a Text box 2 to show a result when certain criteria are meet based on the data selected from the Combo box and another Text box 1 info. e.g. Case Combo Box Text Box 1 Text Box 2 1 APPU DT1...

Yes, all the 13 sheets will have the same fields. I am adding a product field into the Access table to have all the 13 products into one Table. A Listbox and Combobox was the initial plan but were worry end-user may select the wrong product to input the data. The DB consists of In-house Defect...

Given a Car as an example, it has a Display Unit, Air-Con system and more. The DB will have the Main Menu to display all the system, and the individual system end-user will make a selection to input the defect info etc. If 1 button per system is not recommended, what should be a correct way of...

The database basically to track the product life span, failure rate, supplier A and B repair rate, the number of serviceable days and more. Once hit certain criteria, the product needs to scarp etc. A pivot chart will need to tabulate base on different required too. I will base on One Table...

I am in the progress of setting up the Access table and need some advise before I expand it. 1) I have at least 13 products and each product has its own sheet in Excel. I was thinking should I just combine them in one Access table? Does any disadvantage or concern I need to take note of? 2)...

May need to change the description field to ease to notify the user. Thanks again.

Thanks, June7. The formula works. I have removed the field from my table and need to see how to make it real-time update.

Basically, the Reject Frequency was to check how many times the equipment has been sent out for repair. The very first time the data entry for the unit out for repair, it counted as "1", the same unit the next out for repair again, it counted as "2". The condition was, both the serial number and...

Thanks, June7. The 1st part works. The formula used in Excel calculation was =SUMPRODUCT(($J$6:$J$1686=$J1573) * ($K$6:$K$1686 = $K1573)), "") Where J Column was serial no and K Column was date code I am not sure how this can be done in Access.

I need some help with the following. 1) I have the code included in the Combo box, the Text333 works but not Text373. Private Sub Combo319_Change() Me.Text333 = Me.Combo319.Column(1) Me.Text373 = Me.Combo319.Column(2) End Sub 2) How do perform the "Frequency Reject" auto calculation...

That is correct.