I currently have combo box in which agents select their own ID when they are
completing a quote.
THey also have their own log ins and I was wondering if it was possible to
set this combo box default value to the current user.

i have a crosstab query and a Form, when I run the query through the
Form it populating
Run-time error '3126'
Invalid bracketing of name  '[Forms][frmMainForm]![Date]'

i have a form with a subform attached. actually the subform does not share
data with the same form, but is an independent table. The table on which
the subform is based is edited and records are added from another dabase
with a

I have been successful in having field 2 autopopulate based on entry in
field 1 combo box based on a query I built.  This however, is the only
time I have gotten it to work.  I have tried to do the same autopop in
a new form, checking and re-checking to make sure everything is the

I know the problem is with my Where clause but I am not sure how to fix
it. Here is the error.
Syntax error in date in query expression '([RCName]= 'Athletics' AND
[DeptName] Like '*' AND [Date Entered] Between ## and #9/22/06 >0)'.

Hello;
I am working on a Contact database to track psychiatric appointmets.  I am
new to this, so I am just learning and I need some help.  I have a subform
which has the following fields

I have two querries from one table, and each querry create different form.
In this table have autonumber, how can I create the form share the
autonumber, for example, enter data into each form, will add the data into
table follow the autonumber.

I want to open an Excel spreadsheet from an Access form using Call Shell.  
This is what I have so far:
stAppName = "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE " &
Chr(34) & "C:\Documents and Settings\worksheet 1.xls" & Chr(34)

I have a database in Oracle XE with an Access front end. It connects
successfully via ODBC without any problem. All the data is accessible but no
inserts or updates will work. I have created a new Workgroup Information File
with a default administrative user (as described in SECFAQ) ...

I have using Access for years but all of a sudden I've lost the form rulers
(white area at the top and left side of the form) as well as the box at the
top on the left that you click to select form properties.  I use several
databases and this is true on all of them.  When I ...

hi can someone help! pleease! i've created a filter for a date and a text box
that contains the phrase "no performance target" however i keep getting an
error saying 'data mismatch' 'syntax error' how can i fix this?
If Me.ch_exercised = -1 And Me.ch_pt = -1 Then

Is it possible to change the level of transparency of a command button? I
would like to set some to about 50% transpasency so that both the button and
whatever is underneath can be seen.
tia

I have a table with many fields (columns). I want to compare 3 rows. The best
way to do that is to have the 3 rows in columns and then all the field values
as rows.
Is there an easy way of transposing the normal table view to this other

I have the following code which gives me my stock quantity ....
Function Onhand(itemCode As Variant, Optional vAsOfDate As Variant) As Long
   'Purpose:   Return the quantity-on-hand for a product.
   'Arguments: vProductID = the product to report on.

I have a table that I have based a form on.  This form is used to update and
add information to the table.  There are three number fields in the form
(from the table).  Field 1 and Field 2 are for entering numbers, Field 3 is
to add the first two fields and return the sum in ...