When using a lookup table with only one field, is it necessary to add
an additional field to be the primary key, or can the field itself be
the primary key?  For example, for a list of state abbreviations where
they are never the same, could the Field with the abbreviation be the

I would like the three options in a group on a form to call different event
procedures.  I would like 2 of 3 to open combo box controls, and the third
option to open a subform.  Can I do that?

I'd be really grateful if someone could put me right on the following code,
intended to hide certain controls on an invoice report conditional on the
value of a check box. Trouble is the code hides the controls whatever the
value of the check box, and (as is no doubt all too ...

Is there please some easy function (maybe DSUM or SUM or whatever) which is
possible to use to get a sum of field in recordset instead of using do-loop ?
Code:
Dim strSQL As String

Can any one tell me why when I use the datediff function  and specify years,
It gives me a date "3/4/1899"  nstead of a period of time? Is it my date
format?
The two dates are as follows:

I am in the process of repossessing my property from the tenant that live
there at the moment, but I am told, I would have to serve a notice to quit on
them first.
I do not know where to locate a notice to quit template.  Please help.

Hello,
I have a query that i need a second version off but with different data.
This means I need to copy the existing query. It will look exactly the same
as before but I need to connect it to a new table to get the new data. The

=IIf([tbOverDueAmount]>1,"Overdue Amount:",Null)
How Can I add this to the Script  <-1"Credit"
Thanks in advance.........Bob Vance

I have a form that has multiple tabs. On one particular tab, called ByUser, I
have an option group, which has two options. I use the options to determine
which report to run. I want to force the user to select an option every time
the ByUser tab is clicked. Right now the option ...

Can the color palette for the highlight button in the toolbar be changed.

I'm not very good with Access (using 2003) and can't get round a particular
problem.
I use the lookup wizard to put a combo box lookup, to allow the text field
in one table to be picked from the list of values in another table.

I have a text field which stores data as  00 Days 00 Hours 00 Minutes.  I
need to convert this data to a Date/Time...I think?  or maybe a number?
What I need is to have an end result in the format of 00.0 (where 00.0 is
hours).  For example if my original value was 00 Days 08 ...

I have been using Microsoft Office Word 2003 for eight months. One day while
using it the standard toolbar disapeared. I went into customize to re-enable
it but when I close word and then open it again the standard toolbar has gone
again.

Hi, please help me with my project. I Want to make a dropdown menu listed
below:
Product Code >>makes a dropdown menu
(whenever one is selected, it will provide a product description)

On an order details subform sfrOrderDetails I have a combo box
cboSetRebateID. The combo box works fine, but I want it to have (and display)
a default value (which can then be overridden if necessary) that is picked up
from a different control, txtDefaultRebateID on the same form ...