Another problem I have with combo boxes and MSAccess wizard produced code is
that when selecting (accidentaly) an item from the combo that has been
previously deleted I get an error Run Time Error 13 Type missmatch. How do
you test for deleted items?

Lets say I have 3 file..... ABF.doc, ABF Contacts.doc, and ABF Tasks.doc
They are all on the C:\
I open a form in Access
I put a combo box and a button in the form.

I have a Microsoft Acess 2003 database which has a form, ExamFrm, whose
record source is a table, StudentTbl (PK = StudentID), and a sub form
ExamSubform (continuous forms), whose record source is a table, ExamTbl
(PK = ExamID).

I have 2 tables - Customer and Customer Contacts.  There are often more than
one contact per customer.  I want to create a form to enter new contacts.  I
have the two tables set up in a query and I am thinking that I will use a
list box for the user to select which customer they ...

I am trying to use the Upsizing Wizard to upload a database to SQL server but
when it is uploaded the subforms show no records.  It shos the column names
but nothing underneath where the records would be.  What do I do to fix this.

I have a problem.  I have a basic form with 10 text boxes to enter data to
run a query.  My problem is how do I get the query to ignore the fields that
are blank without bring back all data int he table
thanks for you help

I have a form that I want users to only be able to Edit the selected
records--no Deletions orAdditions.  I have the form AllowEdits propert set to
Yes, and the AllowDeletions and AllowAdditions properties set to No.
When I have records displayed with this form, I can still delete ...

I have a database that contains a form with a sub form in it.   I am wanting
two employees to be able to work on and with this database on two different
computers at the same time, while any changes one makes on their computer is
kept up to date with the other's.  Is there any ...

In a form, I can use the Ctrl+' (control+apostrophe) to duplicate the data
from the same field on the previously entered record.  Are there any
shortcuts to duplicate the entire record and then change the 1 field I want
to be different?

Can the criteria of  Dlookup compose of two fields.
How can we write the syntax.
I tried
CQ = DLookup("[QTc]", "Stockinventorylog",

"PROMO_START_DATE" (looks like 7/14/2005) is used to create another field
called "MONTH" in my forms, queries, and reports.  I have "MONTH" displayed
as a 3-letters using the "mmm" format.  Problem is boss wants everything
capitalized for reporting.  How do I get "Jul" to appear ...

I have two forms that I'm opening up in Hidden mode.  There is a text box in
the footer of each form that uses the Count expression to count the number of
values in the detail section of each form.  I want the app to take one action
if the values are different, and another action if ...

I am using Dev Ashish's function for opening a file with its default
application (http://www.mvps.org/access/api/api0018.htm) and was wondering
if there is a way to detect when the operatio has completed, that is when
the user closes the application.

Well, after an initial review of my database by my client, they have
completely changed their minds about how they want their form.  As a
result, I'm having to re-think the whole process.
My Current Form (6 tabs):

 I have a continous form that displays upcomming orders by date...  Is
there a way to section the orders by date?  EX:  There are two orders comming
in on the 7th and 4 on the 8th.  I want a line inbetween them...
Ernst.