Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
  1. #16
    chazcoral2 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jun 2010
    Posts
    52
    I noticed that you changed the table field to My Date. But what else did you change. I can't make it work when I copy the forms to my database?
    Where does Get date come from in the event proceedure. I tdebugs this expresion.



    Private Sub CmdDate_Click()
    GCalSource = "mydate"
    GetDate [myDate]
    DoCmd.OpenForm "Calendar", acNormal, , , acFormAdd, acDialog
    End Sub

  2. #17
    jzwp11 is offline VIP
    Windows 7 Access 2007
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    You have to import the module into your database as well. The module holds the custom GetDate function

    Code:
    Private Sub CmdDate_Click()
    GCalSource = "mydate"
    GetDate [myDate]
    DoCmd.OpenForm "Calendar", acNormal, , , acFormAdd, acDialog
    End Sub

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums