Jump to content


  • Content Count

  • Joined

  • Last visited

Everything posted by ROUBOS

  1. I just placed the order. Corsair 8GB (2x4GB), PC3-12800 (1600MHz) DDR3, Vengeance, 8-8-8-24, 1.5V, Dual Channel Kit (x2 to max 16GB) Hard Drives - Solid State (SSD) - OCZ - VTR1-25SAT3-256G Graphics Cards - PCI Express - Sapphire - SA-7870-2GD5-XT thanks for your replies people. This should boost my system. Now I need a coolermaster midi-tower with some extra fans, and a new monitor. I need a monitor. LED 27" or bigger.
  2. Thanks for your replies. I will get the Sapphire Radeon HD7870 XT Edition with Boost, 2GB - $259.00 About RAM, should I get 2x8 or 4x4 for a total of 16GB??? EDIT: Looks like I need 4x4. Mobo does not support 8g modules. So how about these: http://www.scorptec.com.au/computer/39733-cmz16gx3m4a1600c9 or these X2 : http://www.scorptec.com.au/computer/39732-cmz8gx3m2a1600c8
  3. Hi, Created a simple database in MySQL with phpMyAdmin I have two tables: tblblockseries ---------------- blockseriesID BlockSeries and tblBockType -------------- blocktypeID blockseriesID <----- this should link the two tables. A foreign key right? blocktype blocksperpallet I want to populate the second table. The first table is populated with the series, and the second table I want to populate with types. One Series has many types. Now the form I've created, populates a combo-box with the BlockSeries from the first table, and I type in the other fields. With a correct relationship setup, shouldn't the second table be populated with the id from the first table? So that when I select a BlockSeries from the dropdown-box, that should insert the blockSeriesID as per the selection. And the other data to be keyed in. How do I get this to work? Tried everything in phpMyAdmin with the relationships. Everytime I create a relationship and I try to use the form, I get error. If I have no relationship between the two tables, the form works but I get a "0" in the BlockSeriesID field of the second table. any thoughts? doing google searches an reading and cannot figure it out

    MySQL phpMyAdmin Relationship

    Yes it is One to Many. One Block Series has Many Block Types. OK I dropped the tables and re-created them. When inserting content from within phpMyAdmin, it works fine now. So I must have got the relationship right. My html form for entering data is not working. Here is my form: <html> <body> <form action="insert-blocktype.php" method="post"> <table> <tr> <td>Block Series:</td> <td> <?php $link = mysql_connect("localhost", "dbuser", "password"); mysql_select_db("my_db", $link); $query="SELECT id,block_series FROM block_series_table"; $result = mysql_query ($query); echo "<select name=blockseries=''>Block Series</option>"; while($nt=mysql_fetch_array($result)){ echo "<option value=$nt[id]>$nt[block_series]</option>"; } echo "</select>"; ?> </td> </tr> <tr> <td>Block Type:</td> <td><input type="text" name="blocktype"></td> </tr> <tr> <td>Blocks Per Pallet:</td> <td><input type="text" name="blocksperpallet"></td> </tr> <tr> <td><input type="submit"></td> </tr> </form> </body> </html>and the insert php <?php $link = mysql_connect('localhost', 'dbuser', 'password'); if (!$link) { die('Could not connect: ' . mysql_error()); } mysql_select_db("my_db", $link); $insert="INSERT INTO block_type_table (series_id, block_type, blocks_per_pallet) VALUES ('$_POST[blockseries]','$_POST[blocktype]','$_POST[blocksperpallet]')"; if(mysql_query($insert,$link)){ echo "Record added"; }else{ die('Error: ' . mysql_error()); } mysql_close($link); header('Location: ' . $_SERVER['HTTP_REFERER']); ?> I don't mind so much about this. But I want to know if I'm doing it right. Now I need to create an order_table, and an order_form to populate the table. Now this form will have dropdown boxes for selecting block-series, which should populate the next dropdown box being the block-type, doing calculation and using the data to populate the table.
  5. Hi, I have a simple database in Access 2010. I created 3 tables as follows: tblClients: --------- ClientID LastName FirstName CompanyName Address City State ZIPPostal PhoneNumber MobileNumber Email tblProduct: ---------- ProductID ProductSeries ProductType ProductsPerPallet tblOrders: ---------- OrderID OrderDate ClientID LastName FirstName CompanyName DeliveryAddress DeliveryDate DeliveryStatus ProductID ProductSeries ProductType ProductAmount PalletsAmount Now the relationship is setup so that tblClients is linked one to many with tblOrders (ClientID), and the tblProduct linked one to many with tblOrders (ProductID) Now what I'm trying to do, is to have 3 entry forms. I created the entry forms for tblClient and tblProduct easy. OK Now the form for the orders is where I'm kinda lost. I want the person using this to select a client from a combo box, which will then populate from this selection the fields: LastName, FirstName, and Company Name. And then, from another combo box, to select the Product series (this combobox gets populated from tblProduct), which should populate another combobox with only the productTypes of the selected series. So picking a ProductSeries from one combobox, should filter the product types in the other combobox. (there are many types per series) Once all these details are selected the tblOrder table will be populated so I can then ran reports. Each product type has an amount per pallet. So depending on the amount of products ordered, the pallet amount will be calculated. Any help will be appreciated. Thanks in advance.

    Access 2010 simple Database. Please help.

    Well, sort of got something working. Getting this Run-time error 3075 now though. Fixing it, it works and then when you close Access 2010 and restart getting the error again :( here is the code: Private Sub cboClient_Change() Me.txtLastName.Value = Me.cboClient.Column(1) Me.txtFirstName.Value = Me.cboClient.Column(2) Me.txtCompanyName.Value = Me.cboClient.Column(3) End Sub Private Sub cmdAdd_Click() 'add data to table CurrentDb.Execute "INSERT INTO tblOrder(OrderDate,LastName,FirstName,CompanyName,DeliveryAddress,BlockSeries,BlockTy pe,BlockAmount,ExtraBlocks,PalletAmount,ExtraPallets,DeliveryDate,OrderStatus,Pa l letsReturned,DeliveryDateChanged)" & _ "VALUES(" & Me.txtOrderDate & ",'" & Me.txtLastName & "','" & Me.txtFirstName & "','" & Me.txtCompanyName & "','" & Me.txtDeliveryAddress & "','" & Me.cboBlockSeries & "','" & Me.cboBlockType & "','" & Me.txtBlockAmount & "','" & txtExtraBlocks & "','" & txtPalletAmount & "','" & txtExtraPallets & "','" & Me.txtDeliveryDate & "','" & Me.cboOrderStatus & "','" & Me.txtPalletsReturned & "','" & Me.chkDeliveryDareChanged & "')" 'refresh data in list on form 'frmOrderSub.Form.Requery End Sub Private Sub cmdClear_Click() 'clear all inputs Me.txtOrderDate = "" Me.cboClient = "" Me.txtLastName = "" Me.txtFirstName = "" Me.txtCompanyName = "" Me.txtDeliveryAddress = "" Me.cboBlockSeries = "" Me.cboBlockType = "" Me.txtBlockAmount = "" Me.txtExtraBlocks = "" Me.txtPalletAmount = "" Me.txtExtraPallets = "" Me.txtDeliveryDate = "" Me.cboOrderStatus = "" Me.txtPalletsReturned = "" Me.chkDeliveryDareChanged = "" 'focus on first form item Me.cboClient.SetFocus End Sub Private Sub cmdClose_Click() DoCmd.Close End Sub Private Sub Form_Load() Me.cboBlockSeries = Me.cboBlockSeries.ItemData(0) cboBlockSeries_AfterUpdate End Sub Private Sub cboBlockSeries_AfterUpdate() Me.cboBlockType.RowSource = "SELECT BlockType " & _ "FROM tblBlockType " & _ "WHERE SeriesID = " & Nz(Me.cboBlockSeries) Me.cboBlockType.Requery Me.cboBlockType = Me.cboBlockType.ItemData(0) End Sub it happens in: the Private Sub cmdAdd_Click()

    Access 2010 simple Database. Please help.

    I've made changes to the tables and the relationships. Now I have four tables. How do I create a form, that does not automatically update a table, but only saves once I hit a save button. Do the input fields have to be unbound? And with code on the save button to update the table? What's the code that does that? Like On_Click of the button, to grab all the input field data of the form, and store them into the fields of a table.. thanks

    Is it a PSU issue?

    well, we ordered a new DVDRW and new SATA cable to make sure. At the moment the systems works fine without the DVDRW connected. So if it is the cable, or the DVDRW, we will see. If the new one causes the same problems, then I will check the jumpers for SATA2 or 3. thanks everyone and HAPPY NEW YEAR to all :) I will post the results in a few days when the parts come in.

    Is it a PSU issue?

    OK, My friend mentioned that the system would boot when he opened the DVD RW tray on startup. So I unplugged the DVD drive and the system boots fine. Will keep it on for a while. Maybe run a few games and see how it goes. It's an LG dvd drive. EDIT: Well I ran the system for a while and all seems to work fine without the DVDRW on. So I guess I should order a replacement. Might get an ASUS DVDRW to go with the ASUS mobo. Could it really just be the DVDRW causing all this?
  10. ROUBOS

    Is it a PSU issue?

    Here is the blue screen message: A problem has been detected and windows has been shut down to prevent damage to your computer. I this is the first time you've seen this stop error screen, restart your computer. If this screen appears again, follow these steps: Check to be sure you have adequate disk space. If a driver is identified in the stop message, disable the river or check with the manufacturer for driver updates. Try changing video adapters. Check with your hardware vendor for any BIOS updates. Disable BIOS memory options such as caching or shadowing. If you need to use Safe Mode to remove or disable components, restart your compute, press F8 to select Advanced Startup Options, and then select Safe Mode. Technical information: *** STOP: 0x0000001E (series of codes with zeros) Collecting data for crash dump ... Initializing disk for crash dump ... Beginning dump of physical memory. Dumping physical memory to disk: 100 Physical memory dump complete. Contact your system admin or technical support group for further assistance.
  11. ROUBOS

    Is it a PSU issue?

    It is the Phenom II X4 965 at 3.4, and I do have the latest BIOS installed. v.2102 EDIT: Just got into BIOS to check the version, and once exited it hangs there. Power is on, but does not restart the system as per normal. Nothing on the screen the the tower has full power :(
  12. ROUBOS

    Is it a PSU issue?

    OK here are the specs I can see without powering up the system (can't at the moment as I took it home and need to hook it up on my monitor and components) CPU: AMD 4 core. (will check exactly once I power on the system) PSU: Tagan BZ series 700W HDD: OCZ Agility3 2.5" SSD and WD 1TB Sata RAM: Corsair XMS3 8GB Mobo: ASUS M4A79XTD EVO GPU: Sapphire Radeon HD5770 or I can use the Sapphire HD6570 (which has 4GB ram on it but no power cable needed. I think the 5770 looks more of a beast) all inside a CoolerMaster Haf full tower
  13. ROUBOS

    Is it a PSU issue?

    OK. I will check BIOS versions and see if the update fixes things. Can I disable USB3 support on the motherboard? I will give you the full specs too. So the slow startup of all fans can also be mobo related?
  14. Hi all atomicans, now there is this PC which is not connected to the internet. It as a MSI V-Class mobo, MS-7536 v1.0. (BIOS has not been updated.) P4 3GHz CPU with 1G RAM DDR2. OK, they called me up to check it out because recently it has been shuting down on them. So I went there, I reset the BIOS to safe defaults, I made win XP not shutdown during failure and it still shuts down. The strange thing is that when it shuts down, the HDD light remains ON for 20-30 secs and then powers off. So it does not power off completely at once. Don't think that there is a temperature issue. So I check the power supply with this Thermalate tool I have, where you connect the power cables and gives you the green light for all the different volt cables. All OK. Then I do a MEMTEST and no errors with the RAM. Changed the RAM slot. I took out the battery off the mobo, and checked the volts on it. Got 3.5V so the 3V battery is OK. Did a simple HDD test (Hiren's boot cd tools) So there is nothing else that comes to mind. Don't know if there is anything else I could check. I thought about a BIOS update, but the PC never had internet and it worked fine all this time with this BIOS version. Nothing changed on the machine in order to make me think of the need for a BIOS flash. The only thing that worries me is that a couple of motherboard transistors(capacitors might be the right word) show a slight swelling/bulging. So the mobo could be failing. How can we test the mobo? This person needs to pin point the exact hardware that causes these shutdowns as he does not have the money to spend on a new PC just now. Well any thoughts will be appreciated. Any ideas? How do we test a mobo? thanks
  15. Yes, mobo failing and need of a new PSU. (I should get a better PSU tester and mobo tester) Looks like building a new system is the way to go. This P4 is old and cheap enough we can build a simple system. All this person does is use word for documents. Not even internet. thank you all for your replies.
  16. No, I do not have another PSU tester. Not in Australia right now, will be next week and I'll look for one. No time to order one either (flying back in a few days). Can you recomend a tester? I have a volt meter. No wrong, I got the 4digit analyser tester... forgot about that. Should check it out. :/
  17. so I should try to run say Linux off a live CD for a while and see if that runs fine with no shutdowns. If does not shutdown then it needs a re-format and re-install windows. Or the HDD might be the problem. so there is no tool that actually tests the mobo right? So we test everything else and if that fails then it is the mobo?
  18. Checked for dust. (My first thought was the dust for heating issues) All clean. Shut downs occur after windows load. Sometimes a minute in, or a few second after windows load.
  19. Hi all, I have not looked into upgrades or new builds in a while so I've kind of lost track on latest hardware reviews and building new systems. I want to build a new tower for my brother and looking to spend around 600euro which is around 700 australian dollars. So the questions I have and need advice on are: a) Do I go for a quad core or an eight core processor? - Not sure if there are any issues with windows 7 and games using all four/eight cores. - Go for AMD (always had AMD) to save money? Go for an i5 or i7? (i7 seem too expansive and not sure if needed for a gaming system or if they are more for high end rendering) - Can get an 8 core AMD but is it worth it? Is a quad core Intel better? b) Do I go for a single video card or a crossfire build? - I always had a single video card, and always ATI cards. My thought is that there were issues with crossfire and would rather avoid issues. Also I always thought that dual core cards should be comming out which will be better than using two cards. - A good single card sometimes seems better than a crossfire setting. (Am I wrong? Also requires a smaller PSU) c) I always thought that first look for an ASUS mobo and then Gigabyte was the way to go. Am I right? Should I get an SSD to boost performance? This is going to be a gaming system, and any advice on parts I should look for is more than welcome. I have an old Cooler Master Stacker full tower case which I might use, but if we can fit a good tower for cooling at a nice price, I could get it. This is a build I got from a magazine: CPU: Intel Core i5-3570K Mobo: Gigabyte Z68A-D3H-B3 Graphics: Gigabyte Radeon HD 7770 1GB RAM: Corsair Vengeance 8GB 1.600MHz kit PSU: Cooler Master GX 650W thanks in advance. any advice is appreciated :)
  20. Thank you both. I got the answers I needed, and I got my build ready :) Will try and locate the parts here and post the final build. Looks like I'm getting the i5 (even though I am an AMD fan) EDIT: parts are more expensive here :(
  21. thanks for the reply. this is why I needed advice. I would have never thought of ASRock. I would of gone for an ASUS. Yeah I regarded Gigabyte second in the list after ASUS and then the rest like MSI etc. For graphics I like Saphire :) only cause my old Saphire ATI lasted for ages. Never had an ATI fail on me. So overclocking is a thought. I never overclock. Never done it. Cause I always thought that overclocking takes away life off the hardware. Things must have changed now and overclocking is simple. This CPU AMD FX 8150 (AM3+ , 3,6 GHz , 16 MB) is in the same price range as the Intel Core i5-3570K but its an 8 core cpu.
  22. High, don't know if anyone remembers, or can help me. I used to enter a command in the console that displayed the current position of where I was standing. With this position coordinates I could easily create new locations to place the radio for a Headquarters map. Been looking everywhere with no luck. Anyone remember what the command is? To display the current position coordinates? maybe its the same with new call of duty games. Not sure. Does the console grow bigger? Maybe it displays the info there? thanks atomicans
  23. ROUBOS

    Call of Duty 2 - Console command for coordinates?

    Thanks, that helped me cause the /viewpos command was the one I was looking for, but it only displays the results in the extended console view. thanks
  24. Hi, it has been a while since I built a system and looked into things. Just a quick question to clear something out. Is it better to go for a 6 core CPU or and 4 core. I notice that intel has expensive 4 core cpus (i7 960) which are triple channel. Are they much better than the AMD 6 core? Are all AMDs twin channel? Is there much difference in perfomance? AMD Phenom X6 1100T BE (sAM3/3,3Ghz) vs Intel Core i7 960(1366, 3,2 GHz, 8 MB L3 Cache, Box) What should I be looking for? More cores? Triple channel? What's better for the long run?
  25. It's for gaming, I never look into overclocking. It something I never do. Always thought that I reduce the CPU or GPU life by overclocking them. From what I'm reading the i7 has 8 threads, which makes it good for high end video editing, 3D editing and Photo editing applications. Does this mean that it will be better for gaming? Getting confused after reading this http://www.brighthub.com/computing/hardwar...cles/65861.aspx and this: Intel Core i7 2600 (s1155, 3,40GHz, 8MB) is a 32 nm just like the i5s. Must be new