Prev: On Dirty Event
Next: Using a subform to display and add info into table
From: FORM DATES FORM on 17 Mar 2010 01:36
HOW ALL DAYS OF A MONTH WILL BE RESULT WITH TEXT BOX IN FORMS
From: fredg on 17 Mar 2010 12:40
On Tue, 16 Mar 2010 22:36:01 -0700, FORM DATES wrote:

> HOW ALL DAYS OF A MONTH WILL BE RESULT WITH TEXT BOX IN FORMS

Sorry, but your question is confusing and incomplete.
Perhaps you wish to know how to determine how many days there are in a
month. If so what month? How does Access know which month? Which year?

Let's assume the current month.
You can use the DateSerial function. Look it up in VBA help files.

The day 0 of the following month will tell you how many days there are
in the current month.

=DateSerial(Year(Date()),Month(Date()) + 1,0)

Change Date() to a field name [DateFieldName] if you want the number
of days in the month of a date stored in a date field.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
From: KARL DEWEY on 17 Mar 2010 12:47
Huh?

--
Build a little, test a little.


"FORM DATES" wrote:

> HOW ALL DAYS OF A MONTH WILL BE RESULT WITH TEXT BOX IN FORMS
From: John W. Vinson on 17 Mar 2010 13:00
On Tue, 16 Mar 2010 22:36:01 -0700, FORM DATES <FORM
DATES(a)discussions.microsoft.com> wrote:

>HOW ALL DAYS OF A MONTH WILL BE RESULT WITH TEXT BOX IN FORMS

Please post a comprehensible question. Turn off your CAPS LOCK please, all
caps is hard to read and looks like you're shouting.

Explain what data you have in the form's recordsource and what you want to see
- thirty-one textboxes with dates, or what???
--

John W. Vinson [MVP]
 | 
Pages: 1
Prev: On Dirty Event
Next: Using a subform to display and add info into table