Ive got a combo box that contains around 800 items, when you type in the
list it takes ages to process each key press.  At the moment this list box
is filled in using AddItem from VB as i have a small subset of data, then a
dividing line ('-------') and then all the items.  Is ...

Help I need to find a way of merging values from the same field in different
records.
I have a list of suppliers who supply different products, I have a table for
Suppliers details and a table with suppliers names and the main products they

I have a tabbed form within a tabbed form.  On one of the tabs, I have a
sub-form.  I'd like to know the syntax to be used for printing a report based
on the data displayed in the form.
This is what I've done -

I need to enter data into a database as quickly as possible for an auction.
I have names and addresses from the people who signed up for  buyer numbers
the year before.  I need to set up an auto fill from the 2004 table for those
people who are buyers in 2005 to save time I would ...

I have a form where I enter deposits.
There are 10 fields to add up (Deposit Amounts)
Cust1   Thru   Cust9    Plus  a single Cash Deposit  named   Cash
Cust1

I want to add a toggle button to my form that when the button is depressed,
all fields on that record are locked.  But when the toggle button is NOT
depressed, all the fields on that specific record are editable (i.e. will not
affect other records).  

After upgrade my outlook to 2003 and MS Access to 2003, my
command Sendobject use in MS Access 2000 is no longer work.
Any one know what is setup require to change in outlook so
the DoCmd.Sendobject command from MS ACCESS  will call the

I hope I'll be able to explain clearly my problem.
I have a form with subforms, each of which lists a certain type of
references met in the record of the form. For example: An article ABC (record
1 of main form) refers to Indonesia. I will input Indonesia in the subform

I tried this code in a module and called it on the onclick event of a
command button on my form to open the Main form with my sub-from on it.
If the control NameB IsNull , then I want to sub-from to be invisible, else
visible.

If I wanted to be able to press the escape key and the active form to then
close what would you suggest I do?
Any help greatfuly received!
Simon

I have a field on a form that has 2 values: General Public or Media.   I have
a combo box that lists all callers. It is populated from tblCallers.  One of
the fields in the tblCallers is a true/false field entitled "Media".  If
General Public is selected, then the combo box ...

I want to hide the sub-form until there is data in a control on the main
form.
Main form is TimeCards  and sub-form is  Time and Hours
Control on main form is NameB

Is there any way to have both an icon and text on a command button? I've
looked around, yet haven't found any text on the topic. Any thoughts?
Thanks!
Evan M

The form collecting data and store them in a records on the table
I would like to prevent (just after typing word in form field) sending
existing (in other records) text to the new record (text formatted field)
I would be thankfull for any ideas

I have 3 Pages (Tabs) on my form. If i am on page 2 or page 3 and click on
ANY command buton,  after executing the code, the focus goes to page 1. My
command butons do not say to go to page1. I have to go back and forth to
click on caommands on pase 2 and 3. what do i have to do ...