Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. vwalla

    Add expression column

    I found my answer. It was simple. http://whidbey.msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_raddata/html/47e14652-2b8b-4bda-8f9d-bc0721be9260.asp Thanks very much for your help. Vwalla
  2. vwalla

    Add expression column

    This is where the error is. Me.DatagridDataSet.Tables(0).Columns("totalPrice").Expression = "PriceEach * QTY" The exception is "NullReferenceException was Unhandled" Thanks
  3. vwalla

    Add expression column

    Getting same error. "Object reference not set to an instance of an object." I am at a loss. Thanks
  4. vwalla

    Add expression column

    I get the following error: "Object reference not set to an instance of an object." ?? Thanks
  5. vwalla

    Add expression column

    ...Dim dcTotal As New Data.DataColumn("totalPrice", System.Type.GetType("System.Decimal")) dcTotal.Expression = "PriceEach * QTY" End Sub My load event Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'TODO: This line...
  6. vwalla

    Autofill Datagrid using datagrid combo

    Using VB.NET express 2005 I would like to autofill a datagrids row when a dropdown on that same row is selected. Check out this link of our Peachtree software and the datagrid. I did a screen record of what I am trying to do. http://www.deltarefractories.com/peachtreedatagrid.html and I...
  7. vwalla

    Go to previous URL (user log in)

    am using the "Go to previous URL (if exists)" checkbox with restricted access. When the user goes to the main web URL and logs in, it redirects to the "index.asp" page fine. The problem arises when the user navigates to a page on the site (other than index.asp), gets redirected to the login page...
  8. vwalla

    Insert Into sql statement errors - combo box

    Me & whoever tries to crack my computer :)! The data is not sensitive, just tracking sales tax that we have paid throughout the year (We can write it off in Texas..wooHoo!) I will use it on my company's price database program for my outside salesmen. Thanks, Vwalla
  9. vwalla

    Insert Into sql statement errors - combo box

    That worked, but I had to leave the replace stmt on the SQL also. Zemp, this is for personal use at my house. Would SQL injection be a concern? Thanks to all, Vwalla
  10. vwalla

    Insert Into sql statement errors - combo box

    Ok. I will try later this evening & post results. Got busy here at my other job. Thanks, Vwalla
  11. vwalla

    Insert Into sql statement errors - combo box

    Will this show as "Wendy''s" in my db or when I print out a list of records? Thanks, Vwalla
  12. vwalla

    Insert Into sql statement errors - combo box

    I just ran into something else. Letters & number work, but if I type "Wendy's" instead of "Wendys" I get the following error: I get a syntax error - missing operator. Apparently it has something to do with the apostrophe. Thanks
  13. vwalla

    Export error

    I am a newbie at C++ & I have been getting an error. Here's the scenario: Downloaded Visual C++ Express 2005 Beta1 Downloaded the platform SDK & .Net 2.0 Beta Trying to use the sample C++ script with installshield Express x to validate a serial. I am not changing anything about the...
  14. vwalla

    Insert Into sql statement errors - combo box

    ...Source=C:\Documents and Settings\Owner\My Documents\test.mdb;" Set addComboRS = New Recordset addComboRS.Open "select * from cat WHERE cat='" & Replace(cboCat.Text, "'", "''") & "'", db, adOpenStatic, adLockOptimistic If addComboRS.EOF Then db.CursorLocation = adUseClient...
  15. vwalla

    Insert Into sql statement errors - combo box

    Oh...I will change & let you know. Would this cause the ".exectue" stmt to error? Thanks, Vwalla
  16. vwalla

    Insert Into sql statement errors - combo box

    That is what I have. (Please look at the top)
  17. vwalla

    Installshield DLL in C++

    I have been using installshield X express and it calls for a DLL function to validate a serial number. Supplied with installshield is an example serial validation, but I am not familiar with C++ (can compile vb6 DLL with installshield). Does anyone know how to compile a dll in c++ & how to...
  18. vwalla

    Insert Into sql statement errors - combo box

    Is my connection info correct? Am I going about this properly from a coding standpoint? Thanks, Vwalla
  19. vwalla

    Insert Into sql statement errors - combo box

    I chnged it, but still get an error on ".execute" part. "Method or data member not found" Thanks
  20. vwalla

    Insert Into sql statement errors - combo box

    ...ask user if they would like to add value If MsgBox("Add Value", vbYesNo + vbQuestion, "Add Value") = vbYes Then adoPrimaryRS.Open "select * from cat WHERE category='" & Replace(cboCat.Text, "'", "''") & "'", db, adOpenStatic, adLockOptimistic db.Execute "INSERT INTO Cat VALUES('"...

Part and Inventory Search

Back
Top