Pashers

Check the relationships on the database. This could course funny things to happen. Does the image thing work for you? And are the databases all the same?

Check your security, also try IE 7 with the no add ons option. Also check these sites out. XCCC: When a User Opens Attachments in Outlook Web Access the User Is Prompted for Credentials login prompt when trying to open wave file in OWA They might help you out

I'm not sure if this helps. But I've just had a pupil come down with a table issue. They had two tables in word 2007, saved for a 2003 document. If you view it in 2003 it looks terrible, the two tables are on top of each other. Whereas, it looks ok in 2007. I fixed this by right clicking the table and going to the table's properties. Changing the wrapping to None. This might fix some other issues!

I'm going to have to say the obvious I'm afraid... I think there's a programming error in the code. So this is quite a difficult problem without much more info.

We have similar problems with office 2007, it doesn't come up too often. We set the default save as to 2003 (for those who don't have the office 2007 at home). All the computers use the office 2007 within the school. However, there's times when the pupil doesn't take it home and it still comes up saying the file is corrupted. Open office is able to get most of the work, but not in a 'tidy' fashion. Why on earth does Microsoft have to keep changing file formats? Why can't they just keep it the same. Lol that's why I personally go to open source at home e.g. Ubuntu. They don't change everything year.

I've created a web monitoring program which sends the request to the server, then looks at the received content and bans the page depending on the 'black/white list' you have set up. It's at a very basic stage at the moment. Basic as in it'll work, but still some 'glitches'. Not tested it on a server (however I can't see why it wouldn't work), but ran on local machines at start up. So for example if you ban the word youtube, they manage to find a proxy to get onto. Then using the proxy try to get onto youtube it'll ban the site because of the html in the site. The black/white words work on a point value and in different categories. So for example you would have a porn, game, messenger etc groups. If you have a word in the game group like 'miniclip' to a value of 25. The page would have to mention miniclip 4 times to ban the site (counts up to 100). If the value reaches 100 for the white list, then it'll allow the page to show. But if the word comes up to 75, and a word in the messenger section comes up to 50. This page will still show as it's in two different categories. Would anyone be interested in this type of product?! Trailing/test/improving?! The browser settings would be set to the localhost, which then 'talks' to your server. Hope this makes sense, What's your thought on this type of product? Thanks

Hi Bobharding, Only one person can write to an excel sheet at one time. Multiple users can read the same excel sheet however. You could always convert the Excel sheet into a database (sighs, I know you don't want to), more so a server database e.g. mssql, mysql etc. Access can give a nice 'easy' front end if someone sets it up (i.e a form that pops up at the beginning to access premade queries, forms etc). Excel is also very good for queries. I think Access is as good as your going to get, as what you are asking is the actions of a database. Other than that, I don't think there's much else you can do.

You don't have to go through each cell to do this. In the Conditional formatting section, create a new rule. When you create it using a formula e.g. =$A$1<0. Delete the dollar signs ($) as the dollar signs would enforce it to work only on that one cell. Then when you've created that rule for one cell. You can 'drag' (that little + shape in bottom right of the cell... I don't know the name lol) to the other cells. And then choose fill formatting only. So instead of =$A$1<0 it'll be =A1<0. If you want, upload it and I'll fix it up for you!

Hi, I've made a quick sub routine for you to have quick look at: Sub SelectLastUsedMoveToRight() Dim r As Range Dim last As String Set r = Selection last = r.Cells(Selection.Rows.Count).Address Range(last).End(xlUp).Select ActiveCell.Offset(0, 1).Select End Sub If you select the A coloumn, it'll find the last used cell, then move to the right by one. last = r.Cells(Selection.Rows.Count).Address This gets the last cell that's selected Range(last).End(xlUp).Select Gets the last used cell from the selection ActiveCell.Offset(0, 1).Select Moves the selection to the right.

Have you looked to check that there are no other other office installations? Or any traces of older office packages?! Is it just word 2007 that crashes? Any updates/patches you need?

Could you get the pupils to design it on a piece of paper? Turn it into a competition or something. Saves you designing it ;-) Or do what I usually do, just start with a basic layout adding the information. Then start thinking of a colour scheme you want to use. ColorSchemer Gallery | Website-ready color schemes for ColorSchemer With the colour scheme start designing the menu, keep it simple and don't over 'crowd' the page. Maybe for the logo have some one kicking a football with the text on the left, right or infront of the image. It's the worst part starting off, I never know how to design the site LOL.

Have a search for css templates. Here's a pretty good website just for reference on what you can do with css. I know it's not exactly what your looking for but I still like the site css Zen Garden: The Beauty in CSS Design

Could you just do ... Range("A1:F10").Select For Each Cell In Selection ...

Hi there, You might want to look at 'Conditional Formatting'. With this it'll allow you to format the cells depending on the value. A quick google ('excel 2003 conditional formatting') brought up Conditional Formatting. Hope this helps

Creating the site itself, you may wish to embed the body content within a div. For example .... .... .... Then in the head section you can style it so the width is 795 pixels: div.mainContent { width: 795px; } 795 pixels will allow room also for the scroll bar (if you need one). Hope this helps and gives you some more ideas!

You can try downloading Mozilla Firefox, and/or Opera. These will allow you to view the page in different sizes. Also with Firefox you can add an extension which allows you to view it as if it was Internet Explorer as well.

The code would be embedded within the HTML and to add/remove the css you'll still need to modify the code as much as adding removing the image!? Off course, if you don't want the image to be displayed, the browser would still have to upload the image wheter it's hidden or not.

Why would you want to use css to style the images visability? ASP will display the image or not include the image at all. You don't need to style the image's visability if you're using ASP. For example: ---------------- <% if wordVariable = "Archived" then response.write "trafficLight.jpeg" else response.write wordVariable end if %> ---------------- Would display the image if the word is Archived. Whereas, if the word is not 'Archived' then it will not have the image at all but have the word which is stored in wordVariable. So you wouldn't need to style the image's visability. Off course, you can still style it the image if you wish to and in the style sheet you may remove the image border.

CSS is not controlling which image is being shown, that's the job for ASP. CSS is only styling how the image looks. Not being petty, but shouldn't I get the credit as well?! cadjs pratically said what I said!?

Hi DanIT, Where are you getting the results from? You using HTML, ASP, PHP, etc.?! If it's going to be static I'd just hard code it in. If not then in asp you can do something like <% if wordVariable = "Archived" then response.write "trafficLight.jpeg" else response.write wordVariable end if %> As far as I know, you can't do that type of thing in CSS (I may be wrong however). But if you could, then you have the issue of some browsers may not support it. I know you could target the text if it's in a 'hidden' textbox using Javascript, then change the image depending on the word. However, I'd prefer the previous option and use ASP, PHP or something similar!

Hi there, I'd use two variables for the drop down lists which you want the range for. For example say you have DropLowestRange, DropHighestRange. In the select parameters section of the gridview have the variables similar to lowestVal and HighestVal. E.g. The SQL query which you can use would then be something to the following: select * from table where Total<@highestVal and Total>@lowestVal Note if you want them to have the choice of an exact match, include another variable e.g. DropDownExact. Then use the following sql select * from table where (Total<@highestVal and Total>@lowestVal) or Total = @DropDownExact Hope it helps

I think the datagrid view can do a .requery?

We do take away A LOT of privileges it's not like we allow them to browse the C drive, access the task manager, control panel, and so forth. The pupils are restricted via the Network's GP. Not even allowed to change passwords. It's not that unsecure lol

If they did want to break the computers intentionally they can still easily make themselves local administrators with the free software out there these days. But considering the amound of fuss you lot are giving I'll deffo talk to the manager lol. One issue we have also had is the office 2007 package. If the pupils are not local administrators, then it keeps wanting to install it each time they run word! Any fixes/ideas on fixing this? (I know this is off topic)

Thanks that worked brilliantly! I remember reading something about Restricted Groups somewhere but got scared lol. As for why I'm adding them as local administrators, I'm not 100% sure myself (I'm just the technician). However, I believe it makes life easy for us for installations, updates etc. Also for myself I've made a program in C++ to monitor the websites they go onto. Banning any sites it thinks/calculates should be banned (bit like surf control). Using a point value white list/black list set of words etc. Thanks again!!