Search:

Type: Posts; User: newbie2

Page 1 of 13 1 2 3 4

Search: Search took 0.02 seconds.

  1. Re: Need help with Max(Date) & Min(Date) SQLite

    Olaf
    You are very helpful
    million thanks sir
    solved
  2. Re: Need help with Max(Date) & Min(Date) SQLite

    Thank you all of your interest
    Thank you Olaf of your help

    No but I want to mean the nearest future.
    I'm Sorry the attached image above is not very expressive.
    176543
    this is part of my...
  3. [RESOLVED] Need help with Max(Date) & Min(Date) SQLite

    Hello everyone
    176509
    I want to query for the date in red.
    I tried:

    StrSql = "Select Min(Date_Due) as latest FROM tbl" & _
    " where (due = 0)"
    The outcome is: 2019-02-22

    I tried with this...
  4. Replies
    4
    Views
    385

    Re: Access Vs Sqlite

    Thank you gentlemen
    I tested all the codes and all of them worked perfect
    so grateful to you
  5. Replies
    4
    Views
    385

    [RESOLVED] Access Vs Sqlite

    Hello VbForums community

    I'm using this code to save about 40 records from listview to access database.
    This code takes 1 second to do the task.

    For i = 1 To ListView1.ListItems.Count...
  6. Re: VBFlexGrid Control (Replacement of the MSFlexGrid control)

    yes it does
    Now I removed the reference to 1.3 and it worked
    thank you a lot
  7. Re: VBFlexGrid Control (Replacement of the MSFlexGrid control)

    There is no reference to the control version in the class

    Option Explicit

    Implements IVBFlexDataSource
    Private mRs As cRecordset

    'a Public Method, to allow Binding to an outside DataSource...
  8. Re: VBFlexGrid Control (Replacement of the MSFlexGrid control)

    I'm sorry
    I should have set the VBFlexGrid in the control property to: Col = 1 Row = 1 FixedRows and Cols = 0
    But something very strange is happening with virtual binding
    I'm getting type...
  9. Re: VBFlexGrid Control (Replacement of the MSFlexGrid control)

    Thank you Krool for all these efforts you are doing.
    I registrered the 1.4 OCX . I could avoid the error but
    i still can't check / uncheck as I do with the MsFlexGrid.
    I attached the wo demos....
  10. Re: VBFlexGrid Control (Replacement of the MSFlexGrid control)

    Hello Krool
    Here is the demo
    I should note that with the MSFlexGrid control doesn't throw the error
  11. Re: VBFlexGrid Control (Replacement of the MSFlexGrid control)

    thanks again
    I tested the two methods in the link provided but unluckily none of them succeeded
    One method is not possible with virtual binding
    And the the other method failed because VBFlexGrid...
  12. Re: VBFlexGrid Control (Replacement of the MSFlexGrid control)

    Krool
    Sorry to bother you again
    Does VBFlexGrid support checkbox?
    I need to delete multiple records from VBFlexGrid
    thank you
  13. Re: VBFlexGrid Control (Replacement of the MSFlexGrid control)

    very clear
    thank you Krool
  14. Re: VBFlexGrid Control (Replacement of the MSFlexGrid control)

    very clear
    thank you Krool
  15. Re: VBFlexGrid Control (Replacement of the MSFlexGrid control)

    Thank you.
    In fact I need to sort them after having fed the flexgrid control.
    I have two command buttons.
    one is
    VBFlexGrid1.Sort = FlexSortGenericAscending
    and the other is VBFlexGrid1.Sort =...
  16. Re: VBFlexGrid Control (Replacement of the MSFlexGrid control)

    Hi Krool,
    I'm binding VBFlexGrid to sqlite database

    Set VBFlexGrid1.FlexDataSource = DataSource.BindTo(Rs)
    However it is Impossile to sort columns order
    I got a message: This funtionality is...
  17. Replies
    35
    Views
    635

    Re: ChrisE How did manage to add these dates?

    I'm so grateful to you sir
  18. Replies
    35
    Views
    635

    Re: ChrisE How did manage to add these dates?

    Thank you sir
    Now I think I start to have a clear picture about my project
  19. Replies
    35
    Views
    635

    Re: ChrisE How did manage to add these dates?

    I'm sorry sir I sill could not grasp the idea.
    Would please provide a small demo of 3 vacs with 3 different dates of vaccination?
    thank you in advance
  20. Replies
    35
    Views
    635

    Re: ChrisE How did manage to add these dates?

    Thank you a lot
    I think we come to the heart of the matter

    RsVac.Open "SELECT * FROM tbl_possibleVacDate Where Vac_DateID = 5", adoConnection, adOpenStatic, adLockOptimistic
    Practically on the...
  21. Replies
    35
    Views
    635

    Re: ChrisE How did manage to add these dates?

    For the second code it is the same error
    But I could bypass the error by adding
    On
    error resume next to the code
  22. Replies
    35
    Views
    635

    Re: ChrisE How did manage to add these dates?

    This is what I'm looking for but I can't find a way.
    This is your code for saving data.

    Rs.AddNew
    .Fields("Vac_ID").Value = Val(itm.Text)
    ...
  23. Replies
    35
    Views
    635

    Re: ChrisE How did manage to add these dates?

    Well
    Are there any drawbacks the way I"m saving my data in my sample demo?
    Then is it possible to keep track of the vaccination dates?
    hank you
  24. Replies
    35
    Views
    635

    Re: ChrisE How did manage to add these dates?

    still type mismatch
  25. Replies
    35
    Views
    635

    Re: ChrisE How did manage to add these dates?

    Sorry sir I have emptied my table and I forget to fill it that's why nMonths = 0
  26. Replies
    35
    Views
    635

    Re: ChrisE How did manage to add these dates?

    I get type mismatch error
  27. Replies
    35
    Views
    635

    Re: ChrisE How did manage to add these dates?

    Now I'm not having the error in form load event
    But When I formatted the date in this line and instead of type mismatch I'm getting this error
    175467
  28. Replies
    35
    Views
    635

    Re: ChrisE How did manage to add these dates?

    Now I'm not having the error in form load event
    But When I formatted the date in this line and instead of type mismatch I'm getting this error
    175467
  29. Replies
    35
    Views
    635

    Re: ChrisE How did manage to add these dates?

    This is the tooltip when I put the curser on the line
    175459
    175461
    175463
    175465
  30. Replies
    35
    Views
    635

    Re: ChrisE How did manage to add these dates?

    I suspected that . that's why I used

    Li.SubItems(3) = DateAdd(IntervalType, nMonths + Li.SubItems(2), DTPicker1.Value) '+ 2 Months
    And

    Li.SubItems(3) = DateAdd(IntervalType, nMonths +...
  31. Replies
    35
    Views
    635

    Re: ChrisE How did manage to add these dates?

    Thank you sir
    But I'm having big trouble to test your codes.
    I'm facing type mismatch errors here in form load event:

    txtBirthdate.Text = CDate("02.02.2020")
    and in Command2_click
    ...
  32. Replies
    35
    Views
    635

    Re: ChrisE How did manage to add these dates?

    Thank you sir
    But I'm having big trouble to test your codes.
    I'm facing type mismatch errors here in form load event:

    txtBirthdate.Text = CDate("02.02.2020")
    and in Command2_click
    ...
  33. Replies
    35
    Views
    635

    Re: ChrisE How did manage to add these dates?

    I wish I would be able to achieve something like this

    175443
  34. Replies
    35
    Views
    635

    Re: ChrisE How did manage to add these dates?

    How can I save the dates of vaccin?
  35. Replies
    35
    Views
    635

    Re: ChrisE How did manage to add these dates?

    I made a mistake in form load event
    it should like this


    DTPicker3(1).Value = DateAdd("m", 2, DTPicker1.Value)
    DTPicker3(2).Value = DateAdd("m", 4, DTPicker1.Value)
    DTPicker3(3).Value =...
  36. Replies
    35
    Views
    635

    Re: ChrisE How did manage to add these dates?

    Please click on Save button
    This is the output

    175437
  37. Replies
    35
    Views
    635

    Re: ChrisE How did manage to add these dates?

    thank you sir
    you'll understand my worry when you see my demo
  38. Replies
    35
    Views
    635

    ChrisE How did manage to add these dates?

    Hello ChrisE
    Hello VbForums community
    ChrisE
    I have been playing with your Demo
    http://www.vbforums.com/showthread.php?884507-Is-this-possible&p=5459647&viewfull=1#post5459647
    I thank you again...
  39. Replies
    2
    Views
    165

    Re: Sqilite: Add a column

    Thank you Olaf
    Solved
  40. Replies
    2
    Views
    165

    [RESOLVED] Sqilite: Add a column

    Hello
    My apologies because these days I'm asking a lot of difficult questions

    I 'm using Sqlite and VbRichCient
    I wonder if it is possible to add a new column to a table but assigning the name...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width