Search:

Type: Posts; User: mousewonders

Search: Search took 0.02 seconds.

  1. Replies
    4
    Views
    2,361

    Re: Update is not a member....??

    Quick question.. So whenever you need to have your datagridview show data from two tables or more you will have to create these queries right?
  2. Replies
    4
    Views
    2,361

    Re: Update is not a member....??

    See now this was very helpful. I thank you for your time in pointing this out. I somewhat thought that was the case but was unsure if I was just doing it wrong or if I needed to design the update...
  3. Replies
    4
    Views
    2,361

    Update is not a member....??

    Why do I lose update after adding inner joins to my query?


    Error 1 'Update' is not a member of 'KanBan3.KanBan2DataSetTableAdapters.kb_cartTableAdapter'. C:\Documents and Settings\leightr\My...
  4. Replies
    2
    Views
    15,914

    Re: Update selected row in datagridview

    Okay I figured out that:
    Kb_cartDataGridView.CurrentRow.Selected = "status='" & True & "'"

    Is not what I wanted... as it seems this code is to select the entire row.. and I had it wrote wrong....
  5. Replies
    2
    Views
    15,914

    Update selected row in datagridview

    I want to have a button onces clicked up date a selected row field in my datagridview to either check a checkbox or set the field to lets say complete.

    I tried using the following but I get a...
  6. Re: [2005] How to remove BindingSource.Filter?

    I figured it out: KbcartBindingSource.Filter = String.Empty
  7. [2005] How to remove BindingSource.Filter?

    I have KbcartBindingSource.Filter = "cart_id='" & TextBox1.Text & "'" this changes my DataGridView to only show the cart with the ID the user typed in. How do I reset the DataGridView to show all of...
  8. Re: [2005] Determining which cell is selected in a DataGrid.

    wow. I just thought you didnt know how to communicate, but it appears you are trying to be a flat out *******. You win. I dont understand why you even post here. I am sure if I went through your post...
  9. Re: [2005] Determining which cell is selected in a DataGrid.

    You've got the grid's CurrentRow, so you can get any cell in that row and then get that cell's Value. You can then do anything you want with that value.

    How? where? I dont do how to code to call...
  10. Re: [2005] Determining which cell is selected in a DataGrid.

    I need to know the package id of the row they have clicked on to edit the detailed information of the package that is not contained in the row. So, I assume I need to grab the package id and insert...
  11. Re: [2005] Determining which cell is selected in a DataGrid.

    Yes, but I do not know how to use them. Care to explain a little?
  12. Re: [2005] Determining which cell is selected in a DataGrid.

    I am using a DataGridView.. thanks for pointing that out.
  13. [2005] Determining which cell is selected in a DataGrid.

    How do I determine which cell/row was selected by a user in a DataGrid? Well, basically the question is,

    I would like to provide a datagrid of some packages. Every package has detailed items...
  14. Replies
    10
    Views
    664

    Re: How do I write this query?

    Woot! You are awesome! Thanks for taking the time to look into this for me! Problem solved, Project completed!!!

    Thanks so much

    richard
  15. Replies
    10
    Views
    664

    Re: How do I write this query?

    Can you show me how to write it in the below query?

    movenow = "INSERT INTO archive ( userid, timein, signdate, timeout, outdate ) SELECT whoishere.userid, whoishere.timein, whoishere.signdate,...
  16. Replies
    10
    Views
    664

    Re: How do I write this query?

    I couldnt get the example you provided me working 100%. I did get the query to work, but only using Now()


    movenow = "INSERT INTO archive ( userid, timein, signdate, timeout, outdate ) SELECT...
  17. Replies
    10
    Views
    664

    Re: How do I write this query?

    This query is working so far. I realize I need to pull out the feilds and get them listed however I am not sure how to put the date and time in.
  18. Replies
    10
    Views
    664

    Re: How do I write this query?

    Access database and I just have them as text fields but I could change them to date/time.
  19. Replies
    10
    Views
    664

    [RESOLVD] How do I write this query?

    The below code works but I need to insert into archive a time into the field called timeout and a date into a field called outdate. along with all the records that the below already pushes over to...
  20. Replies
    13
    Views
    743

    Re: Query Error: Data Mismatch

    Got it!

    SOrry you might have been telling me how to fix it and I was just to dumb to put two and two together! You did teach me how to use DEBUG!! and I thank you!!


    Private Sub...
  21. Replies
    13
    Views
    743

    Re: Query Error: Data Mismatch

    I know what the data mismatch is from. I changed the userid feild to text in the access database when i was trying to fix the first problem, I changed it back. But I still get the same thing when I...
  22. Replies
    13
    Views
    743

    Re: Query Error: Data Mismatch

    getID = "Select * from users where userid =1" returns a Data Mismatch Error
  23. Replies
    13
    Views
    743

    Re: Query Error: Data Mismatch

    Oh, I see.. getID is "Select * from users where userid =' 1'"! How do I get the results of "Select * from users where userid =' 1'"?
  24. Replies
    13
    Views
    743

    Re: Query Error: Data Mismatch

    "Select * from users where userid =' 1'"
  25. Replies
    13
    Views
    743

    Re: Query Error: Data Mismatch

    I am not sure how to do that.. :(
  26. Replies
    13
    Views
    743

    Re: Query Error: Data Mismatch

    If you can not tell I am pretty new to this. You were right, I had the userid as a number. I got the query to work, but how do I check to see if the query found the user or not?

    I tried:



    ...
  27. Replies
    13
    Views
    743

    [RESOLVED] Query Error: Data Mismatch

    [THANKS FOR ALL THE HELP!!!]

    I swear everytime I write a query in VB I get some stupid error that I have to work on for 10 hours! lol.

    The following has a Data Mismatch error:


    Dim con As...
  28. Replies
    10
    Views
    737

    Re: What is wrong with this?

    lol. Opps I guess I forgot to remove the first del
  29. Replies
    10
    Views
    737

    Re: What is wrong with this?

    Okay.. I figured it out (again) I am not sure if this is the correct way of doing what I am doing.. but it works! I thought I would post the correct code.. maybe someone can re-write it the correct...
  30. Replies
    10
    Views
    737

    Re: What is wrong with this?

    Okay I got it working with the following... the only problem is now the delete will now work!! But if I remove the move sql the delete will work.


    Dim con As New ADODB.Connection
    Dim...
  31. Replies
    10
    Views
    737

    Re: What is wrong with this?

    It doesnt seem to work

    Dim con As New ADODB.Connection
    Dim con_string As String
    Dim sql As String
    Dim sql1 As String
    Dim rs As New ADODB.Recordset
    ...
  32. Replies
    10
    Views
    737

    Re: What is wrong with this?

    Yep Thanks a million!!

    Any clue how to move the record to another table before I delete it?
  33. Replies
    10
    Views
    737

    Re: What is wrong with this?

    Still a Data Mismatch error
  34. Replies
    10
    Views
    737

    What is wrong with this?

    Dim con As New ADODB.Connection
    Dim con_string As String
    Dim sql As String
    Dim rs As New ADODB.Recordset
    con_string = "Provider = Microsoft.Jet.OLEDB.4.0; Data...
  35. Replies
    1
    Views
    383

    Lookup and Move of a record

    Hey!

    I need help with a project I am working on. I need to lookup a record in a access database.

    Basically, I have created a form with a textbox and a button. What I want to happen is you enter...
Results 1 to 35 of 35



Click Here to Expand Forum to Full Width