var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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)
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
I attached the database as well.