I have a multiuser query that prompts the user for criteria (sorry I do not
know the technical terms).
Is there a way that I can set this up where the user can type in part of the
criteria and it return with all fields that have that part in it?

This group has been amazing, so I hope I am not going to the well too often.  
But here it goes.
When I click a button, I want another field to change color.  There are a
lot of field on the page and the button loads a file add dialog box and I

Wondering if this is possible?  I have a main form that displays Task
detail.  One of the items on this form is a List Box to assign Team
Members to Tasks.  It displays Team Members in a multi-select
fashion.  I have a separate Table to capture the one-to-manys of Task

I have a subform which lists specifications for a product. The user
enters the specification, hits enter, and the code below concentenates
the name of the spec, the value, and the prefix/suffix as required.
Multiple specs are strung together into a single memo field.

I have a call log subform that lists the Customer ID, Contact Date, Comments,
and a Projected Follow up Date.
Is there a way so that when a date is entered into the Follow Up Date column
a new record is automatically started and puts the date in the Contact Date

are there any advantages of friction and disadvantages of friction

Although there are several ways to accomplish, I am looking for a best
practice and understanding of why.
I have text boxes and combo boxes on a form.  Combo boxes will pull data
from lookup tables and user will enter new data into the text boxes.  All the

I'm beginning to build a massive database with more than 10 tables.
Currently I have 1 database with 4 tables and 1 query linking certain info
from the tables.  The  query is rather slow when the number of records go
over 1000.  Is there a way to speed this up when it opens?  ...

Is it possible to fire an event when the user clicks a custom toolbar
button?
Bob

Hi
In need to be able to open a form read only until I select a record from a
combo box
I want to keep from entering the information in the first record that comes

Hi Everebody,
I need help withe the following: I have a form that has a listbox that gets
its data through a query, the list box only show two colums: Company and
ProcessDate, also the query retrieves more fields but I set the width of the

I am using MS-Access 2003.
I have created (copied) a process, that allows me to choose the User I want.
The Combo Box, allows me to type the letters of the last name of the User
whose data I work with.

From a form, I want to be able to send a report to a PDF.  Any suggestions??

I am able to Import and Append data to my Client List Table to reflect
the new and lost clients that my company has.  The Client list table
readily accepts the appended data but the queries, forms and reports
do not show that any data has been added to the Client List Table.

I have a main form that when I enter a Company, the subforms combo box
populates with all the contacts for the selected company.  I also have a
button on the subform that allows the user to add a new contact.  When the
add form opens I need the new form to automatically enter ...