I am creating a database of user equipment for the west coast.  I have a
table called WCEquip_Tbl.  The table has 9 fields that are ID, Key, Phones,
Faxes, ... ect.
The Key field is used to filter the data.

I have a DCount calculation which displays correctly when I view a form.
However when I open the main form which contains it as a subform, the
calculation field displays#Name?
What do I hae to do on the subform to get it to display the calculation

but when I use the "Or" statement, the data is no longer passed to my query.
Any suggestions.   I'm not really a programmer so simple is key.

What happened to my question????????????????????????

I have a form with a group of three option buttons. Everything is working
fine and "as expected" but I want to change the value inserted into the
table. Currently, the option group places an integer value, 1 through 3, in
the table but I want to change the value to a string. For ...

I have 5 different tables with the same fields in each table with different
data. All 5 tables are unrelated.  I created a switchboard where if a user
clicks on a button (5 buttons for the 5 separate tables), it is connected to
a form with a combo box displayng data from a field ...

I have several forms with the following code -
if me.dirty then me.undo
and it undoes any typing i've done.
my problem is - i'm creating a record in a table with an autonumber. and

Is there any way to be able to add more than 255 characters in a memo field
or something else so I can type more info for each record?

Good Morning,
  I want to use the currently entered value to prefill the next new record.
On the afterupdate event of the Text box formatted as ShortDate I have the
following code:

I have been working with Access for a number of years but grope in the dark
as far as VBA is concerned (ie, don't know a lot).
I am developing a small application for reading barcode data for our factory
shop floor. The problem I am having is with one of the forms.

I have a text field in a form that may contain 20 characters. (e.g.,
PPPPTTTUPPPTUPPTTUPP).  I need to know whow many "P" are in the field.  
Please help...
Thanks,

I have a form with Tabs on it. On each tab I put a subform.
All the subforms were created from the same table. It was
a big table and I wanted to split it up.
I put a QID on each subform. QID is question ID field.

I created a form for my staff to enter their daily productivity. However, it
appears that some of the data is not populating into the table.  I reviewed
the steps to complete the form and watched as one of my employees entered the
data.  Everything seemed right, but the info ...

In my form i have a list of orders. I have a  field called date required,
this contains the date when the order has to be ready for. In a new box i
have created, i want to include a function. The function i want to create is
that if the date required is within 3 days of the ...

Table CATEGORY
id  (pk)
CategoryName
etc...