Search results

How would I achieve this.

Thank you Bob! I've been trying a subform for ages but could not get it to work. I used the wizard but to no avail. Could you tell me the steps you went through to get this working please. Also, I want to ammend the qryFindCharacters to do the following: IF the character gender matches the...

Thanks that's great but I would need to see the field headings in the box below. How did you do this? and is the data in this box updateable?

Please help re above.

Hi I have a query which takes criteria from the frmActivity2. What I would like to do is return the results of this query on the same form underneath the combo boxes from which the criteria is selected. I have tried everything but cannot get this to work. Am I being really stupid about...

The two combo boxes are unbound. I have used unbound combos on previous databases and it has worked fine but this time round its been so problematic. Also, if use text boxes it works but not when I use a combo box. Weird.

Hi I have a problem with a query not finding a character from the character table based on the 'Production' and 'character' selected from the respective combo boxes on the form Activity2. When I manually type this criteria in to the qryFindCharacter the query works. But it returns no...

Ok will try this.

Hi The databse I am trying to develop is based on a theatre showing two productions (wizard of oz & charlie and the chocolate factory). I am having problems with a form(Activity 2). The last three combo boxes on the form select a production, Production job and character name. What I also...

Thank you for the info much appreciated. Append query works fine after table removed.

Hi I am having problems adding details from StudentForm to student table. When I click on the add student button it throws back an error Microsoft Access cant append all the records in the append query. I have attached the error as a pdf and the database for info. Your kind help would be...

Hi I am having a problem with my append query on my student form. When I add in the details on the form and run the append query it throws back a dialogue box saying Enter parameter value... I have attached my database and would be gratefull for anny assistance. Many Thanks Darth

Hi Now attached as 2003 mdb Darth

Hi Please see attached documents. What I am trying to do is book students to a particular role for a play. In tblRoles I have two roles which can be booked role id 1 = Winged Monkeys and role id 2 = Dorothy. On the form(activity 2) when I assign a role id to a student and save it I want it...

Hi I have attached a Scenario that I am looking at devising a prototype database for. What I am interested in is how many tables would be needed and the relationships based on the scenario attached. Also, what type of keys/compound keys etc Scenario Vicky Wilkinson is the performing...

Thanks, that worked. Much appreciated. Darth Sidious

what you have requested throws back the following error: you tried to execute a querie that does not include the specified expression 'CD Number' as part of an aggregate function.

Hi I have a a table 'Orders' with fields (Order Number, Order Date, CD Number, Card Number). I would like to produce a query in access 2010 that would allow me to count how many times the CD Number 'Diab190617' has been purchased. I would like to store the results of this count and...

Hi Brain How can I force a page break to give me a new page after eachstudent group of results? Darth

I have tried this but it puts a break after each record rather than each students results. For instance if you refer to the attachment, I put a page break at the end of the detail section and it put a page break after each instance of an exercise. There are approx 12 exercise results per...