Search results

Thank you for your reply. We want to produce a spreadsheet of users in the first column, with the different courses in the following columns. E.g., this would be the desired output (see attachment). CLIENTID comes from Tbl_Client.clientID Client Name from Tbl_Client.Name The dates are stored...

Hi there, How do you return the most recent date of multiple columns. I have a table (tbl_courses) that has a list of training courses. We want to know when a client completed the course most recently. The problem is, for one course there has been up to 4/5 different variations of...

Done!! Thank you sooo much all of you. J :)

Woohoo, that works :) Thank you for your help :) I've got about 6 different combos to make so this will help as a guide. Is there a way to sort the combo list alphabetically easily or would I need to set up a separate numeric column to sort them by? Thanks, this has been driving me nuts :)

Hi, there isn't a control source? Please see the attached. I looked at some of the other combo boxes we use as report filters and they don't have anything in the control source either. J

Hi VbaInet, There's not much, its just SELECT DISTINCT Tbl_FamilyRegularPayments.PaymentRun FROM Tbl_FamilyRegularPayments; Thanks, J

Hi JHB, the database is massive and I couldn't upload. I could put the SQL for the query and some of the sample data from the combobox I'm trying to create, if that'd help at all? Cheers, J

I'm not sure how I change that? All I did to set up a combo box was click on new report, select the table/field I want the combo box to show and followed the above link to get distinct records only. How would I fix the column issue you mentioned please?

Hi there, I've used this guide http://www.techonthenet.com/access/comboboxes/unique_values2010.php to only show unique values in a combo box. I can't get it to work, it just shows a load of blank values. If I run the expression builder part from the background, it works but it doesn't work...

Hey! Just to let you know this works beautifully. A bit slow on my Access but works. THANK YOU GINA :) x

HI Gina! Thank you soooo much for this. I'm on leave at the moment, I'll give this a try when I get back to work next week. I've donated my entire set of Potter books and also a few of my Wilbur Smith novels to the local library, as promised :) :) Will drop you a reply next week. :)

Thanks Gina! And don't say sorry, you're doing me a massive favour :) :)

Hi! Yes, you are right, I should put headers. Can I used the field names for each column, as above?

Hi, I don't have header rows. :)

Hi Gina! Having discussed with my colleagues, no sorts are necessary so we don't need to worry about that. My column headings will be in A1, B1 etc and data will start in A2, B2 etc. in all 3 worksheets (hope that makes sense!) My 3 queries are called: 1 - "Qry_NewCustomers13" 2...

Ha! I didn't mean you need to work quickly, just my company expect me to work magic on things that take time. Last week I was asked to convert 300+ Access reports into SQL, with them expecting it done in 2 days. Considering they're paid so much, they aren't half dumb! Ok, - template is called...

HI Gina, Its a set of queries I've set up that bring through a load of info on customers, sales and products. The board requested they be in separate worksheets for ease of reading. My VBA skills are pretty basic. I can do things like command Access when a button is pressed on a form, to...

Thanks guys, this works now :)

Hi guys, Work have asked for a lot of information to be run from Access and exported into Excel. The info they require will need to be exported into 4 Excel worksheets in the same workbook. Is it possible to tell Access that when they click on the report button on the form, it will...

Hi, I modified the code you sent me to this: "Expr1: DateAdd("y",18,[ChildsDateOfBirth]) Between Date() And DateAdd("m",6,[ChildsDateOfBirth])" but the records it highlights as true are those born in 2014? Not sure what causes this? The format for the DOB is dd/mm/yyyy Thanks, J EDIT...