popup calander in subform

[zxmax]

Greeting
i'm kind of a rookie with access : )

i'm using the attached popup calander in my form and subform ,,,
it works perfect in my form
but when using in the subform, i get an error saying "the specified form can't be found"

if i open the subform as a form it works

so my question, is do i have to change anything in the calandar code so it could open in subform as well ??

if yes how ?

thanks in advance

 

[jrjr]

try making a command button to open the form with the wizard. It is probably to do with the path statement you are using in code.

else.... post the code you are using to open the form

 

[zxmax]

Private Sub tblDateCreated_DblClick(Cancel As Integer)
DoCmd.OpenForm "frmCalendar", , , , , acDialog, Me.Name & ";tblDateCreated"
End Sub

where "frmCalendar" is the calander , and the"tblDateCreated" is the date field

this code works if the form opens as a form, but not as a subform

i'm not sure how to edit the code to work with Subform

thanks

 

[zxmax]

forgot to mention, that the form opens fine after the error message, and when i hit the date desired to be put in the field , it gives the same message again,

 

[jrjr]

Private Sub tblDateCreated_DblClick(Cancel As Integer)
DoCmd.OpenForm "frmCalendar", , , , , acDialog, Me.Name & ";tblDateCreated"
End Sub

where "frmCalendar" is the calander , and the"tblDateCreated" is the date field

this code works if the form opens as a form, but not as a subform

i'm not sure how to edit the code to work with Subform

thanks

try this:


Private Sub tblDateCreated_DblClick

On Error GoTo Err_tblDateCreated_DblClick

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmCalendar"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_tblDateCreated_DblClick:
Exit Sub

Err_tblDateCreated_DblClick:
MsgBox Err.Description
Resume Exit_tblDateCreated_DblClick

End Sub



I take it that you are double clicking a text box to open this form correct?

 

[ghudson]

Searching is such a novel idea.

I advise you to not use the ActiveX calander control. Too many problems with the users PC having missing references to the control.

The single Popup Calendar listed below does work with subforms.

Check out these custom Access calanders for you can import them right into your database...

Popup Calendar - Version 3

I prefer the authors first calendar because I do not want the fancy three months options. Here is the link to that one... Popup Calendar

You have to be a member [membership is free] of the UtterAccess forum to download the samples from their code archives section of the forum.

 

[zxmax]

thanks guys

ghudson: i tried your suggestions, but it didn't work in my subform,
i forgot to mention, that i my subform has a subform

maybe that is why its not working ??

so my question will be.. what can i do for a subform inside a subform ??

thanks again