Recent content by MagicCity33

  1. M

    Update Excel Spreadsheet

    Hello All, I am trying to update a excel spreadsheet from VB.NET then print it. I would like for the data from the VB form to be placed in various cells in the spreadsheet. All calculations would be done in excel then I would print the spreadsheet. I noticed that the data is not being...
  2. M

    help me to update database

    Hello, if you are post information from textboxes this code always works for me in my VB code behind. Try Dim addSQL AsString = "INSERT INTO (enter your table name here )([Name],[BeginDate]) VALUES (" _ & " '" & textbox1.Text & "', " _ & " '" & textbox2.text & "' )" 'Check the connection...
  3. M

    Updating Access with UPDATE Statement with VB.NET 2K3

    Thank you both for your responses, kulrom I tried setting my SQL statement up the way that you suggested and received the error "Syntax error in UPDATE Statement". I've tried several different ways of formatting the statement but always receive this error. I even got a IS consultant to look...
  4. M

    Updating Access with UPDATE Statement with VB.NET 2K3

    Hello all, I'm trying to update data in an Access database but according to VB.NET I have a syntax error in my UPDATE SQL Statement. I have looked over this code over and over and again but I just don't see any problems with what I have. I can update one field at a time but I would like to do...
  5. M

    Something simple-----

    Something Simple Hey Thanks!!! That did it. I have objFrmMain set as public in the module but I didn't have objfrmMain = ME in the form load event. Why do you have to do it this way though?
  6. M

    Something simple-----

    I did that. That's how I discovered that I was getting nothing. The values are not retained after it gets into the function that is in the module. It works if I set up a public variable then set the variable = textbox before going to the function. I just don't understand why I have to do it...
  7. M

    Something simple-----

    I'm trying my hardest to get adjusted to writing code in VB.NET and I have something that is eluding me. If I want the text in txtgb1Age.Text to be placed into a word doc I normally do something like this dim MyAge as string MyAge = txtgb1Age.TEXT...
Top Bottom