Spl1t

Your pupil will need to use OleDB to create a connection to the access database first - so it might be worth googling that first. Once the application is connected to the DB then it should be easy as delete * from Table1 where blah or you potentially you'll need to delete active row.

Thanks Steven that is exactly what I was trying to explain when a picture would have sufficed The command utility exporter is a fantastic and easy to use tool and it can be used by doing the following: - Open up Command (CMD via Run) - Type the following: cd C:\Program Files (x86)\SIMS\SIMS.net\CommandReporter.exe and then hit enter (This is a standard install location but can change depending on whether it's 32bit application or user has installed in different location) - You will then see something like: - Type the following: /USER: /PASSWORD: /REPORT: /OUTPUT: - You will have to create the location folder on where you want to output the file and you can use the following output file type: .xml, txt, rtf, csv It's worth noting that there are no spaces between e.g. /USER: and you need not include the < > around the username, password etc Best of luck!

You can use the SIMS_ID and this can be retrieved by creating a new report. The user would need access rights to Third Party Reporting and then they would need to produce a report on staff and add the various columns that are needed. The SIMS_ID is found 'Third Party Reporting' > {Person_ID} and you can save this report to run as and when you get new members of staff.

I also use PureVPN, it's a nice simple application to use.

Has anyone figured out a way of mass importing vendor / customers into the Spiceworks system? I was hoping there would be a .csv file to import; the ticket import tool works fine.

Good shout there, try replacing the BIOS chip and also may try resetting the BIOS version via USB stick. I have ASUS ROG Gene IV - few years old mind you but the motherboard is fantastic; I personally would recommend ASUS ROG and it's also easy to update the BIOS firmware without much hassle.

Coconut eclair is win!

I've been playing it since the release and I really like it. A lot of the automatic rifles need balancing to put them in line with the damage that the sniper rifles do. I would have liked to have seen an additional map but I am very much enjoying the desert map with the sandstorms! The beta has been very enjoyable so far but I hope they improve the queue system because when the servers were down a lot of the popular servers had massive waiting times and whilst queuing you're not able to refresh the server browser window without leaving the queue. Personally speaking I feel you should be able to queue for a server and check the browser just in case you find a server / game type / slots free etc that suits your requirements.

Go to control panel and select system Choose Advanced System Settings in the left hand column of choices on the next dialog On the [Advanced] tab, click the {Settings...} button in the Performance section Clear the checkbox next to the "Animate controls and elements inside windows" entry right at the top of the list Click [OK] and close out all of the dialog and the Control Panel Also does the excel spreadsheet have any macro's that are loading on 'Sheet1'?

Or you could try SELECT Field1, Field2 + ' ' + Field3 AS [New Field Name for both columns], Field4 FROM table Essentially I am just joining the two fields together and separating them with an empty string with a space. If you don't want the space then it will just be Field2+Field3 as [New Field name]

Yeah some of her emotes are pretty adorable but I mainly play her to troll players

Recommend you guys give Mae a go, she is pretty much good at countering the likes of reaper / genji and pretty much any ultimate by encasing herself in the block of ice. Personally love playing her on the temple of Hanamura where she can block access to the attackers or what i like to do most is to let a one or two in and block them in so the defending team can quickly take them out.

The matching system is pretty unfair it has to be said. I am rank 80+ on the game and often or not I am seeing level 10's in the game. I appreciate they need to learn the game etc but having low people in the team usually results in a fail. It's not really fair on both sides of the fence and I feel their matching algorithm needs to be tailored to fit the level range. There is a competitive mode where you do ten games to determine your base level and once you have completed you will then be matched against users within that range. The comp mode is a much better game style but it requires the right classes being selected for the maps and players working together. One more thing in reference to the competitive mode if a person leaves the game then you should leave also (you'll see a red prompt saying you can leave in x amount of time) because that player won't be replaced at the start of the next round.

Very sad to hear about the death of Mrs Cox She seemed like a really decent person trying to help the people in her constituency. I must say the people who tackled the killer; good job well done!

I think it's a reasonable idea to put to the table but I do think they should have given school's notice so they could email out the parents notifying them of the changes. On a side note I think the reason why it's been such a problem is because if a school only has one account say 'Catering' the parents still need to allocate it to that account; surely it should just be set to default to the only active 'purse'. When schools have multiple accounts then I generally think it's a good move to pay into a account and then just move the funds into the different accounts when it's required.