integrating a solution posted here to my database (1 Viewer)

[pngash]

guys, i am a noob here and by no means an access expert, however i came across a date picker sample here which i would like to use in a project i am working on. the only problem is that i dont know how exactly i can copy the sample into my project. i have attached the said sample below. anyone who can help, i will much appreciate.thanks

 

[Uncle Gizmo]

anyone who can help, i will much appreciate . thanks

Doesn't look like you've made much of an attempt to find out how to install the Date Picker. A quick look at the form "frmDatePicker" code module and I see the instructions on how to install it!

The basic instructions from the Form Code Module:-

'Author:    Allen Browne. allen@allenbrowne.com
'You may use this example for private, business, or educational purposes, with acknowledgement.
'However, you may not publish it without the express, written permission of the author.

'You also need this code in a standard module:
'---------------------standard module code begins-------------------------
'Public gtxtCalTarget As TextBox 'Text box to return the date from the calendar to.
'Public Function DatePickerFor(txt As TextBox, Optional strTitle As String)
'On Error GoTo Err_Handler
'    'Purpose:   Open the calendar form, identifying the text box to return the date to.
'    'Arguments: txt = the text box to return the date to.
'    '           strTitle = the caption for the calendar form (passed in OpenArgs).
'
'    Set gtxtCalTarget = txt
'    DoCmd.OpenForm "frmDatePicker", windowmode:=acDialog, OpenArgs:=strTitle
'
'Exit_Handler:
'    Exit Function
'
'Err_Handler:
'    MsgBox "Error " & Err.Number & " - " & Err.Description, vbExclamation, "DatePickerFor()"
'    Resume Exit_Handler
'End Function

If that's not enough for you more information can be found on Alan Brown's website here:-

Microsoft Access tips: Popup Calendar

Free popup calendar (month view) for selecting a date in a Microsoft Access database. The calendar is an Access form, so requires no additional VBA references.

allenbrowne.com

 

[MajP]

Select
External Data -> New Data Source -> From Database
Import the forms you want