Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Posts
    18

    Question Unanswered: Add Extensions to a item?

    Simple question for someone I hope. I have a database all setup already, what I want to do is when I exit the "ItemNumber" field it will carry that entry into the 'ImageNumber" field and add an ".jpg" extension to the right of it.

    Example:
    Item Number = 12345 (on exit or lost focus)
    This will be inserted
    ImageNumber = 12345.jpg

    I hope this makes sense to someone, been trying for 3 hours already on it already and I just can't think anymore.

    Thanks in advance for the help, you folks have been a great help in the past.

    Bob G7

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Try the next code
    PHP Code:
      Private Sub Item_Number_Exit(Cancel As Integer)
        
    txt_ImageNumberMe.Item_Number ".jpg"
      
    End Sub 

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Post

    Try the next

    PHP Code:
      Private Sub Item_Number_Exit(Cancel As Integer)
        
    txt_ImageNumberMe.Item_Number ".jpg"
      
    End Sub 

  4. #4
    Join Date
    Mar 2004
    Posts
    18

    Thumbs up That Did It

    Thanks for your quick and accurate reply, it does exactly what I needed.

    This has to be one of the best places to get fast and accurate information.

  5. #5
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    You are welcome, mainly it functions

Posting Permissions

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