Access Question - Make Box on Form Take Date from Calendar
Amazing chart utilities from Jon Peltier
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Access Question - Make Box on Form Take Date from Calendar

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    82
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hi,

    I've been working on a little app in Access and am trying to make a textbox take the date from the ActiveX Calendar supplied within "More Tools" in access. But have no idea where to start. Anyone got any ideas ?

    Cheers
    Darren

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sydney, Australia
    Posts
    2,936
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    I've been working on a little app in Access and am trying to make a textbox take the date from the ActiveX Calendar supplied within "More Tools" in access. But have no idea where to start. Anyone got any ideas ?
    Hi,

    If the calendar control is called MyCalendar and the textbox is called text0 put this code in the form's code module i.e. right click it and choose Build Event.

    Private Sub MyCalendar_Click()
    With Me.Text0
    .SetFocus
    .Value = Me.MyCalendar.Value
    End With
    End Sub

    HTH,
    Dan


  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    82
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Dan,

    Thanks for the reply.

    Nothing happened there, so i'll try a little more detail.

    I have a form called frmActions and a from called frmCalendar

    I have re-named the text box on the actions form to Text0 and the Calendar on frmCalendar to MYCalendar to match the code snippet you gave me.

    Would there be other changes with that info ?

    Cheers
    Darren

  4. #4
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Darren

    So long as both forms are loaded into memory you can use:

    Private Sub frmCalendar_Click()
    frmActions.Text0 = frmCalendar.Value
    End Sub



  5. #5
    Board Regular
    Join Date
    Mar 2002
    Posts
    82
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Dave,

    when I try to compile that, I get an error message that says variable not defined and highlights the frmCalendar word in the middle line of the code. Any Ideas ?

    Thanks
    Darren

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sydney, Australia
    Posts
    2,936
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hi,

    I tried doing this:-

    Private Sub MyCalendar_Click()
    Form_frmActions.Text0.Text = Me.MyCalendar.Value
    End Sub

    but got an Out Of Memory error (!?)

    I'm still learning Access and am in no way a guru. You'll get a quick and easy response if you post your question here:-

    news://msnews.microsoft.com/microsof...gettingstarted

    Regards,
    Dan

    [ This Message was edited by: dk on 2002-04-03 04:14 ]

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com