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
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
...
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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.