dcsimg

Search:

Type: Posts; User: hwkong1688

Page 1 of 3 1 2 3

Search: Search took 0.06 seconds.

  1. how to add the value to incentive database base on sales target achieve ?

    Hi, Good day to you.
    I had ms access database table name called ‘Incentive’, I had 4 textbox, textbox1,2,3 for user key in the sales values and textbox 4 is sales target values (fixed 100.00).
    ...
  2. Replies
    0
    Views
    1,011

    Labels value incorrect - data report VB6

    Hi all,

    how to insert correct value from ms access database to data report label ?


    my report as below, only last one is correct.
    the left side red box(label16,label17) value must match with...
  3. object doesn't support this property or method - VB6 data report

    Hi,
    Good day to you..
    is there anyway to get the value from the rpttextbox to label ?
    i'm using data report.

    error : object doesn't support this property or method

    my code here, but it...
  4. Re: match 2 table field then display on textbox1,textbox2,textbox3...

    sorry, noted
  5. match 2 table field then display on textbox1,textbox2,textbox3...

    Hi, Good day to all.

    can any one help on this ?

    i'm using microsoft access 2000, i have 2 database and 2 tables.

    table 1 (name : users)
    field : usedID,user,salesman,date1

    table 2 (name :...
  6. Re: use printer.print print escape problem

    Hi,
    i follow your suggestion, finally managed to solved.

    thank you.
  7. Re: use printer.print print escape problem

    Hi,
    i follow your suggestion, finally managed to solved.

    thank you.
  8. Re: use printer.print print escape problem

    Hi,
    thank you for your info, i only need to CHR$(27) symbol in prn file when i use printer.print method for send text to prn file.

    refer below screenshot.

    160223

    160225
  9. [RESOLVED] use printer.print print escape problem

    Hi,
    good day to you.
    may i know how to use printer.print to print <ESC> in prn file.

    below output only have 1 dot (.)



    Private Sub Command2_Click()
  10. runtime error '3265' item cannot be found in the collection corresponding

    Private Sub Command1_Click()


    RSCheck
    rs.Open "select sum(qty) from out", cn, adOpenDynamic, adLockPessimistic
    Text1 = rs.Fields("qty")

    End Sub

    Public Sub RSCheck()
  11. Re: how to import text file data to access database??

    cn3.Execute "INSERT INTO HMF (Code, [Number], [Date], [Time]) IN 'C:\hmf.mdb'" _
    & "Select code, [number], [date], [time] From test.txt
  12. Re: how to import text file data to access database??

    thank you dee-u, it work!:thumb::thumb:

    now my code is work fine.


    cn3.Execute "INSERT INTO HMF ([Code], [Number], [Date], [Time]) IN 'C:\hmf.mdb'" _
    & "Select [code], [number], [date],...
  13. [RESOLVED] how to import text file data to access database??

    Hi,
    why got syntax error in insert into statement??


    mycode:


    Private Sub Command2_Click()

    Dim cn3 As New ADODB.Connection
  14. Re: [RESOLVED] how to create the data report from text file?

    Thank again for your help dilettante, I will learn by myself.
  15. Re: How to sum selected row data in data report ?

    thank you for your code, just now i try, but unfortunately not a correct figure (quantity is 001)? correct figure quantity is 106584.
  16. How to sum selected row data in data report ?

    Hi,
    if i want to sum all data in one columns is no problem, how about if i only want to sum selected row??
    refer to below image file

    my code:


    Private Sub Command1_Click()

    Set...
  17. Re: how to create the data report from text file?

    ok, i will try it, my i know how you create your Resource File in vb6 or how to open your project1.res content?
  18. Re: how to create the data report from text file?

    thank you so much for your demo dilettante, it really help me a lot, but i not familiar using the schema.ini file. if i want to use dataenvironment as a data source like you mention, how to do this?...
  19. Re: how to create the data report from text file?

    thank you for your suggestion, but to create the report from database (MS access) is no problem, if from text file i don't know how? can you show me the simple example how to create report (data...
  20. [RESOLVED] how to create the data report from text file?

    Hi,
    I already know how to import text file to datagrid,may i how to create the data report from the text file??

    my text file content:
    2310047019902,50,18/12/2013,08:24...
  21. run time error 91 object variable or with block variable not set??

    Hi,
    im new vb6, this is my code, why got this error??

    highlight Red got error: run time error 91 object variable or with block variable not set

    database:MS Access
    Field: User Name
    data...
  22. Replies
    2
    Views
    1,060

    Re: [RESOLVED] Run time error 3021??

    you right! tqvm doogle ,problem solved...
  23. Replies
    2
    Views
    1,060

    [RESOLVED] Run time error 3021??

    Hi,
    im new in vb6, how to fix this error..

    Database: MS Access
    Field :UserID
    Data type: Text
    Field : Admin
    Data type: Yes/No

    Highlight error :Either BOF or EOF is true, or the current...
  24. how to update combo from the textbox ??

    Hi,
    anyone know how to update on runtime the combobox from textbox?
    i write this code work fine only after exit the program and re-open again then will update the data from textbox.
    ...
  25. Re: runtime error '94' Invalid use of Null when i view my report??

    re-solved already,the problem is the date formatted incorrect. thank you all of you guy ,especially si_the_geek your info help me solved this problem..
  26. Re: runtime error '94' Invalid use of Null when i view my report??

    thank you for your quick reply, no more error msg already, but still got blank report??
  27. [RESOLVED] runtime error '94' Invalid use of Null when i view my report??

    Hi,
    When i view my report got this error, runtime error '94' invalid use of null, but my database all have data?? if i use 'on error resume next' will blank report. Anyone can help me to re-solve...
  28. Re: run time error '6160' data access error ??

    my record data is from excel file..



    Set cn2 = New ADODB.Connection

    With cn2
    .Provider = "Microsoft.Jet.OLEDB.4.0"
    .ConnectionString = "Data Source=C:\wh_shelf.xls;" &...
  29. run time error '6160' data access error ??

    hi,
    why got this error message when i run the program.
    error on red section

    anyone help is much appreciated.

    mycode:


    Private Sub Prn2_Click()
  30. Replies
    4
    Views
    994

    Re: how to print entire data in datagrid?

    Thank Rhino,now can print out already..but how to print all data?? and i don't know where to put my LabelFormat printing code on this:-

    This code work fine.


    DataGrid1.row = 0
    DataGrid1.Col =...
  31. Replies
    4
    Views
    994

    Re: how to print entire data in datagrid?

    hi,
    Actually I want is when I mark checkbox [Print all] and click Print button then all data from datagrid will print out the barcode label and changing the data as I attach the file, i want is how...
  32. Replies
    4
    Views
    994

    how to print entire data in datagrid?

    Hi, how to use printer.print entire data in datagrid? this code is only can print
    selected row in datagrid.

    mycode:


    Private Sub Print1_Click()

    Dim i As Integer
  33. Replies
    1
    Views
    1,094

    how to print all data from datagrid??

    Hi,
    Now I only can print selected row from datagrid, how to print all row from datagrid when I click the checkbox (print all)??

    see attachment

    Below is my code for print selected row:


    ...
  34. Re: how to write the code for import excel data to access database??

    thank you for your reply and info, can you provide some simple example code for me to reference?
    (eg: my excel file is book1.xls and mydata.mdb is my database)
  35. [RESOLVED] how to write the code for import excel data to access database??

    hi,
    Anyone can help how to write the vb6 code for import excel data to my database file (mdb), because my excel have more than 10,000.00 code to manually key in to my database file. Another...
  36. VS 2008 how to delete specify duplicated row in table?

    hi,
    now my code is delete all the rows Itemcode. If i only want to delete one of my duplicated Itemcode row?

    textbox8 is connected to Itemcode column 0.



    Dim del2 As String

    If...
  37. VS 2008 Re: click cell datagridview1 and display datagridview2 in label1

    Thank for your info, solved..
  38. VS 2008 [RESOLVED] click cell datagridview1 and display datagridview2 in label1

    Hi,
    how to do when i click the cell datagridview1 in the same time will display
    datagridview2 in the label5.text (in the same row)

    my code doesn't work..any wrong?


    Private Sub...
  39. VS 2008 how to after deleted record from table 1 then will add to another table2 ?

    Hi,
    Does anyone know how to delete the record then the deleted record will add to another table.

    let said i want to delete record from table1 ID '3', description 'monitor', Qty '2'
    after...
  40. VS 2008 Re: update second rows value problem?

    thank again shaggy, problem solved.
Results 1 to 40 of 109
Page 1 of 3 1 2 3



Featured


Click Here to Expand Forum to Full Width