loading dates of a month

R

Richard

Hi

Currently I am trying to set a continuous subform form where all the events
taking place in a certain month will be shown. Of course it shows only the
days where the user has entered events only. What I would like is for the
subform to show all dates regardless with or without events, something like
the calendar. Can anyone please point me to the right direction?

Another thing, if I want a combo box to show the data from a table including
a "show all" which is not in the list from the table.

Help appreciated. Thanks in advance
Richard
 
A

Arvin Meyer

Build a table with a calendar. Hint: The easiest way is to add the first 3
or 4 dates in an Excel column, and drag it down. Then import or link it to
Access. Then set up a query with an Outer Join to your table so that all the
days will show up on the calendar side. For an editable query, add a field
to the calendar table and just use and update query to update that field in
your calendar table.

Use a Union query:

SELECT Null As ID, "<All>" As [Description]
FROM tblWhatever
UNION SELECT ID, [Description]
FROM tblWhatever;
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
R

Richard

Thanks Arvin for the great suggestion.

Richard

Arvin Meyer said:
Build a table with a calendar. Hint: The easiest way is to add the first 3
or 4 dates in an Excel column, and drag it down. Then import or link it to
Access. Then set up a query with an Outer Join to your table so that all the
days will show up on the calendar side. For an editable query, add a field
to the calendar table and just use and update query to update that field in
your calendar table.

Use a Union query:

SELECT Null As ID, "<All>" As [Description]
FROM tblWhatever
UNION SELECT ID, [Description]
FROM tblWhatever;
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Richard said:
Hi

Currently I am trying to set a continuous subform form where all the events
taking place in a certain month will be shown. Of course it shows only the
days where the user has entered events only. What I would like is for the
subform to show all dates regardless with or without events, something like
the calendar. Can anyone please point me to the right direction?

Another thing, if I want a combo box to show the data from a table including
a "show all" which is not in the list from the table.

Help appreciated. Thanks in advance
Richard
Click to expand...
Click to expand...
 
Top