Recent content by colval

Hi We have a local disk on our windows 2003 server (Y:\ Drive) that as run out od disk space and it is not letting me into it so I can free space up on it. I just get it Y:\is not accessible not enough space on the disk drive. Does anyone know of a way to access the drive at all, We tried...

Hi Ok I will try the simple approach, it did not work without the Where clauses either. Thanks

Hi This is my full code trying bot Skip and combo's suggestion. But I am still gettting syntax errors, the more i try and change it the more confused it gets, any ideas , thanks SELECT TableSamples.SampleID , VListAreas.ItemValue , VListFloors.ItemValue , TableSites.SiteClientID ...

Ok I willt ry in the Forum you suggest. Thanks for all your help.

Hi Skip Tried your script but I get a message saying 'could not add table '((((' I ahve tried chancing the script but cannot seem to figure it out. Any ideas Thanks as always

Hi Combo I have tried the following code but it gives me an error message saying Syntax error in query expression 'Tablesamples.samplesareaid}' I ahve checked it over and over but cant find the problem, any ideas, thanks SELECT TableSamples.SampleID, VListAreas.ItemValue...

Hi Skip Do you mean to add the (+) at the end of the sql line so it looks like TableSamples.SampleConditionID = ListCondition.ID(+) If so I tried this and it says Extra ) in query expression Any ideas Thanks

Ok think I understand a little now. I have taken the code it creates for the main file and put it into MS expression web, then viewed it in IE and firefox. I then printed to PDF and then it shows as two pages which is correct as it puts the page break where it should. The process we use to...

Ok but when we print the report out (we usually import intoAdobe PDF and organise but, the Material Risk does not print on seperate pages at all. What does the report.css do then? thanks

Hi just found the code for the report.css H3 { text-decoration: underline; page-break-after: ; line-height: 2; } TABLE.assessment TD { border-top-style: solid; border-top-width: 1; border-top-color: darkgray; padding-top: 5; font-size: 80%; } TABLE.samplerecord TD {...

Ok losing me with scirence sorry lol What do I need to do so it creates a page break for me. Do you want to see the report.css and where do i find it. Thanks

Hi I have added in a table called Condition and this is when it happens. SQl looks like this TableSamples.SampleRoom, TableSamples.SampleSiteID FROM ListCondition ListCondition, TableSamples TableSamples, TableSites TableSites, VListAreas VListAreas, VListFloors VListFloors WHERE...

Hi Thanks for the replies candrid2, i tried the quotes and got the same situation. Feherke, not sure what gecko, presto etc.... are, but we generally use HTML and view in IE. It is using report.css i beleive but I have never used this so not sure how it is using it. (any clues or files you...

Hi we have a database that creates several records. We have a distribute button that creates HTML reports and one of these is meant to create a report that seperates each record in the report with a page break. The code below is as follows, (sorry about the lon code but trying to explain...

Hi I am doing an MSquery linking into an access databse to link into an excel spradsheet. An example databse as 37 records in all, all connceted to mulitple tables. when I add a table called Vlistcomponants the link then just shows 5 records. I am assuming this is because only 5 matching...