dcsimg

Search:

Type: Posts; User: Patoh

Page 1 of 2 1 2

Search: Search took 0.08 seconds.

  1. Replies
    9
    Views
    2,783

    Re: ListView/Excel Export ?

    Doogle.... look at frmprod... theres export button there
  2. Replies
    9
    Views
    2,783

    Re: ListView/Excel Export ?

    Hey Guyz... THanx... I Rar the Project but its 1 mb.. so i uploaded in a filehost. So heres the the link.. http://www.uploadmb.com/dw.php?id=1314522362 ... Please look thro my code. Probably you...
  3. Replies
    9
    Views
    2,783

    Re: ListView/Excel Export ?

    I have Column Headers already set up in the Listview Properties !!
  4. Re: Refreshing Records on a Form without Closing it

    Hack the Code was an example of how i load some of the data!! I have 2 forms ... One one i have that code that shows the data when i query it.....

    The Other form has an add command i can add new...
  5. Replies
    9
    Views
    2,783

    Re: ListView/Excel Export ?

    Doogle... Ots still Producing the Same Results... Just Data in Excel... No Headers
  6. Refreshing Records on a Form without Closing it

    Hello Experts, Am trying to figure out how i can refresh data on a form without necesarilly closing the form. is there a way to refresh the data in the recordset that loads the data to the form??

    ...
  7. Replies
    9
    Views
    2,783

    ListView/Excel Export ?

    Hello Experts.. I have this code to export listview items to excel... It is working as is. I want to Add the Column Headers in the Export too because it only exports the content. How do i add the...
  8. Re: VB6 Freezes and shuts down when i.... Help!!

    Doogle... Thanx... I remove the on Error and i discovered the Error and sorted it out!! It Works very well now.
  9. Re: VB6 Freezes and shuts down when i.... Help!!

    The db table has over 1000 records..
  10. [RESOLVED] VB6 Freezes and shuts down when i.... Help!!

    Hello Experts. I am trying to load a listview with access dbase contents when the form is loaded. But when i call the function that loads the listview.. the form freezes, vb6 freezes, What could be...
  11. Replies
    3
    Views
    2,741

    Re: Error 3021 EOF or BOF !! ?

    Thanx Guyz.. I Put If Satements to Control empty recordsets.
  12. Replies
    3
    Views
    2,741

    [RESOLVED] Error 3021 EOF or BOF !! ?

    Hello Experts. I am trying to create a way to delete and update data from access database using datagrid and txt controls. My main problem is everytym i execute a command with the record sets. i...
  13. Replies
    2
    Views
    1,938

    Re: Context Menu in Data grid

    Thanx Rhinobull... Anaa Question... Is there a way to bind the context menu to a single row. so that if i want to delete a row i just right click on it and click delete?
  14. Replies
    2
    Views
    1,938

    Context Menu in Data grid

    Hello Experts. I was wondering, How do i add a context menu for a row in vb6? so that when i select a row and ryt click on it it brings up the menu ?
  15. Replies
    3
    Views
    578

    Re: DataGrid Delete Help

    Yes i Just want to delete that row from the datagrid and the record associated with it in the table the dbgrid is connected to!
  16. Replies
    3
    Views
    578

    DataGrid Delete Help

    Hello Experts! I have a datagrid with a list of items. I would want to highlight and delete a record (row) from the datagrid. What function can i use that wont be activated everytym the datagrid is...
  17. Replies
    20
    Views
    6,418

    Re: Getting Sum from Access Table

    Holy Crap... I Just Solved the Problem .... it Was the Connection to the Database . all i did was to switch from
    conzo.Open "Provider=Microsoft.Jet.OLEDB.3.51;Data Source=" & App.Path &...
  18. Replies
    20
    Views
    6,418

    Re: Getting Sum from Access Table

    Do i have to Declare TotalSums anywhere?? and Thanx for the Attachment. Inotice your dbase is 2000 .. Mine is access 97 might that be associated with the problem?
  19. Replies
    20
    Views
    6,418

    Re: Getting Sum from Access Table

    I have that already enabled. I dont understand why its failing.. It says the TotalSum has an invalid datatype so it cant be executed
  20. Replies
    20
    Views
    6,418

    Re: Getting Sum from Access Table

    Is there a Reference or Component i have to Add to Make it work Seenu??
  21. Replies
    20
    Views
    6,418

    Re: Getting Sum from Access Table

    Seenu Thanx But this line wont execute it gives the same error.

    Set rst = conzo.Execute("select sum(Amount) as TotalSum from temp")

    Lemmie paste the whole code

    Dim conzo As New...
  22. Replies
    20
    Views
    6,418

    Re: Getting Sum from Access Table

    The Table has other columns which are varchar but the field am summing is all numeric
  23. Replies
    20
    Views
    6,418

    Re: Getting Sum from Access Table

    Thanx Doogle.. I Executed the code with the new changes ba this error still comes up
    " microsoft jet database engine could not execute sql statement because it contains a field that has an invalid...
  24. Replies
    20
    Views
    6,418

    Re: Getting Sum from Access Table

    I just got an error after executing this statement


    rst.Open "Select Sum(Amount) As TotalSum From temp ", conzo, adOpenDynamic, adLockPessimistic

    toto =TotalSum

    The Error is: microsoft jet...
  25. Replies
    20
    Views
    6,418

    Re: Getting Sum from Access Table

    I just got an error after executing this statement

    rst.Open "Select Sum(Amount) As TotalSum From temp ", conzo, adOpenDynamic, adLockPessimistic

    The Error is: microsoft jet database engine...
  26. Replies
    20
    Views
    6,418

    Re: Getting Sum from Access Table

    ok Seenu So i have to declare TotalSum too.. If i do Declare totalsum as long can i pass the value as

    toto=TotalSum ??
  27. Replies
    20
    Views
    6,418

    Re: Getting Sum from Access Table

    Thanx for the Reply RhinoBull. Was wondering how do i assign the value of the result to a varibale? because if i do this

    rst.CursorLocation = adUseClient

    rst.Open "Select Sum(Amount)...
  28. Replies
    20
    Views
    6,418

    [RESOLVED] Getting Sum from Access Table

    Hello Experts. How do i add up a column in an access database table. I have a table called temp and a field called total.. How do i add up all the values of that field and show the total in a Label???
  29. Thread: DBGRid Help !!

    by Patoh
    Replies
    0
    Views
    316

    DBGRid Help !!

    Hello Experts, I have a Problem i would like you to help me resolve the pic below has a form which has a datagrid. the datagrid gets data from the textboxes above it and a temp database table with...
  30. Replies
    1
    Views
    401

    Export datagrid to Word or Excel!!

    Hello I have a datagrid that fetches data from the database and out outputs it. Now. What i what is to put a command button that will export the contents of the datagrid to Word or Excel. one of the...
  31. Replies
    4
    Views
    557

    Re: Thermal Receipt Formatting & Problem

    Thanx westconn... Do you mind giving me an exapmle... of how yu would come up with tht layout?? Thanx
  32. Replies
    4
    Views
    557

    Re: Thermal Receipt Formatting & Problem

    Thanx Spoo!! What about the rest. Like the Formatting Bit ??
  33. Replies
    4
    Views
    557

    Thermal Receipt Formatting & Problem

    Hello Experts. I have a Simple Problem that i cant Figure Out. I Have a POS form that has the function below to print thermal Reciepts. I need help in to aspects of the printing part.



    With...
  34. Replies
    6
    Views
    582

    Re: Help: 2 Types of Errors

    Thanx Firoz... I actually redid the whole form up down using another method and it worked. Thanx Tho.. I discovered i had used one too many connections!!
  35. Replies
    6
    Views
    582

    Re: Help: 2 Types of Errors

    Thanx LaVolpe I Have Fixed the con one the first one.. i have removed all hints on con in the form and i think its working now. So only the search one. What would you use to supplement my search?? as...
  36. Replies
    6
    Views
    582

    Re: Help: 2 Types of Errors

    Thanx LaVolpe. I tried calling the Main function on form load but stil gives me the same error!! If i do it like this

    Dim cony As New ADODB.Connection
    Set cony = Nothing
    cony.Open...
  37. Replies
    6
    Views
    582

    [RESOLVED] Help: 2 Types of Errors

    Hello Experts, I Have 2 Major Problems i am Not Understanding So Help me out please. the first on is i have declared the con funtion in a module but when i run the program i get the 3709 error: 'The...
  38. Replies
    5
    Views
    482

    Re: Why is My KeyCode Not working

    Thanx La Volpe and jmsrickland ... After a day of struggling and Asking jus now... i feel like a dumb ass.. I jus found what was wrong... I had used some vbkeys as ShortCuts in the Main Menu!! :)
  39. Replies
    5
    Views
    482

    Re: Why is My KeyCode Not working

    Hey LaVolpe... Firstly... Gratias for the LaVolpe Button... Too Awesome... Yes i hav set the Form KeyPreview to true... thats why even f1 is working. the other keys aint workin at all f2 f3 n f4!!
  40. Replies
    5
    Views
    482

    [RESOLVED] Why is My KeyCode Not working

    My Vb Key Code isnt Workin!! only f1 is working...


    Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
    Select Case KeyCode
    Case vbKeyF1

    Call cmdNew_Click

    ...
Results 1 to 40 of 71
Page 1 of 2 1 2



Featured


Click Here to Expand Forum to Full Width