I want to attach a single database form to an email, im not sure if this is
possible,

I have a Form and Subform, I want to have a textbox on the Main Form that
counts the records  in the subform. I don not want to count all records, just
some, based on a criteria.
Is this possible?

I am working with a form that has some client-specific fields.  Client X has
three bound controls, a,b and c.  Client Y has two bound controls, e and f.  
Right now, I show or hide the controls with an OnCurrent event.  
If Me.txtClient = "X" Then

I have a database, I use for ordering uniform and keeping a check on
employees allocation.
The company we use to supply the uniform have changed their pricing structure,
which is causing me a few problems.

To show an expression
Example..
([LOANPROGRAM] <> 'CONSTRUCTION') AND ([PROPTYPE] IN (2010,2020,2040))
This is suppose to say that the Loan Program = construction and if 2010,

I am modifying an existing employee database which has a Notes field (text
box).  I want to add a second notes field called ArchivedNotes to the form
(as a list box).  I will place a button next the the first notes field
(current notes) so that when the info there is no longer ...

Is it possible to use an input box to search for existing records in a form
with an autonumber field? Here's setup:
Form "fRecords" has autonumber field "RecordNumber" and also has a label
"lblSearch" when clicked prompts for input box to "Enter Record Number" to

OK, this should be easy, but here goes:
I have an Access 2002 application with a link to a SQL 2000 table. I've
created a query based on the table, and created a continuous form based on
the query. What is the best way to count the number of records returned? On

I am in need of assistance once again.  Duane Hookom assisted in a major way
the first time around but I have just found another error.  I have a form
which creates a report.  The user can input: Date, Thru Date, Name, Event
Type & FMLA.  Duane helped me with the code so that it ...

"It's me again Margaret!"
Alright..  You give these people something good and they want more.  I have
been asked about using a Calendar on a form opposed to a Text Box for date
input.  Now, the form loads the current date and runs a query that displays

When I enter criteria (a for example) and hit the filter button that I
created on the form, a message box displays, Run-Time Error ‘2448’:  You
can’t assign a value to this object.
When I Debug the code (I tried the Debug.Print cmd),   ([TOOL NO]) Like

I have an application where I want to keep a series of notes using a
text field in a table just for these notes. My primary key across the
application is ID_Number, I need this table to have a structure like
this:

I have a sub form which is continuous, this works fine except as more than
one record can be seen at the same time, it looks quite busy, I would like
every other record to be one colour and the records in between these to be
another color, how can I format the continuous form to ...

I have 3 tables.
Stock
Accesoires
and a table to link them as a record in stock can have multiple accesoires.

I am working with an inventory system, and would like to have a for
that shows all products and their current inventory levels, and next t
each of them  have a textbox for entering in new inventory levels. I
this possible somehow? I can't seem to so it with continuous forms. I