I have a form based on a query for data entry.  When you use the query for
data entry all the calculations update as you enter.  When you use the form
all the calculated fields just show error until you exit the form and go back
in.  How can you make the form update the ...

We currently using a continous form to for Palm Census for our
research data - On the form , there is a Trial Number (to be
entered),Plot Number, Date, Palm Number and the Status (selected from
combo)

I have a search form where values entered become the criteria for a query.  I
have several checkboxes on the form.  The default value is Null, so that when
the user does not check/uncheck the box, the query searches for either value.
My problem is that the checkbox does not appear ...

I have a form that is filled out by customer service with information such as
item number.  When the QA department reviews this information they use a
command button to open the QA issues form which is a different table.
Question I would like fields such as the item number etc to ...

I am trying to multiply two fields that are in a different table and show the
result in my orders form.
The first Table is called Orders and has the following fields:
Customer ID

   I am working with Access 2000 . I have a listbox with 2 columns .  The
first column is populated from a query. I want to take the values in the
first column and do a query with each item and enter the result in the second
column . The listbox is lstNames with 2 columns . How do ...

I have a mainform displaying individual info. I have a subform (form view) on
the main form that displays info for assets. I have a subform (datasheet
View) within that subform that references the same data but only has  year
and Asset name -in other words a list of assets. I ...

I have a form opened and I want to open a second form (while the first form
remains open) that is based on the same table. When trying to open the second
form, I get an error message that says:
The table 'Patients' is already opened exclusively by another user, or it is

When we recently upgraded from Project 98 to Project 2000, some the
predecessors in our templates no longer worked correctly. Worked fine in P98.
Any suggestions on how to correct? Thanks.
P.S. If it makes any difference, some of us have Internet Explorer 6, and

In a form control I would like to display the date and time in this format
without seconds:
mm/dd/yy hh:mm PM
However, general date and time does include the seconds.  Is there a way to

You were kind eniough to respond to a question I posted, one which many
others have askied in other ways in other places and not received answers. It
boils down to generating a simple 4 digit number - for PO Order numbers,
Invoice numbers and so on. My visit to the Church of ...

I have created a simple combo box with two values, yes or no.  The drop list
displays yes and no, but when you select one of those values it displays in
the record as 0 or -1.  How do I format it to show the words?  (I'm using
Access 2000)

Good Day,
I have been charged with converting a group Access97 db to an Access 2003db.
But before completely converting over to the Access 2003 db I would like to
ensure that most of the functionality of Access97 is working properly in

I have a continuous sub form, based on a table Actionlog that is used as an
Action Log. There are 4 controls
Action Log - text
Timedate - based on Time/Date field of same name

Please! I need help with this ASAP!