I have a report which displays 50 months data. Each month's slot may have to
be filled in with a given color depending on various date ranges, thus making
a kind of horizontal bar chart. I have set up controls M1 thru M50 for this
purpose. Now I am coding a routine to populate ...

I had a list of checks and will like to move the items from one table will
all the checks to another table with the cashed checks for reconciliation
purposes.  It could be using a check box or a command bottom to update.
Help me please !

I have a form with 2 combo boxes in header afterupdate of 2nd combobox I
would like the query that first combo is based on to run so data shown in
first combo box is updated
I think I need to use requery but can't get it to work

The following code works to find a last name in a combo box, then jumps to
the last name and other information within the form.  When there is a
duplicate last name in the combo box, it will only jump to one entry/name.  
Other information is unique, only the last name is the same ...

I have a form that uses a multiselect listbox as criteria for a query based
on the user selection(s).  I would like to add another multiselect listbox to
the form so the user can make multiple selections in eithor, or both
listboxes for the query.  

Morning All,
I have a 'Team Change Database' that is used to process amendments to thew
staffing data we hold. On previous forms that i have built i linked the form
to the table using control sources. But i have found that this sometimes

I was having a record nav problem when going to a record based on a selection
in a combo.  From an earlier post I found my problem was corrupted indexes.
I did the repair process for fixing the corrupted tables in code.  This
solved my problem imediately.  

Can anyone tell me what is wrong with this bit of code.? (I hope it's
pasted OK). I get an error message saying Run-time error '3061'"Too few
parameters. Expected 1"
strAssetType = CurrentDb.OpenRecordset("SELECT LU_assetTypes.type" & _

When I run the following code I get a "Run-time error 3061. Too few
parameters. Expected 1":
strAssetType = CurrentDb.OpenRecordset("SELECT LU_assetTypes.type" & _
" FROM LU_assetTypes WHERE LU_assetType.assetTypeID = " &

I am trying to navigate through records on a form w/a combo box.
I have this code running in the combo box.
   Dim rs As Object
   FilterOn = False

I am trying to use the DCount function:
If DCount("*", "qryName") = 0 Then
   MsgBox "Query returns no records"
End If

Right... the relevant tables are
quote_Mai
quote_Conten
quote_Section

I am attempting to use a SQL query within a function to return a value of the
number of records meeting the conditions of the query.  I have been
(successfully) up to this point using the SQL view on the Access query
builder to construct the SQL query for use in the function.

Does anyone know how put a Carriage Return or Line Feed into a textbox.  I
have a SQL statement that gets a series of records and I am trying to format
when I display them in a text box.  Right now it displays one big paragraph
and I would like to force CR or LF after certain ...

I would like to know how to accomplish the following two things:
1: Automaticall run the update query when a value changes in an associated
field.
2: When a mailing list is run, the ID is printed instead of the actual word.