Results 1 to 11 of 11

Thread: [RESOLVED] can somebody tell me how to accomplish this?

  1. #1

    Thread Starter
    Enjoy the moment
    Join Date
    Feb 2011
    Location
    Barrio Del pilar madrid spain
    Posts
    5,204

    Resolved [RESOLVED] can somebody tell me how to accomplish this?

    i need to get the cellnumber
    table name - Event
    Fields
    EventID = Long ( this is the cell number)
    StartDateTime = Date / Time
    Code:
    Description
    Used to calculate the cell number for the specified time value.
    
    Syntax
    
    Public Function GetCellNumber( _
       ByVal DayTime As Date _
    ) As Long
    
    Parameters
    DayTime 
    A Date or DateTime object that contains a time value to check for. 
    Return Type
    Retrieves which cell contains the specified time value.
    
    Remarks
    
    Call this member function when you want to retrieve which cell contains a specified time value.

    Name:  Untitled.jpg
Views: 281
Size:  15.5 KB
    regards
    salsa
    Last edited by salsa31; Jun 21st, 2018 at 08:41 AM.

  2. #2

    Thread Starter
    Enjoy the moment
    Join Date
    Feb 2011
    Location
    Barrio Del pilar madrid spain
    Posts
    5,204

    Re: can somebody tell me how to accomplish this?

    Name:  6.jpg
Views: 259
Size:  7.3 KB
    how do i get the number?

  3. #3
    PowerPoster Arnoutdv's Avatar
    Join Date
    Oct 2013
    Posts
    5,872

    Re: can somebody tell me how to accomplish this?

    Please elaborate, I don't understand anything of your question.

    You seem to be using an external component of which you don't understand the usage.

  4. #4

    Thread Starter
    Enjoy the moment
    Join Date
    Feb 2011
    Location
    Barrio Del pilar madrid spain
    Posts
    5,204

    Re: can somebody tell me how to accomplish this?

    Quote Originally Posted by Arnoutdv View Post
    Please elaborate, I don't understand anything of your question.

    You seem to be using an external component of which you don't understand the usage.
    exactly

  5. #5

    Thread Starter
    Enjoy the moment
    Join Date
    Feb 2011
    Location
    Barrio Del pilar madrid spain
    Posts
    5,204

    Re: can somebody tell me how to accomplish this?

    i am trying to get the cellnumber
    using this control (CalendarControl)
    please look only post #2
    Code:
    CalendarControl.DayView.GetCellNumber

  6. #6
    PowerPoster
    Join Date
    Jun 2001
    Location
    Trafalgar, IN
    Posts
    4,141

    Re: can somebody tell me how to accomplish this?

    The function is expecting a date object. By using format, you are turning Now which is already a valid date object into a string.

  7. #7

    Thread Starter
    Enjoy the moment
    Join Date
    Feb 2011
    Location
    Barrio Del pilar madrid spain
    Posts
    5,204

    Re: can somebody tell me how to accomplish this?

    Quote Originally Posted by MarkT View Post
    The function is expecting a date object. By using format, you are turning Now which is already a valid date object into a string.
    i did it but i didnt get any number

    Name:  Untitled.jpg
Views: 204
Size:  16.8 KB
    Code:
    CalendarControl.DayView.GetCellNumber Format(Now(), "MM\/dd\/yyyy HH:mm:ss")

  8. #8
    PowerPoster
    Join Date
    Jun 2001
    Location
    Trafalgar, IN
    Posts
    4,141

    Re: can somebody tell me how to accomplish this?

    Anything?
    Code:
    MsgBox CalendarControl.DayView.GetCellNumber(Now)

  9. #9

    Thread Starter
    Enjoy the moment
    Join Date
    Feb 2011
    Location
    Barrio Del pilar madrid spain
    Posts
    5,204

    Re: can somebody tell me how to accomplish this?

    Quote Originally Posted by MarkT View Post
    Anything?
    Code:
    MsgBox CalendarControl.DayView.GetCellNumber(Now)
    yes!! number 38

  10. #10

    Thread Starter
    Enjoy the moment
    Join Date
    Feb 2011
    Location
    Barrio Del pilar madrid spain
    Posts
    5,204

    Re: can somebody tell me how to accomplish this?

    tnx MArk

  11. #11
    PowerPoster SamOscarBrown's Avatar
    Join Date
    Aug 2012
    Location
    NC, USA
    Posts
    9,145

    Re: [RESOLVED] can somebody tell me how to accomplish this?

    Hey Salsa....was wondering how to properly translate "baila como nunca" (never dance?)

    Also, curious what this 'cell number' is, and why you need it. Is it a cell in a table? Just wondering. Can you explain?

    Sammi

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