Search results

Hi " maximize your main form and resize the subform within to get all of the records to show." Did this and it doesn't make any difference. ""the format property got changed to single form" Form 2 = subform, set to continuous form and appears as continuous when view as its own form Form1 =...

Hi thanks that worked. However there's a problem; form 2 is a continuous form (a list of 25 questions and 25 answer boxes). I dragged this into form one and now form 2 isn't dispaying as continuous but rather only one question and one answer field is appearing - any idea how I can get the sub...

Hi I've created 2 form. Form 1 from a table Form 2 from a query. I want to make form 2 a sub form in form 1 - Can anyone tell me how to do this? I asked Access halp and it told me to click the build button and follow the wizard but a wizard doesn't pop up rather I get a box with 3 options...

thanks for all your help :)

I Created 2 Queries 1. Contact Query (using the Contact table only), with ContactID, First name, second name, etc 2. Question Query (using fields from the Contact table [ContactID], Question Table [Question Number, Question], Answer table [Answer] Followed your instructions with the Contact...

Hi MT I think i've included the correct fields to create the query from which to create the form. My relationships are all one to many. I've attached screen dumps to show my structure. Here are the table fields I have used for the query: I have used my 3 tables Contact/Question/Answer: 1...

Hi This is where if gotten to.... I'm creating a database which will capture the answers to a questionaire with 25 questions. I have 3 tables - Contact - Questions - Answers 1. Contacts Table ContactID First Name Last Name etc etc 2. Questions Table QuestionID Question Number (ie 1.1...

Hi, thanks MT, nearly there I folowed you until this bit Shouldn't I create a primary key on the Answers table? I'm not sure what FK means.

Hi I would like to create an Access 2002 database to capture the answers from a questionaire with 25 questions. I'm not very familiar with access and don't know any VB:( I would be grateful for some help on the structure. I've created 3 tables - Contacts - Questions - Answers 1. Contacts...

thanks for your help Pat

Hi I'm using the label wizard to create mailing labels in Access 2002. I am extracting this information from a 'Contacts' table. All the fields are coming out correctly on the label except for the 'Region' field. This field is the only one that appears on the 'Contacts' table with look-up...