I have a 2 date field, if I enter date e.g. 01/01/05 in one date field on
entry of 2nd date field can I have it populate 01/01/06, i.e one year
Many thanks

I have a macro to update a table.  It is manually run daily.  I think a timer
would work for this.  Can someone help me with the code to do this?  I'm very
new at getting the code to work!  I can leave the database open so that the
timer can run.

I have created a function that does a few different calculations and returns
them as an array.
Function CalculationResults() As variant
Dim nResults(2) As Double

I have a list box on a form name 'frmPersonelList' whom rowsource property
is dynamically assigned a query string. On this form there is a delete button
that basically calls a vb routine to delete a record from the table. The
routine works just fine. My problem is even after the ...

The following is a partial code that, “Total Access Analyzer” tagged for an
*Error.
Private Sub cmdSaveNew_Click()
Dim iUnitCount As Integer, x As Integer

I am trying to find all emails that's subject contains a predefined String
but All I keep getting are Errors.
I have found several options through MSDN but neither seem to work, they are
.Restrict or myFolder.Item(string)

I have a form which i use to create data .... but i want to create a
recordset (ADO) then insert it into a table in the access database. I dont
see any way to reference a table in the current access database. Is it
possible?

I have a user who wants his team to use a save button for each record and
not have a navigation bar.  How would I code that so it goes to a new blank
record after saving?  Should I use two buttons; one for save and one for "new
record"?  

I developed my application on a very fast computer. I am concerned that when
I execute DoCmd.Quit on a form that it happens so fast it almost seems as if
Access quits first before the form closes. Should I put a timer on the event
to ensure that the form closes first and then ...

I have a subform based on a table which has each record coded as either 1, 2
or 3.   The subform displays as continuous forms.   What I would like to do
is to change the background colour of the text box in which the values are
displayed depending on whether the value is 1 2 or 3 ...

I have a .MDE file that will not load.  The OnLoad code says
' if database locked, logout user...
               If rstCCC_Security!DatabaseLocked.Value = True Then
                   MsgBox "Database Currently Locked for

I have a query - Query 1 that receives values from Form 1 as parameters. I
have another query - Query 2 that uses fields from the Query1  and Query2
also receives parameters from another form - Form2. When you invoke the Query
2 from Form 2, it sends out Msgbox-es for parameters ...

What am I doing wrong??
Private Sub COPY_RECORD_Click()
Dim MaxField As Double
DoCmd.RunSQL "INSERT INTO Lease_Inventory_Table ([Company],[State],[Status

I have a form which kicks off a query. The form has a combox where the names
are listed. I have the key hidden in the combox by setting its width to 0. I
want to reference that key (ID) in my criteria in my query and I tried adding
".Column(0)" as in [form].[formname] ...

How can you make a picture act like a button?
I have a picture on my form that I would like to have act like a button when
someone clicke on it, how can this be acomplished?