Search results for query: *

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

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

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

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

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

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