Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. nnuswantari

    Convert Access Table to Excel

    Okey friend... I know that I can use Access VBA for converting. But my problem that I want to convert more than 497 database access to excel. Each file contain 10 tables. So I will convert about 4970 tables. Can you tell me to make it easy???
  2. nnuswantari

    Convert Access Table to Excel

    Hi, I am a poor programmer, I need your help I want convert data (table) from .mdb format to .xls format. Please tell me, sintax for solving my problems. Thanx
  3. nnuswantari

    Simplify my query

    Thanx for ur answer. One star for you.[2thumbsup]
  4. nnuswantari

    Simplify my query

    I have query as bellow: select a,b, sum(iif(c=1 or c=3 or c=5 or c=8 or c=9 or c=12 or c=14,1,0)) as k3, sum(iif(c=2 or c=3 or c=6 or c=7 or c=10 or c=11 or c=14 or c=15 or c=18,1,0)) as k4 from tabelA group by a,b; Can make this query so simple?
  5. nnuswantari

    Read text from notepad

    Exp: Public Function DisplayWB() As String Dim htText As String = "" htText &= "<Table align=center width='90%' border=0>" & vbCrLf htText &= "<tr>" & vbCrLf htText &= "<tr><td>&nbsp;</td></tr>" & vbCrLf htText &=...
  6. nnuswantari

    Read text from notepad

    Dear friends, I use a control 'WebBrowser' in VB.net. I want to display some textline. I will write this text line in a notepad. And then I will display to my WebBrowser. Could you tell me, How do I, so I can call/read this textline (in notepad) to my WebBrowser? Thanks for your help.[love][smile]
  7. nnuswantari

    Show and show dialog

    Dear my friends, I want to know, what is the difference show and show dialog (exp: form1.show or form1.showdialog). When do we use event 'show'? And when do we use event 'show dialog'? Thanks
  8. nnuswantari

    Call .chm file

    Thanks for ur help. I had tried this code. Very very simple. Thanks a lot
  9. nnuswantari

    Call .chm file

    Please help me. I am very poor in programming. I had made a help file (.chm). Now I want to display it on my application. Would you mind to tell me. How can I do for calling .chm file? Thanks for your help
  10. nnuswantari

    Merge cells

    Ok friends, thanx a lot for your solution.
  11. nnuswantari

    Merge cells

    Please tell me sintax to merge cells with macro in excel. Thanx
  12. nnuswantari

    Add column dynamically in datagridview

    I have a datagridview with 1 column and any rows. I will use this to entry any data. What can I do to make this column can be added dynamically in runtime???
  13. nnuswantari

    Error during save to database cause data contain apostrophe [ ' ]

    Yes, I understand. My problem was solved. Thanx
  14. nnuswantari

    Error during save to database cause data contain apostrophe [ ' ]

    Thanks for ur tips. I have used function replace. Replace (comp,"'"," "). But field comp (GORILLA'CC) have been saved as (GORILLA CC) without apostrophe. Can I save GORILLA'CC as GORILLA'CC? Not replace this apostrophe with other character?
  15. nnuswantari

    Error during save to database cause data contain apostrophe [ ' ]

    I have any data that show in datagridview ex: column name = ID Number, name, Company, salary 1st data:{001, Miss NN, CV Mellow, 500} 2nd data:{002, Mr. I , CV Mafia, 800} 3th data:{003,Miss MK, GORILA'CC , 200} I will save them to a table in Access database (eg: tbl_salary) my structure's table...
  16. nnuswantari

    Can I print data directly from DataGridView

    I want to view data from database. I make it by use ListView or DataGridView. If I want to print data from this datagridview, Can I print this directly without save it first.? Please Help me? Thanx
  17. nnuswantari

    Save data from DataGridView to Excel without save it in database

    I have a problem during save data from datagridview to excel format. I want to save it without save to database. Please help me to solve this problems. Thanks.

Part and Inventory Search

Back
Top