I have a database that calculates property assessments for individuals.  I
have a report that prints out the payment schedule for the number of years
the property is assessed, but it the report show the number of year beyond
the number specified.  If they are assessed for 15 ...

Greetings Board:
How can a tabular form be filtered by date.
This is what I have tried:
I made a tabular form that is linked to my "customer visits" table.

How can i close a DB (.ldb), so i can open with editing rights?

I am trying to automate the import of a spreadsheet into a database I am
creating.  I am brand new to VBA, and am trying very hard to learn enough to
acomplish this task.  I have found how to use the transferspreadsheet method
to automate the import, however, the file name and ...

I don't think this one is complexe, I've just never had to do it.
I have to genearate a sequential number.  As such, I use DMAX to determine
the greatest value in the table and then add 1 to it.  Nothing Complexe!  
However, where I need help is with the fact that right now I get ...

I am using the following code to attempt to send an email message.
   Set MailObj = CreateObject("CDO.Message")
   MailObj.To = "mikeshipp@aol.com"
   MailObj.From = "mlyst@contracosta.courts.ca.gov"

I am trying to use rs.recordset to get the number of records in my table
Dim db As Database
Dim rs As Recordset
Set db = OpenDatabase("my database path")

We have a large DB with multiple users (20). The DB regularly gets corrupted
and needs repairing. I want to track the cause of the corruption, the last
table and entry made etc to try to eliminate the problems. Is there a way of
doing this?

I am using the ReportToPDF in Access 2007.  It has been working fine,
however, today I am attempting to generate large reports and the ReportTOPDF
code seems to time out in the middle of generating the snap reports… at about
page 55.  Any ideas on how to extend the timeout?  Some ...

I have a table that I'm refreshing from an ADO recordset which comes from an
Oracle database.
I want a total refresh on the table... doesn't matter to me whether the
records are deleted, or the table dropped and recreated (though I've read

I have the following:
Form1:    
ItemID (autonumber)
Item (combo)

I would like to create a list of dates based on a date range.
If my date range is 03-01-08 to 03-10-08, I would like to create a query
that will show me the dates individually.
So, the new data set would be each date listed individually. (03-01, 03-02,

First of all, how do I look up "#VALUE!" in this group? I enclose it in
quotes and return hundreds of "Value" threads which I then have to work
through in vain to find the #VALUE! threads I'm looking for.
Now, to my specific problem. I have 2 queries which I transfer to an excel

I have a query based on criteria entered in a form. I want to be able
to enter the criteria then press a button to create an email which is
blind copied to all customers in the query result.
Here's the code which I've used:

Hello.
I'm new to Access and VBA. I have set up a table called "Customer Visits"
Then I have a query when ran will return every record in "Customer Visits".
My next step was to make a Parent/Child Form that would allow me to chose a