If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pop-up calendar in subform that has datasheet view?
I'm using a tabbed control on a form and each tab has a subform. On one of
these the subform will be viewed as a datasheet. There are only 2 fields and one is a date field. I converted the date field text box into a combo box. I followed the instructions from fontstuff.com to add the pop-up calendar. When I click the drop-down to test it, I'm getting a runtime error that says: database can't move the focus to the control ocxCalendar. I double checked and the code looks correct with nothing mispelled. Can I still do this even though the subform is being viewed as a datasheet? It works in my other subforms that are regular form view. My code is listed below: Private Sub cboDateDue_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single) ocxCalendar.Visible = True ocxCalendar.SetFocus If Not IsNull(cboDateDue) Then ocxCalendar.Value = cboDateDue.Value Else ocxCalendar.Value = Date End If End Sub Thanks, Chad |
#2
|
|||
|
|||
Pop-up calendar in subform that has datasheet view?
Hello Chad,
I understand that you put the calender control in a form so that you could show it when mousedown event occurs. However, you'd like to the form to be in datasheet view and you receive the error message runtime error 2110: database can't move the focus to the control ocxCalendar. If I'm off-base, please let me know. I was able to reproduce the issue and I think this behavior is limitation between Access in Datasheet view and Activex control. You could try other Activex Control and you may receive the same issue. Please see the following link to use calendar control in a different form to work around the issue http://groups.google.com/group/micro...thread/thread/ 11be5b663b804fb0/28fb00a5376241a7?lnk=st&q=%22How+do+you+add+a+pop-up+calend ar+to+an+existing%22+&rnum=1&hl=en#28fb00a5376241a 7 Also, the following link is helpful: http://www.granite.ab.ca/access/calendars.htm Please rest assured your feedback of this limitation is routed to the product team. Also, I suggest you can submit this feedback to our product feedback center: http://www.microsoft.com/office/comm...pe=suggestion& lang=en&cr=US&cat=en-us-office&pt=3a4e9862-cdce-4bdc-8664-91038e3eb1e9 Please let's know if you have any comments or further feedack. Thank you. Best Regards, Peter Yang MCSE2000/2003, MCSA, MCDBA Microsoft Online Community Support ================================================== Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscripti...ult.aspx#notif ications http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx. Note: The MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support Engineer within 1 business day is acceptable. Please note that each follow up response may take approximately 2 business days as the support professional working with you may need further investigation to reach the most efficient resolution. The offering is not appropriate for situations that require urgent, real-time or phone-based interactions or complex project analysis and dump analysis issues. Issues of this nature are best handled working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services (CSS) at http://msdn.microsoft.com/subscriptions/support/default.aspx. ================================================== This posting is provided "AS IS" with no warranties, and confers no rights. |
#3
|
|||
|
|||
Pop-up calendar in subform that has datasheet view?
This AC2000 db demonstrates how to make an ActiveX calendar on its' own form
work globally including in datasheet view... http://www.byerley.net/AccessCalDemo.zip "Peter Yang [MSFT]" wrote in message ... Hello Chad, I understand that you put the calender control in a form so that you could show it when mousedown event occurs. However, you'd like to the form to be in datasheet view and you receive the error message runtime error 2110: database can't move the focus to the control ocxCalendar. If I'm off-base, please let me know. I was able to reproduce the issue and I think this behavior is limitation between Access in Datasheet view and Activex control. You could try other Activex Control and you may receive the same issue. Please see the following link to use calendar control in a different form to work around the issue http://groups.google.com/group/micro...thread/thread/ 11be5b663b804fb0/28fb00a5376241a7?lnk=st&q=%22How+do+you+add+a+pop-up+calend ar+to+an+existing%22+&rnum=1&hl=en#28fb00a5376241a 7 Also, the following link is helpful: http://www.granite.ab.ca/access/calendars.htm Please rest assured your feedback of this limitation is routed to the product team. Also, I suggest you can submit this feedback to our product feedback center: http://www.microsoft.com/office/comm...pe=suggestion& lang=en&cr=US&cat=en-us-office&pt=3a4e9862-cdce-4bdc-8664-91038e3eb1e9 Please let's know if you have any comments or further feedack. Thank you. Best Regards, Peter Yang MCSE2000/2003, MCSA, MCDBA Microsoft Online Community Support ================================================== Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscripti...ult.aspx#notif ications http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx. Note: The MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support Engineer within 1 business day is acceptable. Please note that each follow up response may take approximately 2 business days as the support professional working with you may need further investigation to reach the most efficient resolution. The offering is not appropriate for situations that require urgent, real-time or phone-based interactions or complex project analysis and dump analysis issues. Issues of this nature are best handled working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services (CSS) at http://msdn.microsoft.com/subscriptions/support/default.aspx. ================================================== This posting is provided "AS IS" with no warranties, and confers no rights. |
Thread Tools | |
Display Modes | |
|
|