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

Search:

Type: Posts; User: jovsjovel

Page 1 of 2 1 2

Search: Search took 0.02 seconds.

  1. Re: Generate Daily Weekly Monthly and Yearly Report using MS ACCESS 2003

    sir this is my code for weekly
    Dim listx As ListItem
    Dim rs As New ADODB.Recordset

    rs.Open "Select * from Dailyrecord where purchase_date Between " & DTPicker2.Value & " And " &...
  2. Re: Generate Daily Weekly Monthly and Yearly Report using MS ACCESS 2003

    Yes Sir I know how ton query and i know how to where clause..i know how to ado.

    But i don't know how to determine the date in weekly monthly and yearly..


    Dim listx As ListItem
    Dim rs As New...
  3. Re: Generate Daily Weekly Monthly and Yearly Report using MS ACCESS 2003

    i am using date picker to make a report in weekly sir. but i don't know to how to code for the weekly report.. help me sir iam trying to understand but i can't.. more example sir..
  4. Generate Daily Weekly Monthly and Yearly Report using MS ACCESS 2003

    Hello Guys.. I need Your Help.. To generate the report of the daily weekly monthly and yearly report of my database.

    Can You Give me Example or Idea to Solve my Problem,

    Thanks Guys
  5. Replies
    14
    Views
    9,177

    Re: ListView Added Item

    Dim Dbl1 As Double
    Dim Dbl2 As Double
    Dim Aux1 As String
    Dim qtyadd As String
    Dim subtotaladd As String
    Dim itm As MSComctlLib.ListItem
    Dim i As Integer
    Set itm =...
  6. Replies
    14
    Views
    9,177

    Re: ListView Added Item

    Yes I did.

    But

    I don't know how to start sir, Please give some Idea, Thanks Sir.
  7. Replies
    14
    Views
    9,177

    Re: ListView Added Item

    Ive Already use code in post #4 instead of My code..
    But still My Problem not Fixed.. My Code And your Code Same Output..

    Scenario..
    Customer Buy 3 Milk and 2 Nescafe then the Cashier Punch it...
  8. Replies
    14
    Views
    9,177

    Re: ListView Added Item

    Hello Sir,,
    Sorry for My Mistake,,
    This is what i mean if the Item is already in Listview Then there are two items in Listview like
    Item--------------QTy
    Milk--------------- 1...
  9. Replies
    14
    Views
    9,177

    Re: ListView Added Item

    This is what i mean if the Item is already in Listview Then there are two items in Listview like
    Item--------------QTy
    Milk--------------- 1
    Sardines---------- 2
    Then The Customer Decide a Buy...
  10. Replies
    14
    Views
    9,177

    Re: ListView Added Item

    Yes Does it. Sir Help me for that matter..
  11. Replies
    14
    Views
    9,177

    ListView Added Item

    hello Guys,, I am Developing POS and I have A Code To Add An item into Listview Then Exactly Work.. Then My Problem is, what if the Customer Select two Similar Item let Say 3 Pack of Milk and 2...
  12. Re: ListView Problem without saving in DB Acces Using VB 6.0

    sir thanks for the idea..
    this is my code and run perfectly i am happy so much thank

    Dim qtyadd As String
    Dim subtotaladd As String
    Dim itm As MSComctlLib.ListItem
    Dim i As Integer


    ...
  13. Re: ListView Problem without saving in DB Acces Using VB 6.0

    Hello Sir.. I am Using FindItem to Find item in listview but i dont how to Add the Qty of the same item in one..

    Dim itm As MSComctlLib.ListItem

    Set itm = ListView1.FindItem(txtCode.Text,...
  14. Replies
    4
    Views
    6,010

    Re: Datareport Without Using DataEnvirontment

    Sir thanks.. This is my code..

    Run Perfectly

    Sub receipt()
    Dim rsReport As New ADODB.Recordset
    Dim reciept1 As String
    Dim Purchase1 As String
    Dim name1 As String
  15. Re: ListView Problem without saving in DB Acces Using VB 6.0

    Sir It possible use the loop in listview? I am Saving Item in ListView Without Saving in DB,..

    I Actually know to use loop if my item automatically Save in Db, But in My Problem, no I dont know...
  16. Re: ListView Problem without saving in DB Acces Using VB 6.0

    How To iterate all the listview's rows What Should I do?
  17. Re: ListView Problem without saving in DB Acces Using VB 6.0

    this is my Code..
    What Should I Do? Doesnt Work

    If txtCode.Text = ListView1.SelectedItem.ListSubItems.Add Then
    ListView1.ListItems.Item(ListView1.ListItems.Count).ListSubItems.Add , ,...
  18. Re: ListView Problem without saving in DB Acces Using VB 6.0

    In My Mind What if Customer Buy 3 Items of My Clothes then I forget to Enter the Qty into 3 , then I want ti enter Again the Barcode to Added the Another One, Then The Value of the One Item is...
  19. ListView Problem without saving in DB Acces Using VB 6.0

    Hello Guys.. I have a Code For Saving Item in ListView But My Problem is What If My First Column Same BarCode into Example:
    Barcode QTY
    001 5

    And I add Another...
  20. Daily Report, Weekly Report and Yearly Report

    Hello Guys I have a DB using MSAccess 2003 and I have a Table DailyRecord which is DailyRecords Have and Every Record then I want to know how to Select the Daily Report, Weekly Report and Yearly...
  21. Replies
    1
    Views
    7,338

    How to Update Item in ListView in Vb 6.0

    Hello Guys,, I need Your help..
    I Have A Code to Adding Item in Listview but I dont know how to update the Date.. Heres My Code
    ListView1.ListItems.Add , , lblrp.Caption...
  22. Replies
    2
    Views
    4,015

    How to Remove ListView Item in VB 6.0

    Hello Guys,, I am Trying Remove Item in ListView But my Code Does not Work..
    heres my Code
    Private Sub Command4_Click()
    Dim choice As Integer
    Dim str As String
    Dim i As Integer


    choice =...
  23. Replies
    4
    Views
    6,010

    Re: Datareport Without Using DataEnvirontment

    Hello Sir But DataField not Allowed in Section 2.. What Should I Do? HElp me Sir
  24. Replies
    1
    Views
    3,285

    Update DB Using VB 6.0

    Hello Guys, I need Your help.. Because my Code not Working,, VB 6.0 Says: Type Mismatch.


    Private Sub Command3_Click()
    Dim update As Integer


    update = "UPDATE [ProductInfo] SET Price = '" &...
  25. Replies
    4
    Views
    6,010

    Datareport Without Using DataEnvirontment

    Hello Guys.. I am Using Data Report an not using Data Environtment
    This is My Code
    Sub receipt()
    Dim rsReport As New ADODB.Recordset

    rsReport.Open "Select Receipt, ProductName, Quantity,...
Results 1 to 25 of 34
Page 1 of 2 1 2





Click Here to Expand Forum to Full Width

Featured