Recent content by tmd63

I have a table that has a Part Number field. I wish to filter a form by using a combo box. I want to have the combo box display the part number of the entry and then filter the item using the part number, adding either <All> and <NEW> to the list to allow selection. Is this possible? Or do I...

The down side is if the SH17 system was built by your boss and he refuses to change it. Even if it is SH17!

If it was up to me. I would have created this with nomalised tables and used queries to pull the information together for the Altium Libraries but some backward non-programming idiot made this and now I have to sort their sh17.

That is what I am trying to do, Using one form with 28 fields, the population of which is dependent on the name of the table that populates it. maybe using a subform.

I had been busy with Access 97 and have worked my way up to 2007. At one point I had a full MRPII database with everything except time management. It even had Cadstar Parts integration through ODBC and user dependant control.

Completed my database. It is an Access 2007-2016 format with tricks that many may find useful

Sorry for the delay, but I had completed my practise database. This is an Access 2007-2016 database with many tricks that others may find useful.

If I could re-make the tables. I would have them in a single ODBC part database and use separation queries into the CAD libraries, but I have to work the other way round in this case (unfortunately).

To give an idea these are tables that have a link by Part Number 'ONLY'. So the relationship is a table which lists the part under strField1 and I can add the strTblName to each part via a separate table (if needed) But depending on which table, there can be upto 28 strFields (strField1 to...

I have a number of tables and a table listing the linked tables. These are a series of parts tables with data for each type, but I need to list and update/add depending on the type of part (so I may have a type capacitor or type resistor, with fields of value, voltage for capacitors, but value...

Just to clarify. I have 3 tables. Questions, Answers and Test. Question are linked to Answers Each question has 4 Answers. There are 115 Questions in 9 Sections, Some Sections have 15 Questions and some have 10. I need to select the Section, and then have the Question combo box list the...

Thanks that appears to work a treat. Opps. I spoke too soon. After entering 2 questions and answers, the query now produces 2 duplicate questions apart from the 2 already answered.

I have a query that works fine when there is data in both tables, but not when there is no records in tblTest. SELECT tblQuestions.ID, tblQuestions.Question, tblQuestions.Module FROM tblQuestions, tblTest WHERE (((tblQuestions.ID)<>[tblTest].[lngQuestionID]) AND...

Hi, Yes. Thank for trying the database, I have Access 2003 and it is not so easy to open the 2013 accdb files. MDB files would be better in 2003 format or 2000. But I got the basics sorted and I have included the code here for future references. Private Sub cboQuestionID_AfterUpdate() Dim...

I got the employee bitmaps this time. :D