CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com

Search:

Type: Posts; User: d.paulson

Page 1 of 24 1 2 3 4

Search: Search took 0.30 seconds.

  1. Re: Clearing all fields in an application form,reset for next customer.

    option1.value = False

    check1 = vbUnchecked
  2. Replies
    8
    Views
    1,140

    Re: I need help for an insert

    If values are variables your sql should be like



    sqlInsert = "insert into sirplj(COD , DEN , ABR , D, DATA , TELEGRAMA ) VALUES ( " & cod & ", " & den & ",'D', " & abr & ", " & data & ", " & ...
  3. Replies
    3
    Views
    1,073

    Re: How to update a record from a Flex Grid?

    You're having the same problem as your delete code. The solution will look very similar to the code given that made the delete work.
  4. Replies
    6
    Views
    1,014

    Re: Delete button problem

    When you open a recordset, it points to the first record. You'll need to navigate the recordset to that your flexgrid is showing before you issue the delete.


    oops. Looks like WoF is alot ...
  5. Replies
    7
    Views
    1,378

    Re: Combo Sorting/MS Access Sorting

    strSql = "SELECT * FROM [Invoice] ORDER BY len(cstr(!InvoiceNum)), !InvoiceNum"


    If InvoiceNum is a numeric. If InvoiceNum is a string than the cstr is not needed. Make sure the combobox sorted...
  6. Replies
    7
    Views
    1,378

    Re: Combo Sorting/MS Access Sorting

    Are you using bound controls?
  7. Thread: padding

    by d.paulson
    Replies
    5
    Views
    750

    Re: padding

    You just reverse it. The string goes first and then the space. I don't know vbnet so I am unfamiliar with PadRight, but it is not needed. I'll use len for the length of the string.
    ...
  8. Replies
    7
    Views
    810

    Re: negative\postitive

    SNEX_ARRAY$(EXE_AMOUNT)

    The $ indicates the variable is a string. Possibly you need the value of this string

    Try Val(SNEX_ARRAY$(EXE_AMOUNT))
  9. Replies
    6
    Views
    710

    Re: Type Mismatch issue

    You should use the ampersand '&' instead of the plus +' when concatenating strings.
  10. Replies
    11
    Views
    1,551

    Re: bad file name or number

    Have you tried removing the slash in
    Open "C:/nightlyreports.txt" For Append As #1 ' Open file to read

    The slash is a illegal character in a file name hence the error bad file name.
  11. Re: help me in this issue MID$(text.text,*,*1)

    Use instr
  12. Replies
    3
    Views
    598

    Re: Deevelopment Issues

    You can also set the form startupposition property to center screen.
  13. Replies
    2
    Views
    1,714

    Re: Authentication Failed

    shouldn't this line --> datapath = App.Path & "\Trader.mdb" be before the open statement.
  14. Replies
    14
    Views
    1,438

    Re: Ado controller SQL

    This part looks weird and You shouldn't need it.

    WHERE (([where Venue].[venueID]=[Event].[VenueID]));
  15. Replies
    4
    Views
    1,184

    Re: Define a ListBox items text.

    Try

    aaa.additem "Yes"
  16. Replies
    4
    Views
    1,034

    Re: Sql Statement issue

    strsql = " SELECT *" & _
    " From ALRAJHIBANK " & _
    " WHERE (((ALRAJHIBANK.ID)= " & itemID & "))"
  17. Replies
    1
    Views
    928

    Re: Basic combo boxes

    combo1.additem "Sidney"
    combo1.itemdata(combo1.newindex) = 1
  18. Replies
    3
    Views
    994

    Re: using Or statement

    Change to
    if lblEndResult.Caption >0 Or lblEndResult.Caption<10 then
    but I think you want an And instead of the Or
  19. Re: Saving listview data using addtolistview method

    I think you are getting that message because you are dim your connection and recordset within the AddtoListview sub and it is private to that sub. They are not dim'ed when you gosub the...
  20. Replies
    4
    Views
    5,514

    Re: Hide Row in ListView?

    ListView1.ListItems(2).width = 0
  21. Replies
    40
    Views
    32,037

    Re: INT Function Rounding Problems

    Val function is Evil.:D

    Try
    ? val("3,512.12")


    A good reason not to use it.
  22. Replies
    5
    Views
    5,402

    Re: Electronic Signature Pads

    The pad comes with an .ocx to be used. It has what looks like a picture box where what is captured from the pad is displayed in this picture box. This image can then be saved to a .bmp or a .sig...
  23. Replies
    5
    Views
    5,402

    Electronic Signature Pads

    Has anyone here ever used an electronic signature capture pad made by Topaz Systems Inc. They have some examples fo using the pad with VB, but I cannot figure out how to print the signature image to...
  24. Replies
    4
    Views
    735

    Re: problem with INSERT INTO command

    My guess is that emp_id is an interger or a long integer, so the string delimiter should be removed.


    sql = "INSERT INTO DayWiseRoster (id) select UserOFTheMonth (id) where emp_id= " &...
  25. Replies
    17
    Views
    10,768

    Re: Format date WWYY

    Msgbox format(now,"wwyy")
Results 1 to 25 of 597
Page 1 of 24 1 2 3 4





Click Here to Expand Forum to Full Width

Featured