Creating a blank record at the start of each month.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm creating a data base to store projects records on monthly basis. I created one form with a sub form. The main form contains information about projects and will not be changed, and the sub-form contains information that will be added each month, different information each month.

I have every thing completed, but my problem is that I want a blank record started at the begining of every month, only month and year are displayed and every thing else is empy.

many employees are working with this data base and they get confused and sometimes they put data in the wrong month.

Thank you
 
I understand you are adding items to the subform. The subform currently
displays all previous entries and you can go to the end of the subform for a
new record. When a new month starts, you want only the new record showing. I
assume that this also means that during the month that you only want entries
from that month showing. If so, add criteria to the query feeding the
subform to limit the records returned to records that are from the current
month. Since there will be no records at the start of the month, the only
thing that will show will be a new record.

Create a calculate field in the query:
Expr1:Format([DateField], "yyyymm")
and set the criteria to
Format(Date(), "yyyymm")

You can remove the check box from the "Show" box as this will be used to
filter the query, but doen't need to be in the query's output.

--
Wayne Morgan
MS Access MVP


FreeMaster said:
I'm creating a data base to store projects records on monthly basis. I
Click to expand...
created one form with a sub form. The main form contains information about
projects and will not be changed, and the sub-form contains information that
will be added each month, different information each month.
I have every thing completed, but my problem is that I want a blank record
Click to expand...
started at the begining of every month, only month and year are displayed
and every thing else is empy.
many employees are working with this data base and they get confused and
Click to expand...
sometimes they put data in the wrong month.
 
Back
Top