chewy SuperNintendo Chalmers Local time Today, 14:53 Joined Mar 8, 2002 Messages 581 Apr 15, 2003 #1 I have a query(qryMain) that is based on a form(frmMain). I want, on another form (frmDate) to be able to click a button and have it give me the count of the number of records in the query.
I have a query(qryMain) that is based on a form(frmMain). I want, on another form (frmDate) to be able to click a button and have it give me the count of the number of records in the query.
Mile-O Back once again... Local time Today, 14:53 Joined Dec 10, 2002 Messages 11,305 Apr 15, 2003 #2 =DCount("[YourField]", "qryMain")
chewy SuperNintendo Chalmers Local time Today, 14:53 Joined Mar 8, 2002 Messages 581 Apr 15, 2003 #3 Thanks! The return of my favorite Avatar!
chewy SuperNintendo Chalmers Local time Today, 14:53 Joined Mar 8, 2002 Messages 581 Apr 15, 2003 #4 one more question. Is there a VB code to tab over. Like vbCrLf wil bring you to a new line. I know C++ has one.
one more question. Is there a VB code to tab over. Like vbCrLf wil bring you to a new line. I know C++ has one.
ghudson Registered User. Local time Today, 09:53 Joined Jun 8, 2002 Messages 6,193 Apr 15, 2003 #5 vbTab Check the help files for Miscellaneous Constants. HTH
chewy SuperNintendo Chalmers Local time Today, 14:53 Joined Mar 8, 2002 Messages 581 Apr 15, 2003 #6 Hey thanks! And thanks for the link