Search:

Type: Posts; User: zach007

Page 1 of 5 1 2 3 4

Search: Search took 0.04 seconds.

  1. Re: How to delete row (VBA Excel)..pls help

    Thank you so much for your reply...and kind helps :)
  2. [RESOLVED] How to delete row (VBA Excel)..pls help

    Dear Expert,

    How to delete rows please..???..when everytime I click "Delete Row" button, it will delete one current row..and so on...BUT when it has no more row to delete, it will show up a pop up...
  3. Re: How to Add Row (VBA Excel)..pls help

    Hi,

    Thanks a lot...I just want to ask more if you dont mind...

    1. How to calculate the Grand Total please..??
    2. and, how to add row to the next row without skipping one row please?

    Thanks...
  4. [RESOLVED] How to Add Row (VBA Excel)..pls help

    Dear Experts,

    I am trying to make an invoice or PO form with Excel VBA....I have "No", "Item No"(combobox), "Description", "Unit Price", "Qty" and "Total" and an "Add Row" button...(these are on...
  5. Replies
    9
    Views
    1,102

    Re: Drop down menu (Excel) please help...

    Hi,

    To "DKenny": Thanks for your reply...it was amazing...But, how to make "step by step" walktrough for in-cell validation on Cell B2 and then pass the selected value to a lookup fuction to...
  6. Replies
    9
    Views
    1,102

    Drop down menu (Excel) please help...

    Dear Experts,

    I am trying to make a drop down menu in Microsoft Excel 2003 using VBA as the following sample:

    I create a drop down menu in B3...and has the following value: "01", "02" and...
  7. Re: Tips for moving from VB6 to VB.NET [new info added 10-19-05]

    Hi,

    I would like to ask...VB 6 is structured language right? How about Visual Basic 2005..???...Because I have Visual Studio 2005 and Visual Studio.NET 2003, which both are object oriented...
  8. Replies
    5
    Views
    788

    Re: I dont know why?

    ooo....ic...

    Thanks for that..:)
  9. Replies
    5
    Views
    788

    Re: I dont know why?

    Hi,

    Thanks for reply... :)

    How to set current date...if you look at the last post on this topic...the (another) issue has not been resolved...Please have a look carefully for the several last...
  10. Replies
    5
    Views
    788

    I dont know why?

    Hi all administrators,

    I dont know why, lately, if I post some threads, no one answering my questions as what I asked...for an example, I already tried for many times to work with codes...but it...
  11. Replies
    51
    Views
    2,529

    Re: [RESOLVED] How to set current date..??

    Hi Rob,

    Sorry.. I just wanna ask...why dont you just fix that codes please..???...That is not only for me...Because you could post this issue of Word VBA on the tutorial so everybody can see it...
  12. Replies
    51
    Views
    2,529

    Re: [RESOLVED] How to set current date..??

    Hi Rob,

    I read trough all related FAQ but there is no answer or example there....especially for "Check Current Stock"...is it possible for me to know that codes please...because I intent to put...
  13. Replies
    51
    Views
    2,529

    Re: [RESOLVED] How to set current date..??

    Hi,

    I am using ADO, and the database is Ms Access........is there any tutorial/how to now the codes look like for this kind of form in Ms Words please...???...like auto increment number, line this...
  14. Replies
    51
    Views
    2,529

    Re: [RESOLVED] How to set current date..??

    Hi,

    I tried but still error:



    Private Sub cmd_CheckCurrent_Click()

    Dim con As ADODB.Connection
    Set con = New ADODB.Connection
  15. Replies
    12
    Views
    839

    Re: Auto Increment...please help..

    Could some one correct my codes please in order to run...??? Thanks very much...

    Jennifer :)
  16. Replies
    3
    Views
    474

    Cannot delete..please help...

    Dear Experts,

    Has anyone could help me please to fix this code...it always failed I tried many time?...This is a "Delete" button, when I press this button, it should be delete row/item on the...
  17. Replies
    1
    Views
    355

    Help please....cannot delete

    Dear Experts,

    Has anyone could help me please to fix this code...it always failed I tried many time?...This is a "Delete" button, when I press this button, it should be delete row/item on the...
  18. Replies
    51
    Views
    2,529

    Re: [RESOLVED] How to set current date..??

    Please help me with this codes...only one step to finish...thanks a lot,

    Jennifer :(
  19. Re: What is wrong with my codes...cannot update/edit

    Hi,

    I am not using DAO...but, I am using ADO connection..???
  20. Re: What is wrong with my codes...cannot update/edit

    Hi,

    I did this code:


    Private Sub cmdDelete_Click()
    If MsgBox("Are you sure you want to delete this record?", vbYesNo + vbQuestion, "Delete?") = vbNo Then 'check if you really want...
  21. Replies
    8
    Views
    811

    Re: Please correct my codes...

    Hi,

    Sorry...when I changed the fieldname with Item_Code...there is a new error message:

    Run Time Error 3021: Either BOF or EOF is True, or the current record has been deleted. Requested...
  22. Replies
    8
    Views
    811

    Re: Please correct my codes...

    Hi,

    I already changed it to my fieldname 's name...but still get the same error which is Run Time Error 381....
  23. Replies
    51
    Views
    2,529

    Re: [RESOLVED] How to set current date..??

    Hi Rob,

    Sorry...would you like to help me to find the code please..???

    Thanks very much for your kindness..

    Jennifer :(
  24. Replies
    8
    Views
    811

    Re: Please correct my codes...

    Hi,

    I did what you directed but received error message:

    I did like this:


    Private Sub cmd_CheckCurrent_Click()

    Dim con As ADODB.Connection
  25. Replies
    8
    Views
    811

    Re: Please correct my codes...

    Hi,

    Thanks for your reply...it is from a combobox...would you please correct my code please....????..I tried many time and finally get frustrated.... :)

    OR do you want to see all codes (I mean...
  26. Replies
    8
    Views
    811

    Please correct my codes...

    Dear Experts,

    Has anyone could help me please for these code?

    visual basic code:
    Private Sub cmdCheckCurrentRecord_Click()

    Dim con As ADODB.Connection
    Set con = New ADODB.Connection
    ...
  27. Replies
    51
    Views
    2,529

    Re: [RESOLVED] How to set current date..??

    Dear Experts,

    I really need your help with this codes...I tried many time and this is my last codes but still wont work...please help me:


    Private Sub CommandButton3_Click()

    Dim con As...
  28. Replies
    51
    Views
    2,529

    Re: [RESOLVED] How to set current date..??

    Please...show me the code (the corrected codes please)..because that is better for me to learn....I am just a novice user and try to learn how to make it...because there is no on the net and also on...
  29. Replies
    12
    Views
    839

    Re: Auto Increment...please help..

    Please...show me the code..because that is better for me to learn....I am just a novice user and try to learn how to make it...so, please me the codes if you dont mind....anyway, this is also for...
  30. Replies
    12
    Views
    839

    Re: Auto Increment...please help..

    I just type it in each TextBoxs then click "Add Row" button to show what on each TextBoxs into each rows on the table on the word document...:)
  31. Replies
    51
    Views
    2,529

    Re: [RESOLVED] How to set current date..??

    Dear Experts,

    Has anyone could help me please for these code?


    Private Sub CommandButton3_Click()

    Dim con As ADODB.Connection
    Set con = New ADODB.Connection
    con.Open...
  32. Replies
    12
    Views
    839

    Re: Auto Increment...please help..

    Hi,

    This is another application without using a database...and please show me the correct codes since it is easier for me to learn.... ;)

    Thanks :)
  33. Replies
    12
    Views
    839

    Re: Auto Increment...please help..

    Hi,

    Thanks for your kind helps...I just follow your codes and received error message:

    Run Time Error 13: "Type mismatch." and this code:


    AutoNum = CInt(Left(myTable.Rows(myTable.Rows.Count...
  34. Replies
    2
    Views
    437

    Re: How to learn Process Logic...???

    Hi,

    Thanks very much for your kind helps...

    Is there any good source or URL address to learn that one please...???

    :)
  35. Replies
    2
    Views
    437

    How to learn Process Logic...???

    Dear Experts,

    I just want to know and learn...where/what is the best source of learning the process logic please..???... For instance, this codes:

    newRow.Cells(2).Range.InsertAfter...
  36. Replies
    12
    Views
    839

    Re: Auto Increment...please help..

    Anyone could help me please with this code..???

    Thanks a lot...

    Jennifer :)
  37. Replies
    1
    Views
    511

    Re: use VB to show data from excel?

    Hi,

    I am not sure, and I am not an expert at all...but, please try this link. I wish this helps:

    Click Here For Tutorial.

    and also try this: Try this also.

    ;)
  38. Re: How do I set a specific date on the calendar when the form load in Access???

    I am not sure what do you mean exactly....I am not the expert at all, may be I am right or may be I am definitely wrong...just try to help...is this what you mean?:



    TextBox1.Text = Format(Now,...
  39. Replies
    12
    Views
    839

    Re: Auto Increment...please help..

    hi,

    would you please show me its codes please..???..I tried many times but always failed... :)

    thank you so much....
  40. Replies
    12
    Views
    839

    Auto Increment...please help..

    Dear Experts,

    I am creating a word document with VBA form...what should I add to this following codes to create an auto increment...for instance, I have "No", "Name", "Address", etc...when I click...
Results 1 to 40 of 194
Page 1 of 5 1 2 3 4



Click Here to Expand Forum to Full Width