Search results

Hi. Thanks for you speedy response. The reason I have four tables is that I only want to compare equipment items that apply to category A with other equipment items that apply to category A. I am basically going to filter the options the user can pick from at a later stage using a query on...

I have quite a complex database so I will just explain the relevant tables/forms. I have an equipment table which collects information in the following fields: Equipment ID (primary key), Equipment Description (text field), Equipment Sub Sub Category (lookup from another table). A piece of...

I'm fairly new to access. I only did what its said above and didnt personalise anything. I'm using access 2003 if that helps.

Just want to say thanks for providing a detailed description on how to do this. I have spent hours looking for a solution & finally this one works. Cheers :)

I cant print a screen shot because of client confidentiality, sorry. Table 1: has a primary key, say "p1". Within table 1, there is a foreign key "p2" and "p3", depending on which way the user wants to proceed. Table 2A: has a primary key say "p2". Table 2B1: has a primary key say "p3"...

I am using Access 2003 and am relatively new to access. I have 4 main tables in my database, tables 1, 2A, 2B1 & 2B2. The user can enter information via tables "1", "2A" or "1", "2B1", "2B2" depending on how they respond to a question in table 1. I have set up 15 forms as the tables...

Hi! Thanks very much for your speedy responses. Got to leave work shortly to visit the dentist, but I'll be sure to post tomorrow to let you know how I get on. Cheers :)

In each of the sub forms are a series of questions and the response given dictates the progression onto other forms. For example. at form 9, the user may exit the data entry process, and at other forms, the user may skip certain sub forms. Does this make any more sense? I was initally...

I have 20 subforms all with their own primary key eg (01-000001, 02-0000001, 03-000001) and so on, where the 01 relates to the subform number and within that subform the 000001 part increments by one each time. The main form is MTF-000001, again with the 000001 part incrementing by one. Is...

Hi. I'm relatively new to access and thought I might try here for some help. I have created a form with 21 questions, all of which have a drop down menu where the user picks either "Yes" "No" or "N/A". I have one final question at the end of the form and I think I need a sort of IF...