fatbunny's Profile User Rating: -----

Reputation: 2 Apprentice
Group:
Members
Active Posts:
22 (0.01 per day)
Joined:
09-February 09
Profile Views:
590
Last Active:
User is offline Jun 14 2012 01:00 PM
Currently:
Offline

Previous Fields

Country:
IE
OS Preference:
Windows
Favorite Browser:
Opera
Favorite Processor:
Intel
Favorite Gaming Platform:
PC
Your Car:
Volkswagen
Dream Kudos:
0

Latest Visitors

No latest visitors to show

Icon   fatbunny has not set their status

Posts I've Made

  1. In Topic: 'specified cast is not valid' error

    Posted 7 Jun 2012

    you could try this.

    Dim strSQL2 As String
         strSQL2 = "delete from EMT where Empno='" & mskEmpno.ClipText & "'"
         Dim comDA as new oledb.oledbdataAdapter
         comDAdeletecommand = new oledb.oledbdataAdapter(strSQL2, conpayroll)
         comDA.deletecommand.ExecuteNonQuery()
         MessageBox.Show("Record is delete from EMT sucvessfully", "Deleteing and existing record", MessageBoxButtons.OK, MessageBoxIcon.Information)
    
  2. In Topic: dell powervault 745n, windows cant detect ahrd drive

    Posted 7 Jun 2012

    Sounds like windows server 2003 doesn't contain a native driver for the hard disk controller (common enough with newer hardware and older software).
    Go with server 2008 if possible or use the F6 to specify a third party driver during startup (when dell drivers site is functioning correctly again).
  3. In Topic: Reading in MS Access column information

    Posted 7 Jun 2012

    Thanks John, I don't have the dataset.xsd in solution explorer, only Proj_Name with sub entried My Project and form1.vb
    Also I am using visual studio 2008 express edition so some features are not available though. The other problem is while
    I can click and get this information, I need the code / program to do it. Seems to be a tricky one alright.
  4. In Topic: 'specified cast is not valid' error

    Posted 6 Jun 2012

    Probably not related to the cast error but you are missing the line "comEMT.commandtext = strSQL2" in the last section

    I added it in here

    
     Dim strSQL2 As String
                                    strSQL2 = "delete from EMT where Empno='" & mskEmpno.ClipText & "'"
                                    comEMT.commandtext = strSQL2
                                    comEMT.ExecuteNonQuery()
                                    MessageBox.Show("Record is delete from EMT sucvessfully", "Deleteing and existing record", MessageBoxButtons.OK, MessageBoxIcon.Information)[/b]
    
    
  5. In Topic: Reading in MS Access column information

    Posted 6 Jun 2012

    Thanks for the reply, I think I may have worded that incorrectly. I can get the column data alright but its the design of the tables I need. I want to see which columns in the tables are primary keys, data type, allow duplicates / nulls etc.

My Information

Member Title:
New D.I.C Head
Age:
36 years old
Birthday:
June 7, 1977
Gender:
Location:
Ireland
Years Programming:
0
Programming Languages:
vb.net

Contact Information

E-mail:
Private
Website URL:
Website URL  http://

Friends

fatbunny hasn't added any friends yet.

Comments

fatbunny has no profile comments yet. Why not say hello?