Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2005
    Posts
    39

    Unanswered: existing form/field

    Here's my code:
    Code:
    Function Timerz()
    'call
    Dim time_now
    'declare
    time_now = Format(Now(), "hh:mm AMPM")
    'Make this prompt ONLY when RemindTime = Now()
    If ([Forms]![fClientReminder]![RemindTime] = time_now) Then
    MsgBox ("The time now is: " & time_now)
    'Do nothing if there are no matching times
    Else: MsgBox ("Its not the time")
    End If
    
    End Function
    Whether this applies through macro|module, MS Access always yells at me about [Forms]![fClientReminder]![RemindTime] not existing. Everything is spelled correctly, and is an existing form.

    Any suggestions?
    ================================
    RAM disk is *not* an installation procedure
    ================================

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    But, is the form OPEN at the time of the time check???? If not open, you'll get this type of error. What process/form is calling/invoking this function?
    Back to Access ... ADO is not the way to go for speed ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •