Using a combo box on an Access form, I use seperate forms to add a new record
to the table that my query is based on or edit a record, changing the text of
the combo box to the new value.  when I do this and try to move to another
control, the Not In List event always fires, even ...

I have the following control source in a subform.  This works fine for
multiplying quantity of an item with price and any discount.
=nz([intQuantity],0)*(nz([txtprice],0)*(1-nz([dbldiscountpercent],0)))
however, when I try to sum these in the subform footer, by adding sum(

   Somebody can send for me examples  INSERT, UPDATE, DELETE  using ADO
with fields  Date, Number , String
Thank in Advance

I have a data input form that has several fields.  Some of the fields are
combo boxes.  One particular combo box limits a number of check boxes that
are displayed.  I need a search form that looks very similar to the data
input form.  The user should be able to input as many fields ...

When I move with code a Access Tabcontrol (Register, Pages control), the
controls on it are not moved with it. I must first move all controls to new
position, then the Tabcontrol, that is uncomfortable.
Is there any tip? Where is wrong?

excess 2003/ need a document 1 page( 20 employees down 31 days across with
note space)

How do I turn on Auto Complete. I want Access to automatically fill or
suggest the name I am entering from previously entered names in the field in
previous records.

I am using tep by step 2002 and they tell me to input this funcion in the
data control source of the ext box, however, when I write the expression as
it is written  Access displays a message saying
The expression you entered contains invalid syntax

Please let me know how can I connect access data with excel data?

I have tried to build a tabbed main form with 2 subforms without success.
When ever I try to access the subform, I get an error message stating the
jet engine can't locate the associated record... something like that. The
bottom line, is I cant get it to work. Any help on would be ...

Is it possible to display both an embedded picture and the caption
underneathe for a command button? I can only seem to have one or the other
displaying. Please help.
thanks in advance. Samantha

I have a date field on my form call lastupdate. I was wondering if it's
possible when any data on the form is updated/changed, the lastupdate field
will changed to the current date? Thanks for your help.
Regards,

Hi all
I'm try in to create a query to display data entered on a weekly basis
What expression is used in the Criteria field.  Can anyone help
--

I am trying to insert a line break.  I have a button that the user clicks and
then the text goes into Outlook.  What is happening is that all of the text
is running together.  Does the Chr(10) & Chr(13) work in Outlook?
Private Sub Command29_Click()

I use a Tab Control form  as the main switchboard in one of my mdbs (Access
2002 on XP, networked).
I want to create a new Tab such that, when clicked, a new Tab Control form
opens and fills the full screen.