Search results

Hi All I am under pressure from the client to import data for individuals into the database despite not having their preassigned unique identity number available for every individual. This ID number is the primary key for the table in which individuals' records are stored. Can anyone suggest a...

Hi All I'm really stuck and I've tried this from more than one angle: (See the attached graphic) I have a list of survey questions that I need to enter collected responses for into a database. These questions all relate to a school. I have a school table and a survey table. Some of the survey...

Hi All Hypothetical example: I have a long questionnaire (50 questions plus) for which the answers need to be captured into a table. The questionnaire deals with questions about restaurants (for which I already have a table in my database) e.g. meals offered, quality of food etc. The tricky...

Hi All I have a table containing schools. I have another table that contains sets of enrollment data which have been collected for these schools. These sets of enrollment may be collected on several different dates, but all the records with the same date, belongs to the same "collection set"...

Hi All I need to design a query that contains about a dozen fields for stationery items along with another dozen fields (checkboxes) to show whether these items were delivered (Yes, I know, not great db design). I ran out of space with the the query criteria window, any tips on a more elegant...

Hello Gurus! I have searched this forum but none of the related posts have given me any insight into my problem. I have subform (datasheet) with a column for gender indicating "Male" or "Female" I wish to place the totals for each gender (and total overall) on the main form footer. I have...

Hi All A [hopefully] quick question: Attached is my many to many relationship setup. I would like to prevent the possibility of entering the same person more than once for the same training event. I am assuming that I do this by setting an index setting for a field the junction table? Any...

Hi All I have a main and subform related to a training event with trainees. So the main form includes information relating to training date, location, training content etc while the subform contains a list of attendees. The attendees come from a table that contains a list of potential...

Hi All I would like to populate form fields with records from a table/query so that they are bound to the recordsource and the record to be displayed can be selected from a combobox. I am hoping that in this way, any changes made are propagated to the original table. I have created a combobox...

Hi All I have several comboboxes in my database from which users select values. However, in most cases, I do want to give them the option to add an item that does not appear while simultaneously updating the underlying table which stores those dropdown values. I have made use of the builtin...

Hi All I am stumped! I have a combobox which looks up and stores the primary key for a school. I have another unbound field into which I have inserted the following SQL code (extracted from a query which works perfectly). SELECT a01_Corridor.CorridorID FROM a01_Corridor INNER JOIN a05_Schools...

Hi All I have imported a list from Excel into my database. The primary key is long integer (Indexed no duplicates). After the (successful) import, the next primary key assigned to a new record has jumped from (for example) 15 to 30024455. Why would this be? I have compacted and repaired the...

Hi all I am in the process of learning to make use of a junction table for many-to-many relationships and I think I'm starting to grasp it. My question is, once the tables and relationships have been set up, does the junction table get updated as you enter data into the fields on the two tables...

Hi All I am back to using Access after many years and I am shocked at how much I have forgotten! I have searched both this forum and the web but none of the proposed solutions that I have seen have fixed my problem so I'm going to rely on the gurus here! I have created tables to capture...