Results 1 to 2 of 2

Thread: Thanks Hack and Sethindeed

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Mar 2001
    Location
    Anywhere
    Posts
    136

    Thanks Hack and Sethindeed

    Thanks Hack
    I don't know why but Sethindeed method didn't work.
    Can you tell me Hack how to format the recordset element containing the date before the grid gets populated.

    Thanks for your time

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333
    You will need to know what element in your recordset contains the date, but that should be easy to determine. For the purpose of this example, I'm using a recordset name of simply Rs and the date is contained in the first element (Rs(0)). Change Msgbox with the appropriate MSFlexGrid Row and Column
    VB Code:
    1. MsgBox Format(Rs(0), "mm/dd/yyyy")

Posting Permissions

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



Click Here to Expand Forum to Full Width