Search results

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

That sounds like a sound idea but I dont have a subform for the option group to be able to display all 4 records for the 4 answers (each answer is a single record in tblAnswers). So I need to programmatically load each of the 4 records and populate fields (either option group labels or text...

Attached. I think I missed the employee bitmaps folder hence they are not displaying.

This field will not be the only fields to populate, I also want the yes/no true field and clause text fields. These will not me visible but when a user selects an answer their selected will go red and then the true answer will go green and make the clause become visible (if the user selects the...

I have a form with a combo box where users can select a question. each question has a question ID and this filters the Answers table to 4 answers. But I need these 4 answers text field to populate the forms option group buttons labels and Me("Answer" & i).caption where i loops from 1 to 4 does...

I have a copy of northwind2003. I could try and past later

Hi, Sorry but this is an Access 97 database that has been converted to Access 2000. The easy way is to go to the Employees forms and if the first employee is Nancy Davolio with a bitmapped picture then it is from Access 97. see www (dot) ammara (dot) com//nancy_davolio

Access hobby programmer from 1998.