Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004
    Posts
    19

    Unanswered: InputBox - Placing a count of record inside inputbox.. help thanks

    I have an input box and in that input box i want to add some additional information..

    I wanted a count of records to show my many records there were before the user inputed information..
    I created a query "query2" field "Countofrecords" - which has the count of records i want to display inside my inputbox

    my stmt so far..

    result = InputBox("Enter Number of Employees to Test" & vbCrLf & vbLf & "No. of Employees: " )

    how would I add the Countofrecords field to my input box..

    which should look like this..

    No. of Employees: 458

    thanks

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    simplest is DCOUNT()

    myCount = DCOUNT(fill in the blanks - see help)
    result = InputBox("Enter Number of Employees to Test" & vbCrLf & vbLf & "No. of Employees: " & myCount)

    izy
    currently using SS 2008R2

  3. #3
    Join Date
    Jun 2004
    Posts
    19
    Thanks! I will look into that

  4. #4
    Join Date
    Jun 2004
    Posts
    19
    work like a charm... thanks izzy!

Posting Permissions

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