Calendar - Calendar Date Picker in Access

Print Page | Close Window

Calendar Date Picker in Access

Printed From: Codejock Forums
Category: Codejock Products
Forum Name: Calendar
Forum Description: Topics Related to Codejock Calendar
URL: http://forum.codejock.com/forum_posts.asp?TID=23887
Printed Date: 24 April 2024 at 1:54am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Calendar Date Picker in Access

Posted By: grovelli
Subject: Calendar Date Picker in Access
Date Posted: 30 July 2019 at 5:57am

I've been using MS Active X calendar in many Access applications but since it won't work in Access 64 bit I'm trying out CodeJock Calendar's DatePicker as a substitute.

I have a text box on the continuous form footer that has the following expression in its control source:

=0,7*WorkingDays(DateSerial(Year([Forms]![prev]![CGior]);Month([Forms]![prev]![CGior]);0);DateSerial(Year([Forms]![prev]![CGior]);Month([Forms]![prev]![CGior])+1;0))-Nz(DLookUp("CountofGiorno";"Query11");0)

Where CGior is the MS Calendar name.

What would you use in this case in place of

[Forms]![prev]![CGior]) ?