Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Location
    Hamilton,Ontario
    Posts
    132

    Unanswered: I have Two Questions

    hi Every One:
    I have two Questions.

    1- What would be return type of this function?and why?
    Public Function ConvertQtyToBF(ItemNoRipped As String, QtyTransfer4 As Integer) As Integer
    this "As Integer" is right?


    2-I wanna make a function saying if [Item Number] starts with string "ECOL" then perform desired action.How would i do that? I know i have to use some string function with wildcard. I have 100 item Number in tables startign with ECOLP....and ECOLF.
    Thanx in advance.
    bye

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    yes: as integer returns an integer if the function doesn't explode somewhere in the middle.

    don't know your details but:

    in code:
    if left$(yourString, 4) = "ECOL" then
    do this

    in value assignment:
    value = iif(left$(yourString, 4) = "ECOL", thisIfTrue, thatIfFalse)

    in a query:
    criteria = Like "ECOL*"

    izy

  3. #3
    Join Date
    Nov 2002
    Location
    Hamilton,Ontario
    Posts
    132

    Thank You So much

    Thank You so much for you help. It solved lots of problems. i really appreciate your help
    bye

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •