Dcount to Currentuser

  • Thread starter Thread starter adriany
  • Start date Start date
A

adriany

i have print button with Dcount below to count how many
records a current user input data for if/then statment.

intStore = DCount("[IndexID]", "table1", "[userID] =
CurrentUser")

if crrentuser input 3 data and prints
i just want users to see, YOU HAVE 3(intstore) TO PRINT.

but, i get 0 everytime
 
Try something along the lines of
intStore = DCount("[IndexID]", "table1", "[userID] = '" &
CurrentUser() & "'")

Hope This Helps
Gerald Stanley MCSD
 
thks
-----Original Message-----
Try something along the lines of
intStore = DCount("[IndexID]", "table1", "[userID] = '" &
CurrentUser() & "'")

Hope This Helps
Gerald Stanley MCSD
-----Original Message-----
i have print button with Dcount below to count how many
records a current user input data for if/then statment.

intStore = DCount("[IndexID]", "table1", "[userID] =
CurrentUser")

if crrentuser input 3 data and prints
i just want users to see, YOU HAVE 3(intstore) TO PRINT.

but, i get 0 everytime
.
Click to expand...
.
Click to expand...
 
Back
Top