Search:

Type: Posts; User: cthai

Search: Search took 0.03 seconds.

  1. Replies
    4
    Views
    807

    Re: Complie error: argument not optional????

    Hi Opus!

    thanks for the respond... i look at the function and it's not calling more then 2

    not sure what I am doing wrong here...

    below is the funtion...
  2. Replies
    4
    Views
    807

    Complie error: argument not optional????

    Hi!

    I been working on debugging this code for 2 days now.. and my eyes are about to POP OUT! I'm fairly new with VB and trying to read someone else code and debugging it , is pretty darn hard... ...
  3. Replies
    1
    Views
    555

    HTML convert to PDF

    hello -

    I have a folder with HTML files and would like to covert all the files in this folder to PDF - I have adobe Pro 8 - but i was unable to have the vb code to generate the pdf for me -


    ...
  4. Replies
    1
    Views
    792

    Extract a single page from a multi page PDF

    Hi,

    I'm trying to extract a single page from a multi page pdf and I'm using the code below; however, I'm getting an error that it's not recognizing <param name>. Any help would be great. Thanks.
    ...
  5. Re: [VB.NET] Extract Pages and Split Pdf Files Using iTextSharp

    Hi,

    I'm trying to extract a single page from a multi page pdf and I'm using the code below; however, I'm getting an error that it's not recognizing <param name>. Any help would be great. Thanks.
    ...
  6. Re: Merge Pdf Files and Add Bookmarks to It (Using iTextSharp)

    Thank you for your guidance =) it work now
  7. Re: Merge Pdf Files and Add Bookmarks to It (Using iTextSharp)

    hello -

    Sorry I am an extreme newbie at this vb.net - but i copy your code and am curious where is the output?
  8. Replies
    4
    Views
    808

    Re: multpile pdf to one pdf in vb.net

    Hi HairyMike

    thanks for the respond - is there a way to combine the pdfs without downloading software? i was looking for something that will execute when i run my program
  9. Replies
    4
    Views
    808

    multpile pdf to one pdf in vb.net

    Hello -

    I am working in Vb.net and I have about 20 + pdf's reports I would like to combine them all to one PDF's when executing - is there a way to do this...

    thank you in advance for your...
  10. Thread: highlights dates

    by cthai
    Replies
    1
    Views
    435

    highlights dates

    Hello,

    I have 2 database from SQL express, and I'm working in VB.net, I want to know how do i get it to recognize when the end of the month change in database one to highlight the 3 day on the...
  11. Replies
    2
    Views
    425

    Re: importing Access table into SQL express

    Hi brucevde

    The importing will be a one time thing (i think) we're tying to switch over to SQL from access so i'm assuming it's a one time thing.

    I have SQL Management Studio express installed
  12. Replies
    2
    Views
    425

    importing Access table into SQL express

    Hello,

    I want to know if I can import a table in access into SQL? in Access I have a table call DeliverMonth and I would like to import that table in SQL... how do i go about doing it?

    ...
  13. Thread: SQL2005 tables

    by cthai
    Replies
    4
    Views
    520

    Re: SQL2005 tables

    My first suggestion would be to change the name of the table.

    Date is a reserved word in just about every language I've ever dealt with, and using reserved words for table or field names will...
  14. Thread: SQL2005 tables

    by cthai
    Replies
    4
    Views
    520

    Re: SQL2005 tables

    I forgot to mention that the Adding 2 months is according to our EndDate system... so we will have some EndDate In Jan - but the Month wont be for March it will still be for Feb ---
  15. Thread: SQL2005 tables

    by cthai
    Replies
    4
    Views
    520

    SQL2005 tables

    Hello All,

    I have a table name Date, and in that table i have 3 column 1)EndDate, 2)Key, 3)EndMonth.

    My question is how can i get SQL to read enddate and then at 2months from that end date with...
  16. Replies
    43
    Views
    9,644

    Re: Good Friday calculation

    Hi All,

    I'm fairly new at posting stuff, but is there something else I need to do beside saying "Thank you all your help" I read a lot and learn a lot from this forum, so if there is something...
  17. Replies
    43
    Views
    9,644

    Re: Good Friday calculation

    Thank you nbrege,

    It finally works... this is the codes that works



    Private Function SetGoodFriday(ByVal Y As Integer) As Date

    Dim a, b, c, d, e, f, g, h, i, k, L, m, month, day...
  18. Replies
    43
    Views
    9,644

    Re: Good Friday calculation

    Thank you all, for your kind help. I finally understood it and my programs is running now with out Good Friday!
  19. Replies
    43
    Views
    9,644

    Re: Good Friday calculation

    Hi techgnome,

    I would use the calculation from nbrege if i understood it... :blush:

    I try to read up on the calculating methods but I'm not comprehending...

    when i set M as an integers, VB...
  20. Replies
    43
    Views
    9,644

    Re: Good Friday calculation

    i took the formulas
    =FLOOR(DATE(A1,5,DAY(MINUTE(A1/38)/2+56)),7)-34 and try to break it down in excel to understand the logic so that i can write it in VB.net - i have no luck :-( calculating...
  21. Replies
    43
    Views
    9,644

    Re: Good Friday calculation

    sorry all this is fairly new to me -

    The more i read on the http://www.smart.net/~mmontes/butcher.html to understand the codes you provided the more confusing i get :cry:

    I dont understand...
  22. Replies
    43
    Views
    9,644

    Re: Good Friday calculation

    I convert this to VB but it said too many arguments...


    GoodFriday = NthFriday(Year.ToString, 5, Day(Date.FromOADate(Minute(Date.FromOADate(Year / 38)) / 2 + 56),7)-36))
  23. Replies
    43
    Views
    9,644

    Re: Good Friday calculation

    Hi nbrege,

    My apologies, I looked at the link but didnt stroll down to see the formula, I try to convert it into VB.net along with the other holidays that i have listed and it's giving me an error...
  24. Replies
    43
    Views
    9,644

    Re: Good Friday calculation

    Easter change from year to year I looked it up on http://en.wikipedia.org/wiki/Easter , so there is no easy way to calculate Good Friday into my holiday calculation -- :-( what is your advise on the...
  25. Replies
    43
    Views
    9,644

    Re: Good Friday calculation

    Get the date of the fourth Sunday in April.
    Then subtract that number by 3.

    for 2008 Good Friday is on March 21st... when i look at the calendar the fourth Sunday in April is April 20th subtract...
  26. Replies
    43
    Views
    9,644

    Re: Good Friday calculation

    Why is this in there: For Year = 2008 To 2008

    the reason for year = 2008 to 2008 is just a test purpose, i actually need it from 1992 to 2008
  27. Replies
    43
    Views
    9,644

    [RESOLVED] Good Friday calculation

    Can someone please explain to me the logic for Good Friday holiday - I'm tying to set up a program that will execute only working business day... exclude all weekend (Saturday and Sunday) and exclude...
  28. Replies
    5
    Views
    788

    Re: creating tables in VB for SQL

    Hi GaryMazzone,

    I have the holidays and weekend set- but when i try to add 3 days from contract dates i doesnt work - no data was imports into SQL
  29. Replies
    5
    Views
    788

    Re: creating tables in VB for SQL

    I just realize that this is going to be a little bit more tough - I want the codes to recognize 3 days after the contractdates but if the 3rd days fall on a weekend or Holiday then skip that day and...
  30. Replies
    5
    Views
    788

    [RESOLVED] creating tables in VB for SQL

    Hello,

    I have a little problem here, I am working in VB 2005 express, I can't figure out how to get the right calculation in VB to give me 3 days after due dates I'm connected to SQLexpress and in...
  31. Replies
    3
    Views
    495

    Re: Copy worksheet to new workbooks

    Hi koolsid

    Thanks for the help:afrog:


    I test out the code you provided but it's not copying the range that i want...

    it's giving me an error that T01 was not recalulated before it was...
  32. Thread: Copy a textbox

    by cthai
    Replies
    1
    Views
    395

    Re: Copy a textbox

    Sorry I meant to put the code in the the code box but dont know why it didnt show up



    Sub Copy_textbox1()
    '
    '
    '
    ActiveSheet.Shapes("Text Box 2").Select
    Select.Name ="Text Box 1" <<< i...
  33. Thread: Copy a textbox

    by cthai
    Replies
    1
    Views
    395

    Copy a textbox

    Hello All,

    This is going to look messy, I'm really new at VBA and I'm tying to copy a textbox from worksheets T01 and paste it into Workbook Table01, worksheets Jan. I have 37workbook with...
  34. Replies
    3
    Views
    495

    Copy worksheet to new workbooks

    Hi all,

    Hoping for some help, it would be greatly appreciated. I'm new to vba and my task at hand involves copying worksheets from multiple workbooks and pasting them into a new workbook with...
Results 1 to 34 of 34



Click Here to Expand Forum to Full Width