criteria: beginnig date and ending date

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

Guest

i have followed the help format to the letter between[forms]![date criteria]![start date]and[forms]![date criteria]![end date
but i keep getting the message that in the expression there is a function access can't find. what am i doing wrong
 
Check your references. Open any code window (Ctrl+G) and go to Tools ...
References. Fix or uncheck any marked as "MISSING"
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

gary said:
i have followed the help format to the letter between[forms]![date
Click to expand...
criteria]![start date]and[forms]![date criteria]![end date]
but i keep getting the message that in the expression there is a function
Click to expand...
access can't find. what am i doing wrong
 
I would need more info on your problem, but I had a
similar issue with the beginning and ending date form in
Access 2003. Microsoft told me there is a bug with
the "Visible" property of the form (which is how the Help
file says to create an OK button for your form). Instead,
select the imput form and open it in design view by
clicking Design icon on the toolbar. In its design View,
right-click the OK button and select Property menu to open
its Properties dialog. On the Event tab, select the
[Event Procedure] option for the On Click event. Using
the VBA editor, make the event procedure as follows:

Private Sub OK_Click()
Me.Visible = False
End Sub

Hope that helps!
-----Original Message-----
i have followed the help format to the letter between
Click to expand...
[forms]![date criteria]![start date]and[forms]![date
criteria]![end date]
but i keep getting the message that in the expression
Click to expand...
there is a function access can't find. what am i doing
wrong
 
Back
Top