dcsimg

Search:

Type: Posts; User: muzamilsumra

Page 1 of 3 1 2 3

Search: Search took 0.03 seconds.

  1. Re: Continuously Query a Table - VB 6 - MSSQL Server 2008

    Thanks a bunch for the ideas guys, i don't have much experience in working with winsock's either, but lemme just give it a go on my own. If i fail then i'l come back to you guys. Till then i am just...
  2. Re: Continuously Query a Table - VB 6 - MSSQL Server 2008

    No there won't be. It's just one order viewing form only. But note that the Green Order form is open by multiple people at the same time on different machines.
  3. Re: Continuously Query a Table - VB 6 - MSSQL Server 2008

    Hmmmm, this is interesting now, well i like the idea of the first approach, but i am no good in that at all. Never worked with Active X controls before. So a guide or help in that matter will be...
  4. Re: Continuously Query a Table - VB 6 - MSSQL Server 2008

    Well guys, I don't know if i haven't kept my question quite clearly. Thanks for all those replies though.

    Attached is the Picture of What i am actually doing and having at the moment.

    On the...
  5. Re: Continuously Query a Table - VB 6 - MSSQL Server 2008

    Private Sub Timer1_Timer()
    On Error GoTo HALT

    SqlOrder = "select top(200) OrderNo,CustomerName,UserName,Processed,Time from tblorders order by orderno desc"
    Set OrderRS = cn.Execute(SqlOrder)
    ...
  6. Re: Continuously Query a Table - VB 6 - MSSQL Server 2008

    The scenario is this way.

    I have created an orders table in SQL Server. The orders table contains details for the products that the sales people want to order from the stores. That is the...
  7. Re: Continuously Query a Table - VB 6 - MSSQL Server 2008

    thx @vbcommander, but this is not what i'm looking for. This is done manually. I want the software to look into the table every second or milisecond or whaterver automatically. To check wether the...
  8. Continuously Query a Table - VB 6 - MSSQL Server 2008

    Hi Guys,

    I would like to know if there is any efficient way to continuously query a database table to check whether it has been updated or not. At the moment i am using a timer control which is...
  9. Showing Everything on Datagrid While using Left Join and Union All

    Hi Guys,

    What the code below does is look for entries from the TBLGRN and TBLUPGRN tables in the TBLINV tables and produces the results for the matching entries with the invoiceno on the datagrid...
  10. Re: Invalid Connection String Attribute

    Thank you for taking out some of your time for this guys but finally i got it solved.

    I just had to start the SQL Browser Service on my server machine and now all the connection strings are...
  11. Re: Invalid Connection String Attribute

    ok guys, now im using the follwoing sql connection string but now i am receiving another error.

    ConData.Open "Driver={SQL Server Native Client 10.0};Server=my-pc\sqlexpress;" & _...
  12. Re: Moving Objects On 2 Different Computers Using Winsock

    Thanks all for your support guys, i tried as passel did and it works gr8. At least it is working for 2 players. Thx alot.
  13. Re: Moving Objects On 2 Different Computers Using Winsock

    Thanks alot for your replies guys, but i'm quite confused here, any help in editing my code and showing the right way would greatly be appreciated.
  14. Re: Moving Objects On 2 Different Computers Using Winsock

    Thx for the replies guys, i understood what u said. But now how to implement it in code. Im not an expert coder...

    Data miser i want as follows
    When host clicks move, p1 should move in both host...
  15. [RESOLVED] Moving Objects On 2 Different Computers Using Winsock

    Hi Guys...I have a simple program that i am testing winsock for multiplayer capabilites on my side. I have managed to get the players moving but not quite correctly.

    Here are the details

    i have...
  16. Re: Invalid Connection String Attribute

    Thx fro the reply KGComputers, but i dont think if i have done anything that is not already in that site. According to me i have done the same thing.
  17. [RESOLVED] Invalid Connection String Attribute

    Hello,

    Following is the connection string that i am using on my server machine, which works well on the same machine for running the app


    ConData.Open "Provider=SQLOLEDB.1;Integrated...
  18. Replies
    5
    Views
    746

    Re: Adding items to other stores

    Can you explain to me more about the normalization please! i will appreciate.
  19. Replies
    5
    Views
    746

    Re: Adding items to other stores

    Thx for the suggestion Tech99, i tried out what you asked me to do but the results are the same.
  20. Replies
    5
    Views
    746

    Adding items to other stores

    Hello all,

    Any help is appreciated.

    I have 3 Tables

    Table1 - Products Table
    Productid(Index)

    Table2 - Stores Table
  21. Replies
    25
    Views
    1,827

    Re: Stock Balance

    Well we can have the same kind of product with the same part no in different BRANDS. we just need to make its productid (PID) unique.


    Yes you're right.


    Yes you're right.
  22. Replies
    25
    Views
    1,827

    Re: Stock Balance

    Well in my first post i just gave a sample of what i wanted, that was not my actual project, my actual project was the long code that i posted
    SqlProducts = "select...
  23. Replies
    25
    Views
    1,827

    Re: Stock Balance

    Dear Sam this is the code that i have used

    This code shows all the products that are created after the selected date on the calendar and the stock available after deducting whatever is sold before...
  24. Replies
    25
    Views
    1,827

    Re: Stock Balance

    Ok, The Products Table has a key as "PID" the tblCS table has a key as "CSID" and the tblInv table has a key as "INVID" which i have left them to be generated automatically.
  25. Replies
    25
    Views
    1,827

    Re: Stock Balance

    Ok, So i imported 10,000 products in my products table, imported some 2500 sales entries in my tblcs table and some 4000 sales entries tblinv table. To my surprise the system is working as smooth as...
  26. Replies
    25
    Views
    1,827

    Re: Stock Balance

    Thx again for the clarification, now i understand that tht statement means "if soldqty is NULL then replace it with 0...UNDERSTOOD.

    Ill try adding up some thousands of entries and see how the...
  27. Replies
    25
    Views
    1,827

    Re: Stock Balance

    Awesome brother,
    This is what i was looking for, works perfectly so far..Thank you very much.. but would you mind explaining this part "isnull(Q.SoldQty, 0)"
  28. Replies
    25
    Views
    1,827

    Re: Stock Balance

    lol, that is exactly what i am unable to do MASTER, and so my code is going here and there...but the code that i have posted here above does actually work...i just want to know if there is a better...
  29. Replies
    25
    Views
    1,827

    Re: Stock Balance

    Hi Phill,
    for that part of the question i am sorry for the typing error, that is obviously a typing error from my side, that was just an example of what i wanted to do in my project. So the second...
  30. Replies
    25
    Views
    1,827

    Re: Stock Balance

    ok this is the actual project code that i am doing and this is how it goes..

    I am sorry for not using line breaks in the long sentences as i am unable to do so.

    This code displays the results...
  31. Replies
    25
    Views
    1,827

    [RESOLVED] Stock Balance

    Hi Guys,
    I have 2 tables.

    Table 1 - tblProducts


    PID
    PARTNO
    DESCRIPTION
    BRAND
  32. Re: Repeating Macro..Please Help

    Option Explicit
    Sub Macro1()
    '
    ' Macro1 Macro
    '
    ' Keyboard Shortcut: Ctrl+Shift+M
    '
    Dim ws As Worksheet
    Dim PFound As Range
    Dim DFound As Range
  33. Re: Repeating Macro..Please Help

    ok i tried changing the exit sub to exit for, now it is skipping 1 row, for example i start the macro by selecting row1 of book1, it will highlight cell A1 skip A2 highlight A3 skip A4 and so forth...
  34. Re: Repeating Macro..Please Help

    Thank you for the reply vbfbryce, i have done that for next loop too, but the exit sub breaks the whole sub which prevents it from reapeating the macro. If i omit the exit sub from the code then it...
  35. [RESOLVED] Repeating Macro..Please Help

    Dear Friends,

    I have a simple scenario..let me just give you the details of what i got and what i want to do...

    I have two excel workbooks which are open...
    Book1


    PARTNO
    DESCRIPTION
  36. Replies
    0
    Views
    358

    Bar Chart by Gianni Milanese

    Hello friends,

    I dont know how many of you know about the Bar Chart created by this guy but i would appreciate any help.

    How to Increase the white area below the bars in the graph so that even...
  37. Replies
    9
    Views
    1,821

    Re: Oppening Balance

    How do i do this?
  38. Replies
    9
    Views
    1,821

    Re: Oppening Balance

    i am using VB6 with SQL server 2008.
  39. Replies
    9
    Views
    1,821

    Re: Oppening Balance

    Thx for your responses guys, last time i asked for help without showing what i had done i was told ppl dont do school home work for others in this forum. This time i have posted what i have done i am...
  40. Replies
    9
    Views
    1,821

    Oppening Balance

    Hello guys,
    I have the following scenario.

    2 Tables
    Table1 - TblCustomers


    CustomerName
    OpBalance
    DateOfOpbalance
Results 1 to 40 of 101
Page 1 of 3 1 2 3



Featured


Click Here to Expand Forum to Full Width