display form on a specific date
- From: bjwheeler@xxxxxxxxx
- Date: Tue, 30 Sep 2008 23:47:16 -0700 (PDT)
Hi There,
I want to display a form only on the 15th day of every month.
Having looked a other forums around the place, i have tried a couple
of solutions however, they do not work... e.g
Private Sub Form_Open(Cancel As Integer)
Dim dte As Date
'Check to see if today's date is 15 of any month
dte = Format(Date, "DD/MM/YYYY")
If Left(dte, 5) = "15/01" Or "15/02" Or "15/03" Or "15/04" Or "15/05"
Or "15/06" Or "15/07" Or "15/08" Or "15/09" Or "15/10" Or "15/11" Or
"15/12" Then
'Turn off system warnings
DoCmd.SetWarnings False
DoCmd.OpenForm "CompactReminder"
End If
End Sub
Can someone please assist.
cheers
BW
.
- Follow-Ups:
- Re: display form on a specific date
- From: Tom van Stiphout
- RE: display form on a specific date
- From: Mr B
- Re: display form on a specific date
- Prev by Date: How to prevent locks?
- Next by Date: Re: How to prevent locks?
- Previous by thread: How to prevent locks?
- Next by thread: RE: display form on a specific date
- Index(es):
Relevant Pages
|
