Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2013
    Posts
    18

    Unanswered: What would the VBA be to execute This?

    Generate case Number When case form Opens

    CT= CASE TYPE
    CY = CASE NUMBER
    FY= FISCAL YEAR

    CT-CY-0000

    EX: ERC-13-0001

    1)Create Variable for number set it to
    CaseNum = 0
    CaseNum = CaseNum +1

    1a) Select max (CaseNum) into a variable
    1b) Select Case type into variable
    1c) Select Year = CY if todays date is between startdate + endate in Calendar table

    Variable = Select Year from CY Table where todays date is between start + end

    2 Store in Me.CaseNumber

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    With the information you provide, you have few chances of receiving an answer.
    Quote Originally Posted by Isiah_B View Post
    Generate case Number When case form Opens
    What does that mean? What is Case Number?
    Quote Originally Posted by Isiah_B View Post
    CT= CASE TYPE
    CY = CASE NUMBER
    FY= FISCAL YEAR
    Where do CT, CY and FY come from? Are they the names of controls in a form, Fields in a Recordset, variables?
    Quote Originally Posted by Isiah_B View Post
    CT-CY-0000

    EX: ERC-13-0001
    What do these examples refer to?
    Have a nice day!

Posting Permissions

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