Search results

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.

Thanks, Paul. It is Autofill to display the info from another Table but not to save it to avoid storing the same thing in 2 tables. e.g. I have the tblCar that predefined and stored 3 fields, CarNo, CarType, CarDes. So when CarNo in the Form was key in, I want CarType and CarDes to be auto...

Hi, I am new to MS Access, I have created 3 tables, tblDefect, tblCar and tblDesc. I also created a Form to input data into tblDefect, I would like to auto-insert some of the data from tblCar and tblDesc when the fields match with the tblDefect. Is it possible? I try to google but not sure what...

Thanks, CJ & Gasman. Appreciate your inputs.

Hi, I start to build a DB for a product defects tracking system. Is there a guide line as of "how to plan to set up access Tables" to avoid future changes due to mistake or not properly planned? Thanks

I used Excel spreadsheets as a database to keep track product defects, RMA return etc. and have come to decide using MS Access. i hope to learn and gain knowledge from this site.