Results 1 to 1 of 1
  1. #1
    Join Date
    Apr 2004
    Posts
    3

    Unanswered: Data Access Page, background code

    I have the following code that works in a form, but I need to have work on a Data Access Page, the DCount does not work, anyone know an alternative? (Departments is a table and Password is a field)

    Dim intChkPword
    strPassword
    strPassword = InputBox "Enter the Department Password you recieved:"
    intChkPword = DCount("*", "Departments", "[Password] = '" & strPassword & "'")
    If intChkPword = 0 Then
    MsgBox prompt:="Invalid Entry"
    DoCmd.OpenReport "Permit", , , "[Permit ID]=" & Me.txtPermitID
    End If

    I attached the database as well.
    Attached Files Attached Files

Posting Permissions

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