LosOjos

Here you go, same project, this time in VB: https://dl.dropboxusercontent.com/u/4779199/Custom%20Window%20Style%20VB.zip EDIT: C# to be precise (C# is very different to C, despite the name; it's more like Java)

Oops... just noticed you're coding in Visual Basic. Give me 5 minutes to convert the code

Take a look at this example project: https://dl.dropboxusercontent.com/u/4779199/Custom%20Window%20Example.zip Essentially, we have a borderless form (you can simply change the form in your current project to match this) with a label at the top called 'TitleBar'. the icon on mine is huge, but you can shrink yours down to the stand 16x16 for 'authenticity'. You then simply monitor mouse actions on the label, moving the whole form if the mouse is held down on it. This is very basic and of course you can take it much further, but it should get you started on the idea.

You can do it, but not using the default window styles in VS. The 'standard' way (as in uses Windows SDK classes) would to override the form's 'CreateParms' function, which will allow you to specify any of the Windows Styles constants. You can use "CS_NO_CLOSE" (it's hex is 0x20) to disable the close button that way, note though I say disable, not remove! Let me know if you want example code for this method. The harder but ultimately more customisable way is to create your own window style on a borderless form. It's a bit of work, but ultimately gives you most freedom over design. You'll want to set the 'FormBorderStyle' property to none, then draw on you title bar as you see fit. You''l lose default actions like resizing (though it looks like you're making a fixed size form anyway) and moving, so you'll have to code that functionality in yourself. This is the method I'd choose and can give you some sample code for window movement using a DIY title bar made from a label.

I am, haven't been on in ages mind! Where's the thread and what's it called? (Assuming links still don't work properly to SupportNet!)

There's no way around the 40 character limit unfortunately and worse still, there's a 25 character limit on the "column heading" property (the text that is actually displayed on a marksheet). The way we have worked with this is to agree on sets of acronyms and abbreviations where possible, e.g. "Working at Grade" becomes "WaG", "Estimated Grade Based on Current Performance" becomes "EGCuP". There is also a section for comments when you are creating templates (just below the template name). Anything you enter there will be shown at the top of any related marksheet, so you can use that for more in depth explanation where necessary. In my experience, consistency is the most important thing when naming and positioning aspects.

It seems as though you already have a system in place and wish to develop this further, as opposed to this being an idea you wish to get off the ground - am I correct? If so, it's going to be fairly difficult for anyone here to advise you without seeing the system you currently use. It sounds like your developer has produced a series of workbooks to collate and report on the data you need, and without seeing how that works, advising you how to progress will be difficult. Where about are you based?

Accessing a particular website or any website? If it's a particular site, which one? First thoughts are a bad/corrupted browser extension/plugin

It certainly sounds like a bug to me, that's not how MAX is supposed to work (at least I don't think so!) however it's working fine on my machine (also 7.156) so it may not be as simple as 'MAX' being broken... One thing you could try to resolve the issue in the meantime is to add 'VALUE' formula columns for each aspect, then run your 'MAX' on those 'VALUE' columns - this should take all previous results out of the equation completely so your 'MAX' formula works as expected again.

OK, let me make sure I understand; - you have two columns using two different aspects in a template - the first column is based on a date range, displaying the best result over that date range - the second column is linked to a resultset, so shows just the result for that resultset - when you perform a 'MAX' formula against the two columns, it is choosing the best non-zero grade from the second column, rather than just looking at the resultset slected? If so, I'm unable to recreate your problem my end - which version of SIMS are you using? The only thing that comes to mind is you mention grades with no value - have you tried assigning '0' to them and does that solve the problem? As far as I'm concerned, what you describe absolutely should not be happening; the 'MAX' formula should not even be aware of any results outside of those you have filtered via data/resultset. Sorry that's not much help, but it may be that you've discovered a bug rather than there being anything wrong with the way you're doing it!

I can't see the benefit to doing this - you can change the effective date to a future date to see how things will stand in the new term. Is there a specific reason they feel the need to do this? The first thing that comes in to my head is census - I imagine this causing all sorts of odd queries on your census with regards to under-age pupils being admitted, long periods of "no attendance possible" and quite likely a major headache for whoever has to deal with your Post-16 Learning Aims... Personally, there's no way I'd set my SIMS term dates to anything but the proper ones. Far too much potential for fall out later on.

You can't play Minecraft without Java...

I misunderstood - thought you were trying to make your own blocks to go in to Minecraft. So, if I understand correctly, you actually want to export Minecraft structures as images? Minecraft Structure Planner might be able to help, I don't think the exported layers are textured but I assume they include some sort of key: Minecraft Structure Planner

If it's for Minecraft as the title suggests, try BDCraft's Cubik: BDcraft Cubik | BDcraft

Yeah we do, and you're right it doesn't count BTECs but the school of thought from our SLT was that it would be better to compare like with like... for students who we don't have KS4 info on, we assume an APS of 40/C. Not ideal, but it gets the job done!

@ICTLady - no problem at all, I'll post the link up here. Forgot to mention the KS4 APS calculation; as we use ALPS, I create another lookup table from that so that we are comparing like with like. However, due to the nature of my myriad of lookups, you can calculate your APS however you like - just drop the figures in to the APS sheet when they're ready

@jimbojames136 - if I get time later today I'll put a copy on my Dropbox with a bit of annotation for you (with dummy data of course!)

I use it and added a couple of sheets to help. I created a report in SIMS that pulls out all the results for a given Year/Resultset/Date Range, with aspect name, student ID and grade. Next, I compiled a list of all the aspects we use and found their subject QANs, putting them in to another sheet on the ready reckoner. Finally, another new sheet on the ready reckoner has been set up so I can copy/paste my SIMS report in to it, then it looks up the aspect name to find a QAN, which is in turn looked up against the VA sheet that contains subject codes. This can then be copy/pasted in to the "Input Data" sheet and job done! Took some time to get the right workflow, but now I can update it in around 10 minutes. Very useful!

@nephilim - I still don't understand how this macro would be helpful in any way, sections and page breaks are totally different things... it'd be like writing a macro to replace all the tables in the document with pictures of kittens - not what the author intended (although that sounds like an hilarious prank...) However, I still tried! Failed, but tried lol. The code below is my attempt; I can store copies of the sections, replace them with page breaks, but then trying to iterate back trhough the document replacing the new page breaks with the original sections is where I fall down... maybe you can work that bit out from here? [color="#0000FF"]Sub[/color] SectionsToPageBreaks() [color="#0000FF"]Dim [/color]i [color="#0000FF"]As Integer[/color] [color="#0000FF"]Dim [/color]savedSections() [color="#0000FF"]As Section[/color] [color="#0000FF"]ReDim[/color] savedSections(0 [color="#0000FF"]To[/color] 0) [color="#0000FF"]With [/color]ActiveDocument.Range [color="#0000FF"]For[/color] i = 1 [color="#0000FF"]To[/color] .Sections.Count [color="#0000FF"]If[/color] .Sections(i).PageSetup.SectionStart <> wdSectionNewColumn [color="#0000FF"]Then[/color] [color="#0000FF"]ReDim Preserve[/color] savedSections(0 To [color="#0000FF"]UBound[/color](savedSections) + 1) [color="#0000FF"]Set[/color] savedSections([color="#0000FF"]UBound[/color](savedSections)) = .Sections(i) [color="#0000FF"]End If[/color] [color="#0000FF"]Next [/color]i [color="#0000FF"]End With[/color] [color="#0000FF"]With [/color]ActiveDocument.ActiveWindow.Selection [color="#008000"]' replace section breaks[/color] .StartOf wdStory, wdMove .Find.Text = "^b" .Find.Replacement.Text = "^m" .Find.Forward = [color="#0000FF"]True[/color] .Find.Execute Replace:=wdReplaceAll [color="#008000"] ' perform any actions you wish to with the newly formatted document here[/color] [color="#0000FF"]MsgBox [/color]"Replaced " & Str$([color="#0000FF"]UBound[/color](savedSections)) & " sections." [color="#008000"] ' iterate savedSections array, returning section breaks to original positions[/color] [color="#0000FF"]If UBound[/color](savedSections) > 1 [color="#0000FF"]Then[/color] .StartOf wdstroy, wdMove .Find.Replacement.Text = "" [color="#008000"]' skip first section, which is the start of the document[/color] [color="#0000FF"]For [/color]i = 2 [color="#0000FF"]To UBound[/color](savedSections) .Start = savedSections(i).Range.Start .Collapse wdCollapseStart .Find.Execute [color="#0000FF"]Select Case[/color] savedSections(i).PageSetup.SectionStart [color="#0000FF"]Case [/color]wdSectionContinuous .InsertBreak wdSectionBreakContinuous [color="#0000FF"]Case [/color]wdSectionEvenPage .InsertBreak wdSectionBreakEvenPage [color="#0000FF"]Case [/color]wdSectionNewPage .InsertBreak wdSectionBreakNextPage [color="#0000FF"]Case [/color]wdSectionOddPage .InsertBreak wdSectionBreakOddPage [color="#0000FF"]End Select[/color] [color="#0000FF"]Next [/color]i [color="#0000FF"]End If End With End Sub[/color]

Hmmm before I look at it, I'm curious as to why? Section breaks are often used for pages that require totally different formatting, such as a landscape page in the middle of a portrait document, or for creating indexes. Both those things would break if the sections were removed, making the print out wrong in the process... I suppose what I'm really asking is, what is the end goal? There may be a better solution.

I wrote a small program a while back that pulls the photos out of SIMS and saves them as either name, UPN, ID or admission number. It can also add the name in a small box below the photo if you want (as part of the final image) and resize on the fly... If anyone is interested, I'll knock together some documentation for it (thought it's very simple, just a couple of arguments on the command line - I could put a simple GUI together if people would prefer)

It's a habit I've picked up over the years of scripting with Office as I used to get random issues occurring using "Active..." identifiers, particularly with worksheets where the user would click on a different sheet and the macro would go haywire on it... I always learn the hard way lol! So now I make a point of storing a reference to the doc/sheet I'm working with to avoid any issues

You can get a reference to the presentation from Open, like so: $PRES = $MSPPT.presentations.open("C:\test.pptx", 2, $True, $False) Then, replace any instance of $MSPPT.ActivePresentation with $PRES The post I made earlier shows what I mean, I did things a bit differently to you but it'll explain better than I can what I'm on about: Earlier Post EDIT: re-reading my posts, I apologise if I'm coming across as a bit of a d**k, my people skills are somewhat lacking...

...I posted how to do that waaay back just remove the $MSPPT.Visible line entirely and tag another $False on the end of the Open line, it works, honest! EDIT: the RemoveComObject printing 1 is actually a good sign, there's a KB article I was reading earlier that stated it decrements references each time it runs, so should output 0 when all objects are released. The workaround (nasty though it was) was to put it in a loop like so: while([system.Runtime.InteropServices.Marshal]::ReleaseComObject($MSPPT) -gt 0){} EDIT: here's the KB - http://support.microsoft.com/kb/317109

Have you tried with the ReleaseComObject method I posted/linked to above? Could be that I'm using an old version of PowerShell (I think) that it won't work for me