mrwITch

Take a look at the code inside Red>>>>

Since this is a single User problem -- seems a bit over the top to build some sort of web app (unless of course it is useful to all the other teaching staff once you've done it) From what you've described - teacher already has 'group' data charted -- presumably in the Excel file Why not just add in a bit of VBA code so that teacher can select one, or more, students worth of data and have that drawn as an alternative chart see charts.xlsm in attached zip file as an example of what I think you want charts.zip Sheet #1 shows Chart of the Group Sheet #2 shows chart for selected students Sheet #3 contains Data for charts + Selection mechanism (hopefully obvious)

Since you wanted to manipulate/access some cols from some rows Do you really need the charting functionality or do you just need access to data that happens to be in an Excel spreadsheet There are several other PHP charting libraries that you could try Similarly there are other ways of getting data out of Excel - if that is all you need to do Write up what you want to achieve - I'm sure people will come up with a few options

I think $dataNum = $i-1; $seriesNum = $j-1; should be $dataNum = $i; $seriesNum = $j; Remember Excel number Rows and Cols from 1 to n (Not 0 to n-1) - you have already started your loops at 2 Try something like for ($i = 2; $i <= 26; $i++) { $col_1 = $dataLines[$i, 1]; $col_5 = $dataLines[$i, 5]; // do something with this data before completing the loop ......... // do something with this data before completing the loop }

Yeah - that should also do it

Just re-thought this -- instr is NOT the best way of handling this if mid(existing, 1, 1) = "#" and mid(strReverse(existing), 1, 1) <> "," then outputstring = existing & " : " & outputstring The above is a better test for what you wanted ?? what was the unexpected side effect ??

the not inStr(StrReverse(existing), ",") = 1 won't work Use the following if instr(existing, "#") = 1 and inStr(1, StrReverse(existing), ",") = 0 then outputstring = existing & " : " & outputstring should do it This now tests the 1st character (after reversing the string) The = 0 should indicate that a "," wasn't found So your complete test if instr(existing, "#") = 1 and inStr(1, StrReverse(existing), ",") = 0 then outputstring = existing & " : " & outputstring should be read as follows If the 1st char of existing is a "#" and the last char of existing is NOT a "," then modify outputstring

Sorry didn't read original posting properly for your 'not =' use <>

Haven't programmed in C++ for years cplusplus.com - The C++ Resources Network Visual C++ Tutorials, Library, and More on MSDN About C, C++ and C# And of course - you can find something for most programming languages from places like Wrox Technology Books, Free Code Downloads, Ebooks, Blogs, Articles, P2P Forums - Wrox

root for all things Java Developer Resources for Java Technology Java Tutorials - follow 'Trails Covering the Basics' first The Java™ Tutorials Programmers Guide JDK 7 Documentation Index API - Javadocs Java Platform SE 7 b66 JavaRanch - A Friendly Place for Java Greenhorns Java knowledge quiz at the 'Roundup' JavaRanch - a friendly place for Java greenhorns - Roundup Eclipse - IDE for Java (+ much more) Eclipse.org home Apache - open source stuff Welcome! - The Apache Software Foundation

??Not sure what you mean by paths changing?? code loads an array of images then cycles through them - order never changes

I have written a bit of AS3 code (compiled to swf) It reads in an xml file containing a list of Image files that should be displayed cyclically with a fade in/out Code works in Flashdeveloper Code works in local test html in Firefox on home pc Code works in local test html in IE on home pc Have got everything loaded up to the webserver swfDemo Page | Upton Junior School - Working together for our children's future - looks fine in Firefox But in IE All images load OK, then the first few images fail to fade in/out so we get image(1) load fade out image(2) load fade out ...... image(1) blank image(2) blank image(3) .... image(n) fade out fade in image(n+1) fade out fade in image(n+2) fade out fade in ..... image(1) blank image(2) ..... Any ideas what can be causing this ??

OOPs Then I guess a reasonable starting point is here Adobe - Dreamweaver Developer Center and maybe places like Adobe CS5 - Everything about Adobe Creative Suite 5

Try the CSS section from here W3Schools Online Web Tutorials

What your describing is the UI/presentation of an Audit trail So when any of your forms update(CRUD) the DB your code should write an entry to an Audit trail table and updates to this table should trigger an event which refreshes the Audit trail form (can't remember if Access can fire events on Table updates - you'll have to look it up)

Try some of these OpenGL - The Industry Standard for High Performance Graphics OpenGL API Code & Tutorial Listings Getting started - OpenGL.org

It's probably hard-coded in the php code (footer.inc ??) Sorry that probably should read footer.php (been playing around in Drupal recently) Check to ensure that your Template index.php doesn't set this value Then check ..../includes/footer.php which probably does set it

Python Python Programming Language -- Official Website and documentation off the Home page Python Documentation Index

The Information Commissioner’s Office CCTV camera, the Data Protection Act - Organisations - ICO Schools - CCTV Information Obviuously the suppliers these people recommend probably won't be cheap

Eclipse (and it's many plugins) is a favorite of many developers / designers in the Java world Plugins Eclipse Plugin Central :: Eclipse plugins resource center and marketplace for Eclipse and Plugin Ecosystem You can do almost everything you need directly within Eclipse Setup / mange your Subversion source-code repository Configure Maven and / or Apache Ant to continuously build your project Invoke your JMeter/Junit Test scripts & log bug reports Control your App/web servers Configure your DB Data sources Plugins are available for most things DB, LDAP, UML/BPMN, craft XSDs / XSLTs / WebServices etc etc

Another thought Be careful about usine Autonumber option as a primary key in your tables -- It is a very easy way to ensure that you have a Unique primary key BUT it has no meaning in terms of the data in that table & doesn't add any value when forming table relationships For you Audit trail/log table consider using a Timestamp as the primary key (You might have to write a bit of code - if you want a timestamp more granular than seconds)

I prefer NOT to use the Wizards (as they don't always produce quite what you want), so do all of my work in the appropriate Design View mode Design your tables (& their relationships) in one database Design your UI(Forms) (and Reports) in another database & make good use of Buttons (to manage CRUD) backed up by VBcode to ensure that ALL User input is validated before it is written to the DB If your Forms are always populated via a VBCode DAO then you can build the code such that it presents default data (along with any validations) - you can test a large % of your UI without storing/retrieving data from the Data DB You might also want to have 2 Data DBs --- One for all of your Dev/Test work then a Clean one for production (ie make a Data structure ONLY copy of the Test DB when you get close to finishing --- BUT don't delete the Dev/Test Db as you'll want to carry on testing developing / bug fixing) If this is a multi-User application with most of your info being updateable then you must ensure that Form load/re-load regularly retrieve latest info from the Db Make good use of Queries (in the Data Db) to provide data to the Form/VBCode (and also Reports) Think in terms of properties/operations for your Objects and apply a naming convention for them across all the MS Access components taht you end up using

'along with the actual database development, I also have to wrote a report on the whole project from start to end, that I can do fine, I do project management as part of my job and enjoy the challenge. Therefore, within the report, things such as what you mentioned, project design, feasibility study, project scope etc etc etc is all covered in that. I know what i want from the database development, it's simply knowing if access can provide and to get access to do this.' If you have to produce a report on the whole project -- start it now, use it as a way of documenting your requirements / high level design It will help you structure the project & possibly even enable you to pruioritise the various aspects I think you'll find that you'll need to spend a lot of time on your UI - the navigation through it and the many ways data might need to be presented/maintained For your Audit trail build that as a separate module - everything gets written to the Audit logs through a single channel (perhaps an Event listener) - Users then ONLY have sequential read access to anything in the Audit logs (?? Is this a multi-User system --- If so should everyone see everyone elses Audit logs ??? so you perhaps think in terms of Users with differing access rights to various parts of the system --- Maybe some people can cretae/modify reports Whereas other Users might only be able to trigger the report generation (this will afeect what menu options you might want to expose) If you have access to Visio (or similar) Drawing tool then you can draw up a 'state transition' diagram showing what actions (menu/link clicks) take a User from one screen to another - Also good documentation for your project report.

'I have a scenario where I have to create a database using MS Access' Is this part of the problem definition - you are mandated to use MS Access?? Assuming yes - what is the rest of the problem statement What are you having to build, how big/small a problem is it Can you see a way to build it in smaller (but useful to the end-user) parts How are you going to test it Do you have a rough idea of the sets of data that you need to store/query/manipulate Do you know the relationships between these data sets Do you have any idea of the number of rows of each data type Do you have to provide Data entry forms Might want to create two dbs - one containing Data structures/data the other containing forms/VBcode (can always separate these out later on tho') Do you have to provide Reports (fixed or user configurable) Just some thoughts - rough it out on paper before you comitt Be careful about making fields mandatory Be careful about table relationships and cascade deletes (not always what you want to do)

Happy birthday Tazz - from Witch actually but I am at mrwITch's computer!