how do create a combo box to allow
the user to type in keywords that is connected to a memo field within a
query?  could u show me an example of one that works... using the strwhere
statement, but how is the combo setup, and its property fields?

I can provide totals of values in reports easy enough. How do I provide a
total in the footer of a form that is the total of a field for all the
records shown?
Thanks,

Hello, I need to have a text box that show a single line when is view in the
form then if I click on it or move the mouse over it will show multiple lines
with it's data, sample:
client: john doe   "single line"

I created a Ship Date field in a Table, created form using the ship date
field, wanted the field to display current date using date (), but the date
does not save back to the table.
Thanks for the help

I want to display appointments, to-do's etc in a monthly type calendar on an
access form. Thanks

This is a follow-up to a question dated 2/11/2008 titled "Medium Time text
box shows year".  My data was downloaded, maybe from SQLServer???, to Access
2003. I can display a date/time field on a form just fine using Medium Time
format.  But as soon as the field gets focus ...

In the UserId ( primary key) box , I would like to start typing an ID and
have it  appear in the UserId box (like a combo box?); after choosing the
correct ID, I would like the name, address, etc. to populate atomatically. If
there is no previous entry for my User ID, I will need ...

I created a query with two parameters. Example,
Like [Enter Cust Name]
Like [Enter Part number]
which works fine, but users have to enter the cust name then click ok then

On a subform, I have a textbox that sums a column. I don't display it, just
reference it.
When the subform recordset is empty, it propogates "#error" to all the text
boxes that reference it. How do I get it to calculate out to a zero or null

In an old Db3 application, the Client info was entered in one table. When we
opened the first form to begin data entry, upon entering the Client ID, a
message would pop up showing the name and address of the Client, with the
question, Is this the correct client? We checked yes ...

I need one of those phased calculations where the second part of a percent
calc only comes in above a certain value. Is there a mathematic function
that will ignore any number until it becomes positive so that I can simply
use (x - y), rather than iif or something similar?

I have a query in which I set the criteria of a field to the value of a combo
box on my form.
On the form, the combo box has three values
A

I'm stuck.  Trying to create a toggle button on a form that will enter a
specific value into a field on a table when clicked.  
Example:  Field on table is automobile makers.  I want a click on the toggle
button (captioned as FORD) on the form to record Ford.  I

Not sure whether this is query or form related hence the post to both NG's.
Hope this is ok.
I think what I am doing is pretty basic. I have a subform that lists the
components of a product. The query on which the subform is based calculates

I need some help here.  I have used the MS Office Template “Orders
Management” and made some minor changes to the tables.  I am having some
problems with my calculation fields.  My order subtotal box gets the
following error msg: “#Name?”.  In my order total box I get the ...