Hecate

I've recently moved to Access 2010 and have hit a really annoying problem: when working in form design every now and then it crashes for no apparent reason and won't let me back into design view or the coding window. The forms will still work, I just can't edit them. If I go back to an earlier version I can make the changes, so it's nothing to do with what I am trying to do and I have also discovered that if I make a copy of the offending DB I can open it and carry on from where I left off even though the original still won't let me. Any ideas - I can work with it as long as I keep making copies but it is frustrating

If you run sql management studio look in the activity manager to see if any users show as active.

A few years back a consultant who was running a course I was on said he would always recommend to his clients anyone applying for a job coming from education. His main reason was that they have usually come a background of having to do everything from changing toner to managing server migrations and helping users format a word document. The only way I can imagine the corporate market being more demanding is in time constraints - in school computer downtime in a classroom is an inconvenience but it's not costing money

We think progress is fast but just think back a little further. When my Grandmother (died 1994) was born hardly anyone had a telephone, air travel was still a dream and motor cars were rare. Just consider how much changed in her lifetime

I'm running a system where I want users to enter various information including a date into a form and have the table updated with this information I've got most of it working beautifully but I've hit a snag with the date formatting This works DoCmd.RunSQL "UPDATE tbldevice SET tbldevice.DisposedDate = [forms]![frmdispdetail]![DisposedDate], .... I wanted to make the code neater and reusable so I tried Dim DispDate as date DispDate = [forms]![frmdispdetail]![DisposedDate] DoCmd.RunSQL "UPDATE tbldevice SET tbldevice.DisposedDate = '# " & Format(DispDate, "mm/dd/yyyy") & " #' ........ This gives me a 'type conversion' error. I have tried with and without US formatting, various combinations of #, double, single quotes and parenthesis but I can't get it to recognise DispDate as a date - any suggestions? I can work round it so it isn't a major issue but I really would like to know where I am going wrong

we've been trialling it and the staff who've used it love it. We've also been impressed with the support

Check the SIMS ini file which is in the windows folder on the workstation. As others have already said it looks as if there is an error in your simssetupdirectory line. Mine reads SIMSSetupsDirectory=\\[sIMSServerName]\[simsShareName]\sims\setups. This won't stop SIMS running but it will stop it updating automatically

Thanks Rabbie for trying to help - after sleeping on it and looking again I realised that in trying to simplify the problem for posting I had over simplified it and picked a bad example. I'm now modifying the design to get what I want another way but I still think it should be possible to set up an intersection for a many to many relationship and populate it without having to do it one record at a time. (I don't mean enter data into the link table directly just set up the queries which make the links and write to the table.)Anyway thanks again you at least helped me get my thoughts in order

I have all the assets in one table so my fields are EquipmentID; EquipmentName: EquipmentType; Make: Model; etc etc. ......Just realised I think you are right each asset can only be in one room so it's one to many not many to many. My head's spinning too now so I'll look at it again tomorrow

I'm not an expert on assessment manager but it may be possible to set up a user defined group for the pupils and then set up the marksheets so he/she can only edit the ones for this group. Check the SIMS permissions spreadsheet - available from supportnet and make sure that he/she only belongs to the group(s) with the permissions you want to allow but it isn't possible (unless someone knows different) to, say, allow editing of the basic details of a subset of pupils

The table structure is roughly as you outline above but the equipmentinrooms doesn't populate automatically. The relationship between tblrooms and tblequipment is many to many so I assume a link table is needed but somewhere you need to tell it that roomNo 1 contains EquipmentID 1, equipmentid 3 etc and roomNo2 has equipmentID 2, equipmentID 3 and so on this is the bit I am trying to automate. The problem has arisen because I want to add the rooms table to an asset database that didn't have it originally.

I have an Access database with tables for (among other things) equipment and rooms, I would like to link these two so I can see bring up a room and see what equipment is in it. The basic set up is OK - I've created the link table with a compound primary key all of which works fine. What I am looking for is a way of populating the link table without having to do it all record by record. I'm sure it must be possible to take a list of rooms from the rooms table and add the code for the item from the equipment table in one operation eg all IT rooms have a whiteboard so I want to take rooms IT* and link them to the whiteboard code but having tried all sorts of variations of update and append queries I can't get it to work. Any suggestions? The best I've come up with so far is using a make table query to get the subset of rooms add a field to this for the equipment code, update the equipment code and then append these records back to the link table but this isn't really any quicker than updating each record manually

62 here- but I bet there's older out there

Yes - I must have been 7 or 8 at the time and used to listen with my parents

Whilst I agree that £1 budget doesn't = £1 technician time there is still a cost element to be considered. It's false accounting not to do so. If your staff were doing nothing if they weren't building PCs then they could be employed for fewer hours otherwise they are taking time away from other tasks which maybe someone else has to be employed to do (or is it just a case of Parkinson's law where the time is made to fit the jobs).