Jamo

If then you did the printer key by serial number then add a single location field to that. It would make making queries and reports so much easier in the long run.

I can understand what you mean there but a one to many relationship is as my example in database terms. Adding the one to many in the relationships box helps preserve things like referential integrity etc The compatability tables only needs to hold consumable IDs and printer IDs so just 2 data fields. The printer table could hold the location table as well as you cant have one physical printer in more than one location.

You do but ConsumableID is listed like this: PRINTER1 ¦¦ Q1234D, C1234D, Q2345D etc etc ¦¦ If it was one to many it should be listed like: PRINTER ID CARTRIDGE ID PRINTER1 ¦¦ Q1234D PRINTER1 ¦¦ C1234D PRINTER1 ¦¦ Q2345D PRINTER1 ¦¦ etc PRINTER2 ¦¦ etc Therefore one printer ID can have MANY cartridge ID's.

This could work, but change the = for LIKE on the last line.

Will be difficult to formulate a query for that. Your table design is difficult because you don't have a one to many relationship with the compatables to the printers, they are listed in one field. It would be easier if printers had a separate table and the compatablilty to the other table was produced by linking the primary key of the printer table to the primary key of the cartridge table. In my database I had Printers, Cartridges then a table called PrintersCarts (Compatability would be a much better name now I see ) basically that table just has the primary key of a printer then its cartridges, its much easier then to filter the results you require as you can pull a query from the PrintersCarts table to produce what you want. SELECT PrinterID, CartridgeID FROM PrintersCarts WHERE PrinterID = ComboBox1.Text

Just for reference Downloads - VirtualBox The manual on that page starting at 90 shows the command lines for VBoxManage, basically an EXE for controlling what you can normally do in the virtualbox GUI. Pretty useful for making the VM transparent to the end user as it opens like a program.

I have created an access 2003 database which handles all the things you are talking about its a bit messy at the moment but it works. I have it set up as follows Tables: Printer CartridgeType Both of these tables contain "profiles" of the printers or cartridges, that is just a printer identified by Serial No as primary key and cartridges identified by cartridge long number ie Q5949X for a 49X HP toner. CartridgeStock This table contains individual stock items and has a one to many relationship with the cartridgetype table. Ie One cartridgetype can have many of its type in stock. Once used the cartridges get put in the UsedCartridges table where all the information is collated together so there is an element of redundancy if the cartridge profile is ever deleted. Now that sounds like a load of confusing waffle here so if anyone wants I can post a blank copy up for people to look at lol

Are you using MS Virtual PC? Have you thought of using VirtualBox as you can use the VBoxManage program to do that (From outside the VM not sure about inside). Ahem I should read the post title!!! lol

I have to say that compared to other VLE's I found Moodle easy to use and a lot more intuative than certain other VLE's. Also its designed to be a VLE not a glorified web page storage area we are currently having to work around the shortcomings of our VLE here (Fronter) to make it useful, which to me sounds like a completely backwards way of working!!

We are doing the 2007 upgrade this hols! Would rather use OpenOffice tbh though.

Find Open Source Alternatives to commercial software | Open Source Alternative - osalt.com Interesting site, shows you open source alternatives to commercial products. Might be worth a look!

Does anyone know any free equivalents to the Macromedia suite?

Have you tried getting in touch with ASUS they well probably forward you to a reseller for their supplies.

mm i doubt that would sort out an overheating issue, does it happen during any other stressful activity on the laptop? Good idea would be to run a benchmarking util to see if it can be stressed to fall over. SiSoftSandra is a good example has a great burn-in and monitoring util on it. There is a lite version as well for single use.

Sometimes it can just be a quality of signal problem, had to change one to an N class router once with adapter becuase the signal quality, although strong, was very intermittent. Channel would be the first thing I would try, after that I think the suggestions here are all there is.

when the graphics go nuts like that, its either an overheating card or a failing card! Try getting rid of all dust, reseat the heatsinks if they are easy to get to etc if not then its a great excuse for a new laptop!! Although the battlefield heroes beta woudl be a better excuse

if the symantec/norton removal tool can remove what you have installed I would try that, no password needed just admin access. Search for it on symantec.com

Ive never really understood why people thought Vista was bad, I used it since just after release day and I never had a problem with it. Its different from XP but not in a bad way. W7 is a jump from Vista in its speed for sure and the task bar is great once you get used to it. Can't see myself switching back really, which is strange because I was a classic view person before.

Or you can get a scanner which does it for not too much money, I know we used to sell them in PC world. MMM not sure how long it would take though thats an awful lot of slides!! Epson certainly make them, ill have a look when i get a second

I think the taskbar overhaul is great, once you get used to the functionality of it it has made using a lot of programs at once so much easier, same for the start menu, I hardly ever search through the list anymore, its usually just straight into the start search.

booooooooooo!! damn poo ray

If yours is like ours I dont think a normal admin can, have you spoken to your LEA if they are looking after the hosting?

Thats usually cus its found an error, not sure why it does go backwards though, maybe cus its found more stuff to fix!! Also why when in recovery mode does it say Checkdisk is fixing errors 3 times????

mmm that wont be good if we have to open the blu ray in a separate window!!!! I can't stand doing that!! W7 NEEDS blu ray support! (ALthough i think HDDVD should have won, blu ray just copied its ideas down the line)

[ame=http://en.wikipedia.org/wiki/Optimus_Maximus_keyboard]Optimus Maximus keyboard - Wikipedia, the free encyclopedia[/ame] Just get one of those!!! Does everything you need plus MORE!!!! Whats that you say? Over $1000 dollars too much? Damn.....