Recent content by degsy70

Cheers, problem solved, much appreciated<br> <br> Degsy

Thanks I've got that to work but do you know how I can get it to look at column A 1 to 10 and then go on to column B 1 to 10 etc<br> <br> Much obliged

I know this but i don't know what the algorithm would be, would I need to write some VB code?

Hi,<br> <br> Does anyone know how I can sum a range of cells in Excel that are coloured i.e. i want it to select a range and then say &quot;4 cells are green, 5 cells are red&quot; etc<br> <br> Any ideas greatly appreciated<br> <br> Des

you need the Office developer edition tools which has a wizard for making installation sets with royalty free distribution for Access. This is a seperate purchase from Office and runs almost the same price, but well worth it.<br> <br> With this you can let anyone use your database with a runtime...

Thanks Pal, I've got it working a treat!

I see what you are trying to do. What I need to know however is whether or not I can use this for a query instead of a table. The data in the form is the result of a query and it is that data that I need to turn into a csv file?

The thing is, we have developed an Intranet and one of the things it does is allow you to create customised lists. <br> On the intranet you upload a csv file and it puts the data into your list.<br> Basically I'm after the easiest way of getting the data from the access subform into a csv file...