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!

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

Search results for query: *

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

    Copy Last Record Button

    HI Checked all the Tag's and they are all purely ? only. Went to last record, double clicked then addded new and nothing appears in the new record. Any ideas?? Thanks as always
  17. colval

    Copy Last Record Button

    Yes I am sure I am I have the form and table and the records are ID Name Department 1 Colin IT 2 Val Chippy I then select select new on the Records selector and the ID (autonumber) is highlighted first on the new record, I double click this nothing happens, I move to the...
  18. colval

    Copy Last Record Button

    HI TheAceMan1 I have just tried to test this in a simple table and form. Table1 (ID (autonumber), Name, Department) Formtable1 The form comes up with the first record on open, if I click new on the Record buttons it goes to the autonumber and when I go into Name nothing appears. In all the...
  19. colval

    Copy Last Record Button

    Yes that only works on individual fields doesnt it, for example you are in Filed 1 and you press ctrl ' and that brings in the last record for that field. I want to be able to copy in all entries for the last record in one go? Unless I am misunderstanding you. Thanks
  20. colval

    Copy Last Record Button

    Does anyone know if it is possible to create a button attached to an event procedure that will Copy the last record that was displayed on form. We use a form for data entry and sometimes the records are the same. We would like to able to copy the last record and then make the odd change. I...

Part and Inventory Search

Back
Top