ha ha a Simpsons fan! I'm Learnding!
I dont know if I can help you on that . What I created was a vacation Sick time reporting system for multiple departments.
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.
Just for anyones reference in the future the I had to run this again with a few changes to clear the file before I enter the new data into it.
Private Sub Command4_Click()
Dim answer As String
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim strSQL As String
Dim objXL As Excel.Application...
dont know if this will help you but this happened to me today. Check out this post.
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=45587&perpage=15&pagenumber=1