Hecate

I see what you mean - I've never noticed that before. Try adding allowedits = false to the on enter event of the control - this works for me. It stops data already in place being overwritten. Welcome to the wonderful world of access programming

In design view right click the required text box and select properties, then choose the event tab and browse down to after update, click the build button to the right and select code. This will present you with a blank procedure which looks like this Private Sub ControlName_AfterUpdate() End Sub Enter allowedits=false between the start and end lines so the finished code looks like this Private Sub ControlName_AfterUpdate() AllowEdits = False End Sub Note because this is attached to the after update event it won't work retrospectively only controls updated after you've applied the code will be affected I hope this makes sense - you can pm me if I can help any more

This is from an Access 2003 perspective but I assume it will work in 2010. If you want this to apply to all cells on the form you can just set 'allow edits' to No under the data tab in form properties. If you want it just to apply to certain cells you could use the 'after update' event in the cell properties and the code allowedits = false. I quite often set allow edit to no for a form by default and provide a control to turn edits on as required so that no-one can accidentally change an entry

Look for something like program files\microsoft sql server\MSSQL.??\MSSQL\Data. The database file should be SIMS.mdf and there will also be the log file SIMS.ldf. However if you just back up these files and try to restore from them later you may have trouble logging back into SIMS as the user password data is saved elsewhere (I think in the master database but I'm not absolutely sure) If you back up and restore using dbattach the user credentials are saved and restored as well. If you can't find focus system it would appear you don't have administrator permissions and if you don't have the sa password for the sql database you are storing up all sorts of problems. It is possible to reset the sa password but you really need to know what you are doing. If you can't ask your Local authority for support can you find someone at a nearby school who has SIMS experience?

As CAM says you can use dbattach (found in - on my system- drive\Program Files\Microsoft SQL Server\MSSQL10.SIMS2008\MSSQL\binn) can be used to make a local back up of the data which saves in the drive\Program Files\Microsoft SQL Server\MSSQL10.SIMS2008\MSSQL\backup. Obviously your path might differ slightly and you will need the SQL sa password. I think you really need to talk to whoever does your SIMS support as your MIS data is critical and by your own admission you know very little about SIMS

The actual database you are looking for is the SIMS.mdf file and is found somewhere like drive\Program Files\Microsoft SQL Server\MSSQL10.SIMS2008\MSSQL\DATA. However unless you are really sure what you are doing get Capita to help you move it. It's very easy to miss something and lose connectivity to your data

We have our own home built database but I've looked at alternatives from time to time, I couldn't get to grips with spiceworks - I just couldn't get it to work the way I wanted, I quite liked liberum but not enough to change what we've got. If money was no object I'd go for the netsupport helpdesk or possibly Richmond

If it's any help here's ours. Our main requirement is that staff need to be covered by their own insurance outside school the rest is pretty straightforward.laptop agreement.doc

I remember the cards but have long forgotten the Fortran IV that went with them

It's difficult to respond without more detail but I would do this sort of thing with a form and subform. The customer's details go on the main form with the order details on the subform linked by a common field such as customerID

Can someone tell me where the 200hrs per year comes from for FTE. I haven't been able to find a figure in any of the literature.

Like Jax I went to school back in the days of inkwells and nib pens and before the calculator was even dream in someone's eye. I did an engineering degree which included a computing course - mainframe and punch cards and then forgot all about computers for several years. In those pre sex discrimination law days, jobs for women in engineering were hard to come by so I tried various jobs including science teaching which didn't work out and then got married and started to raise a family. At home with a small son I started to get bored so my husband bought me a ZX81 and I was hooked. I started off largely self taught but realised if I was going to get a foot in the employment door I needed something on paper so I signed up at the local adult education college for an 'open college' IT course; with this under my belt I landed a P/T job in the Education IT department at a teacher training college. This was just as Windows 3.1 came out and I've grown with the systems ever since. (from Beebs to W7). When I moved to my current job I was the only technician in a school with a small IT department and my only experience of network management was an RM NetLM (pre CC) demonstration network. Fortunately the local university started a course aimed at new network admins which I was able to do whilst working and this remains the only formal network training I have. As our network and support staff increased I have taken on a more management oriented role and have been sent on courses to support this. I doubt anyone can follow this route now. I got in when educational IT was in it's infancy and learnt as I went along like everyone else at the time. Anyone starting now probably needs some sort of qualification although from a recruiters point of view we tend to look for people who've done the practical route starting as apprentices or similar with basic qualifications and then worked their way up.

Wouldn't I like to be in your shoes - I can't even get broadband where I live.

Not normally we feel normal rules of privacy should apply to pupils as well as others. But if necessary (eg to retrieve work from an absent student) teachers can request it. We have a user group which has RO access to all pupil folders and the teacher is added to this group and removed once they have finished.

+1 for stone. We used them last year when our original recyclers started charging and were impressed. I have a mail folder full of groups offereing to recycle for free including one called computer-recycle who are offering vouchers but I have never used them

I am running a query which pulls the start date and end date from unbound controls on a form. I have a command button which opens the date input form but I need it to wait until I have entered the dates before running the query. I use the same date input form for different queries so I can't use the after update property of the date field. The best I have come up with so far is a continue button on the date form but this means a different button for each query. I would like to put something in the query's SQL which waits until the date form end date is not null but I haven't managed to come up with anything so far. Any suggestions would be welcome. I am using Access 2003 if that makes a difference

Very frustrated that I didn't get the link - when will it be available for general viewing

I've registered but not received the email link

For me the 'old' print timetables report gives this error but the new Timetable reports run fine

Did this announcement actually happen and it so can someone point me at the information - I haven't been able to find any detail only vague comments in line with the posts made before BETT. I've contacted our channel partner but am still waiting for a reply

Done it. But I agree with RabbieBurns any greening is a by product of cost saving not a consideration in itself

senior admin person - I do some SIMS support and did the census once when the head's PA left and no-one else had a clue. I made it clear I thought it was an Admin task and passed it back as soon as I could

Try this. In Tools->academic management->set academic year, check you are set to use the current academic year. I don't know how it works but when I had a similar problem with year groups missing from a report the reason was my workstation set up was set to the wrong academic year

I had this problem and fixed it by giving the Options admin person full control of the Options folder within SIMS

I'm a bit surprised to see no references to SIF on this thread. Unless I've completely misunderstood how it works different sub applications could be written by any developer as long as they use the SIF agent defined for the system. The end user could then decide which apps they wanted to use for what - my trips app would pull the pupil data it needed from the core but have it's own set of trip related fields and reports and so on