Search:

Type: Posts; User: hondaboy24

Page 1 of 3 1 2 3

Search: Search took 0.04 seconds.

  1. Replies
    1
    Views
    505

    mshflexgrid clip

    hi i have a mshflexgrid and i am using the clip function but is there a way in which when a user clicks any column of the grid, i can get the whole data of the whole row? is that possible?
  2. Thread: data report

    by hondaboy24
    Replies
    0
    Views
    497

    data report

    hi i have a data report in vb6 that is attached to a data environment, but i have a problem with my query.. my query will consist of a where clause for example: WHERE date = '" & form1.label1.caption...
  3. Replies
    4
    Views
    1,762

    Re: how to stop vb6.exe

    yup i did and it worked thanks.
  4. Replies
    4
    Views
    1,762

    [RESOLVED] how to stop vb6.exe

    hey how do you stop the exe file at run time? i have an exit button with unload me as the code but all it does is closes and it never really stops. is there like a system.close for vb?
  5. Replies
    9
    Views
    584

    Re: Distinct Help

    isnt there a way around it? i want to retrieve all the other fields as well.
  6. Replies
    9
    Views
    584

    Re: Distinct Help

    yea i tried that already but it does not work, it inserts everything to my table instead of just distinct box numbers.
  7. Replies
    9
    Views
    584

    Distinct Help

    hi i have this code:

    x = "SELECT ArtNo, Name, Quantity, DateIn, UserIn, Distinct(Box) , Section FROM inventory WHERE Name = '" & Label4.Caption & "'"
    Set rs = getRecordSet(x)

    Do Until rs.EOF
    ...
  8. Replies
    2
    Views
    368

    Re: Query help!!

    yey it worked thanks!
  9. Replies
    2
    Views
    368

    [RESOLVED] Query help!!

    hi i have this query:


    x = "SELECT ArtNo, Name, Quantity, DateIn, UserIn, Box, Section FROM inventory WHERE Name LIKE '%" & txtname.Text & "%' OR ArtNo = " & txtname.Text & ""

    this query is...
  10. Replies
    15
    Views
    562

    Re: msgbox question

    i found it already it should be & instead of + . thanks guys
  11. Replies
    15
    Views
    562

    Re: msgbox question

    i tried it but i am getting a type mismatch error
  12. Replies
    15
    Views
    562

    [RESOLVED] msgbox question

    hi. how do you insert a variable in a msgbox message? i have this ryt now but it does not work.


    MsgBox "Incomplete Set. Box + i + missing.", vbCritical, "Error"

    i is the variable. thanks!:)
  13. Replies
    13
    Views
    976

    Re: delete fields in mshflexgrid

    yea but i need the id column because it is the column where the user will have to click then whatever value it is i transfer it to a label. i am using the mshflexgrid1.clip

    is there a way where i...
  14. Replies
    13
    Views
    976

    Re: delete fields in mshflexgrid

    my query just selects all the data from the database and puts it in the grid and sorts it by id.
  15. Replies
    13
    Views
    976

    Re: delete fields in mshflexgrid

    how do i get the last record number from the grid? so that i can put it in my where clause in the delete query. :)
  16. Replies
    13
    Views
    976

    Re: delete fields in mshflexgrid

    I do not know the condition for my WHERE clause, i do not have or i do not know the last entry so i do not have anything to compare it with.

    Let's say i have four id's: 3,4,9,11 stored in my...
  17. Replies
    13
    Views
    976

    Re: delete fields in mshflexgrid

    hmm you have a point. so my question should be how do i delete the last record on the database without using the WHERE clause?
  18. Replies
    13
    Views
    976

    Re: delete fields in mshflexgrid

    Yes to both questions. :)
  19. Replies
    13
    Views
    976

    delete fields in mshflexgrid

    hey how do you delete the last row in a mshflexgrid? for example i have 5 fields and i press a button to delete it so it will delete the last row then when i press the button again it again will...
  20. Replies
    0
    Views
    409

    mshflexgrid help

    i want my program to check for duplicate data in a certain column then highlight the entire row. so let's say i have 3 rows with the same column data how do i highlight and check these 3 rows?...
  21. Replies
    1
    Views
    517

    [RESOLVED] click on datagrid

    hi i have a datagrid where the data comes from a database, is there a way in datagrid where the user will just click on a cell then the selected text on the cell will transfer to a label or textbox?...
  22. Replies
    6
    Views
    430

    Re: need help with excel

    no i didnt sorry
  23. Replies
    6
    Views
    430

    Re: need help with excel

    hey yea this worked fine thanks! i have another question.. whenever i click the button or whenever this code is implemented, the excel file opens, is there a way for it not to open?
  24. Re: replace and argument not optional

    oh yea i totally forgot about the last parameter. thanks you
  25. Replies
    6
    Views
    430

    need help with excel

    i currently have this line of code and it works fine

    Set xlSheet = xlApp.Workbooks.Open("C:\Documents and Settings\cheng\Desktop\IKEA\excel\AL010_08-01-20.xls").Worksheets(1)

    but my system...
  26. [RESOLVED] replace and argument not optional

    hi i have this query where it imports the values from an excel file to ms access there are only 2 fields i need the first one is a number and the next is a word with apostrophe's in them so this is...
  27. Replies
    2
    Views
    430

    insert apostrophe

    hi, i have this code where it will import from excel to access but it won't accept fields with apostrophes in it, is there a way around it? i remember a code, something like replace? but do not know...
  28. Replies
    1
    Views
    3,550

    Re: import excel to access

    will this code work for an update? if i already have an existing table and whenever the user uploads the data will just append? and what if i only want 2 columns out of lets say 8 columns in the...
  29. Re: MS Excel file import to VB program and saves to a database

    yes i did, this is currently my code now:


    Private Sub Command1_Click()
    Dim strSQL As String, j As Integer
    Dim xlApp As Excel.Application, xlSheet As Excel.Worksheet
    Set xlApp =...
  30. Replies
    2
    Views
    1,414

    transferspreadsheet method

    ok i am trying to import excel to access and i have been looking for sample codes to help me do it and i found one
    Private Sub Command1_Click()
    Application.DoCmd.TransferSpreadsheet...
  31. Re: MS Excel file import to VB program and saves to a database

    hi i used this code but i am getting an error message which is : data type mismatch in criteria expression
  32. Replies
    1
    Views
    3,550

    import excel to access

    hi is this possible? import an excel file to ms access through vb6? i already have the code to browse for files, all that is remaining is for the user to click a button then the data in the excel...
  33. Replies
    3
    Views
    559

    Re: resizing column in datagrid

    yea but the data in my datagrid comes from the database.
  34. Replies
    3
    Views
    559

    resizing column in datagrid

    how do you resize a column of a datagrid to match the length of the text in it? and is it possible to change the style of the header to bold? thanks :)
  35. Replies
    7
    Views
    542

    Re: LIKE clause in ms access

    it works! thanks!
  36. Replies
    7
    Views
    542

    [RESOLVED] LIKE clause in ms access

    hi, i am using vb6 and ms access and I can't seem to get the syntax for the like clause to work. i currently have this query:

    "SELECT * FROM inventory WHERE name LIKE " & txtname.Text

    is this...
  37. Re: inserting special characters to database

    yea it works thanks :)
  38. Re: inserting special characters to database

    yea but what i mean is that initially i do not know what the user will be inputting but i want to make sure that whatever he inputs, if there are special characters it will still be saved with the...
  39. [RESOLVED] inserting special characters to database

    hi, i am trying to insert special characters from a text box to ms access and i am using visual basic 6. special characters like ' . / and letters with lines above them. How do i save them directly...
  40. Replies
    3
    Views
    378

    combo box question

    hi.. i have a combox box where the texts come from a database.. is it possible to color code the text in the combo box? let's say i have 5 data in the combox and i want each of the texts to have...
Results 1 to 40 of 86
Page 1 of 3 1 2 3



Click Here to Expand Forum to Full Width