Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Aug 2001
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    I am learning VBA as a result (Access 2000)

    I am learning VBA as a result of learning to develop databases. (Talk about over my head)! Anyway, in a course I am taking from a book (how I've learned so far) the author allows you to add a calendar which is not dependent upon a particular form. It is not the Active X control. When it works it can insert into your form the date (and time if you like). It works great on a form, it works great on a subform, it won't work if the subform is on a tab control. I get the same run time error 2450. It recognizes the control name but reports it can't find the form. I've played with it in a few "made especially to test forms" and once that form goes into a tab control page, it doesn't work. I contacted the author who says it works in a subform. Any suggestions that preclude me from removing the subform from the tab control would be appreciated. Part of my problem is probably that I don't know how to decipher what a run time code is telling me.

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: I am learning VBA as a result (Access 2000)

    Hi Adrienne,

    This may or may not help, but I found a great calendar that acts as a popup. The best thing is that it doesn't require any activeX controls - only a standard Access form. It's quite simple to use and has worked very well for me in countless Access applications.

    I can't remember where I originally found it, but it's totally free. You can download it from <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=acc&Number=15613&Search =true&Forum=acc&Words=calendar>this post</A>

    HTH <img src=/S/salute.gif border=0 alt=salute width=15 height=20>

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: I am learning VBA as a result (Access 2000)

    The thing that usually confuses people about tab controls is that they are transparent to the parent form. So a subform on a tab control is really a subform on a parent form, but with a slight difference. Subforms on tab controls are only active when their tab is selected. If you explain more about when you get the error and under what circumstance, including the specific bit of code that is generating it, we can probably figure it out for you.
    Charlotte

  4. #4
    New Lounger
    Join Date
    Aug 2001
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: I am learning VBA as a result (Access 2000)

    The message is that it can't find the form! (It finds the control just fine!!!) The biggest problem may be that I'm so new that I don't understand the problem well enough to explain it and that will be complicated by not understanding the solution, but I'm trying! Thanks so much for responding and trying to help.

  5. #5
    New Lounger
    Join Date
    Aug 2001
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: I am learning VBA as a result (Access 2000)

    Thanks for yur efforts I've been looking at what you've sent!

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: I am learning VBA as a result (Access 2000)

    Are you trying to reference a control on the subform or even the subform itself? In that case you have to include the .Form in the syntax: Me!subcontrolname.Form!controlname

    Does that help?
    Charlotte

Posting Permissions

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