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

    Unanswered: existing form/field

    Here's my code:
    Function Timerz()
    Dim time_now
    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
    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