Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by colval

  1. colval

    Local Disk Server 2003 Out Of Disk Space

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

    MS query adding more tables

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

    MS query adding more tables

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

    Page Break does not work

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

    MS query adding more tables

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

    MS query adding more tables

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

    MS query adding more tables

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

    Page Break does not work

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

    Page Break does not work

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

    Page Break does not work

    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 {...
  11. colval

    Page Break does not work

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

    MS query adding more tables

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

    Page Break does not work

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

    Page Break does not work

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

    MS query adding more tables

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

Part and Inventory Search

Back
Top