Recent content by alunkane

Thanks.... I didn't know about "Group By" - sounds like what I'm looking for, so I'll give it a go now... many thanks

I have impotred a table of my MP3 music collection from Excel in to Access. The Fields it contains are: "Artist" - "Album" - "Track Name" - "Track No." - & "Duration" I would like an option to be able to list only the Artist & Albums - However, when I try I end up with a list of duplicate...

Thanks... tried searching Thanks... I did do a search first - but wasn't too sure exactly what to search for ? I thought it would be as simple as using Hyperlinks & clicking on them -but perhaps not...

I am trying to write a little database to view my MP3 collection (as you do when youre bored...) I have a field that shows the full path to my MP3's e.g "D:\My MP3's\iTunes Music\Bob Dylan\Desire\03 Mozambique.mp3" I want to be able to click on the file link to launch the file in my MP3...

many thanks....

I'm trying to do it in form view.

I'm still stuck with this one... Any ideas how to use conditional formatting (or someting similar to it) to change font & background color of one form field, depending on the value of another field ? e.g. If the value in a field called 'gender' is "Male" the name displayed in the name field...

I'm sure this is a common enough problem, but again it has me stumped... How can I use conditional formatting to change font color or background color of one field, depending on the value of another field ? e.g. if the value in a field called gender is "Male" the name displayed in the name...

Thanks Meltdown: Many thanks I had a look at the code for this and will have a go at adapting it... (I'm pretty new at this carry on) Just to be sure where to start ? Do I just go to properties / On click / Event Procedure and type in the code starting with "Private Sub...." ? Private Sub...

I'm sure there is a simple answer for this, but it has me baffled... I have designed a form with a number of (yes/no) tick-boxes. I want it so that when one particular tick box is either checked or cleared, other boxes on the form are automatically checked or cleared. Any help would be greatly...

Chris, Many thanks... This is maybe more difficult than I first thought, but I'll give it a go...

There is probably a very simple answer to this, but it has me pulling my hair out. I have a table with Yes/No values and have turned this into a form with Tick Boxes. I want to use the results from the tick boxes to determine a monetary values to help work out costs for rented equipment e.g...