Recent content by dickohead

Hi all, Is there a way to get a pivot table to show me records that meet ANY not ALL of my filters? My problem: I have built a summary table in Excel which looks at a data-set and performs various counts and sums against the data-set to give me a view by year, month and selected customer for a...

Hi all, I'm having trouble with something that should be very simple, so I'm obviously doing something wrong. I have the following Access database structure. # Location *LocationName - PK # LocationBookQuantity *LocationName - PK *BookID - PK *Quantity # Books *BookID -...

Hi all, I'm currently using master/subdocuments Word in to save me having to update many letters when things change (phone numbers, required fields etc). I'm also using input boxes to prompt the users for data that the letter then prefills for them (also into subdocuments). The problem I'm...

Hi all, I currently have quite a few documents that incorporate child documents into their make up. I also have quite a few documents that use input boxes to prompt users for data input. (InputBox(Prompt:="Your name is?"). I now have a document that is a combination of the two but have run...

Hi guys, I have a database that stores Exams against a Student and each Exam has Areas: Student --> Exams --> ExamAreas --> Areas I have created a form for Student, which has a subform for Exams, and the Exams subform has a subform for ExamAreas. I can add data to all fields...

Hi guys, Thanks for the wonderful replies! I am now using an update query, but I am getting this error: "Too few parameters. Expected 1." I've searched for quite a while to find a cause or fix, and apparently it's due to incorrectly named fields (typos?). Is there a way I can test each part...

Hi guys, I am trying to do this: If the ResultLetter field is No, then append the Memo field and change ResultLetter to Yes, otherwise go to the next record in the table. But the code below is doing this: If the ResultLetter field is No, then append the Memo field and don't worry about...

I'd create a query with CompanyName, Sector1, Sector2 and Sector3, then in the criteria field for CompanyName I'd put: [Sector1]=IT [Sector2]=IT [Sector3]=IT To return all companies where any of the sectors are IT, correct? Then to make that more user friendly, I'd change the "IT" bit to...

Create a query that selects all three dates for some ID column. So you would get a list like: 1 01/01/01 02/02/02 03/03/03 2 02/02/02 01/01/01 03/03/03 Then you'd want to filter it to select item 2 yes? I'd select the coumns ID, CreationDate, ShippingDate and CloseDate Then in the 'criteria'...

Sorry to resurrect a dead thread, however... I have the following set of data: Exam1 Person1 Fail English 01/01/01 Exam2 Person1 Pass Maths 02/01/01 Exam3 Person1 Pass English 03/01/01 Exam4 Person2 Fail Maths 01/02/01 Exam5...

Cheers mate, I figured it would be more complicated than "insert object x and it will read sub records". Not to worry, I'll do it another way! Thanks again mate.

I have read a thread that is trying to do a very similar thing to me, but there was no final answer. I have contact details for people, these people have subrecords in an assosciated table. How do I generate a letter for each person and then include all assosciated sub records in their letter...

Hi all, I am trying to pull some data from an Access database based on whether a field value is 1 or 0 (yes or no, ticked or unticked). I have built the query and the correct data is selected. I then built a word document to generate a mail merge from this. Pretty simple stuff so far. What I...

Thanks for the reply mate. I've since discovered that Array's may not be my answer and I should perhaps be using a collection? I understand why the loop was giving me that error, I was using a "for each next" loop on an array that didn't support it... hence the error! So now... How do I...

Morning all, I am trying to create a function that will populate one table with items of another, based on the tables ID number. For example: There are 4 classes, each one has 10 subjects, there are only 30 subjects in total though, so some of these subjects are shared. I'm trying to create...