Search results

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, 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 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...

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...

Hello all, I am trying to create a macro that sits in my Normal.dot file that enables me to reset/reload certain documents I am working on. In these documents I have some prompt boxes being loaded up from an AutoOpen() sub: Sub AutoOpen() 'Asks the user if they wish to prompted for input or...

Hey Guys, I have a combo box with entries that it pulls from a table. Ie: tblMonths Month ________ Season January ________ Summer March _________ Autumn November ______ Spring December ______ Summer Now in my form, when someone chooses January from my drop down list (the drop down list takes...

Hey Guys, I have a form that contains a subform. Let's use the example of a video store; We have a record for each person who hires videos containing personal details, and a subform containing all the videos they have hired and whether or not they've been returned. That all works great! How...

Hey guys, Having some trouble getting a VERY SIMPLE if statement to work. I have a checkbox, if it's checked when my form loads, i want a rectangle to be visible. If it's not checked, do nithing. If I check it when using the form, make the rectangle visible. The latter part I can do with...

Hey Guys, Having some trouble doing a couple of things using both Data Definition Language and a Right() Query. What I am trying to do is convert this field: August 17, 2006 3:56 PM into this 15:56:00 Using this: Right([Travel Date/Time To],InStr([Travel Date/Time To],",")-1) Now because the...

Hey Folks, I have a form with five combo boxes on it and one button, when each combo box has an option set and I hit the button, it runs a query which looks up the values of the form items and gives me my chosen information. However, if these fields are: FirstName, Surname, State, Town and...

Hey Folks, I have a form that has two things on it: A button to open a query A list box with names in it How do I get the query so that it will select all records where the name field matches the chosen name from the list box?

Hey guys, I've got an aset register that keeps track of many different types of data, one such data type is staff member, represented by their initials. Occasionally (especially lately) staff members will leave, new ones wll take over and need to have the asset register corrected for this...

Good Afternoon, I have a query that selects information based on a few criteria, but the three main criteria are: LPN (licence plate number) Month Year It prompts the user for each of these, which is great! But the information that is selected each time, only varies by the LPN field. For...

Good Afternoon, I am currently trying to create a query that will allow me to do the following: Prompt the user with a pop up box, asking: Please enter start date Please enter end date It will then select everything from my table between those two dates (this works), and then it will ignore...