Not sure if i'm posting in the right spot so sorry if its not, please
direct me to the correct location :)
I have three fields in a form, [quote accepted], [days to results] and
[target date]. I need to calculate the target date by adding the [quote

I have a subform (SubFrmA) on a main form (FormA).  I have a combo box on
the subform.  In the Not In List property of the combo box I have an Event
Procedure which advises the user that the selection they've just made is not
in the list, and would they like to update the table ...

I have a TABLE, called coursesection  I have fields in that table
called SCHEDULENO, COURSEID, SECTIONNO, FACULTYID
I want to write a select statement that will display the SCHEDULENO,
COURSEID, SECTIONNO  for the FACULTY ID that is currently being

Does anyone know how to force the form to use "auto recall" to speed up data
entry?  What I'm talking about is when you type in the first letter and a
suggested word pops up and as you add letters the word suggested changes
until it's the correct one or it learns the one you are ...

I'm not for sure if I will explain this well enough to understand but I will
try.  
I am making a sewer bypass record database.  I have many bypasses, each
bypass has many details. One of the details is Mitigation Steps.  There are 3

I have an Unbound Main Form and a SubForm - using the subform for data entry.
The SuBForm Default view is 'Datasheet view'.
The MainForm contains all the static data for each record created in the
subform (ie., Date, Ref.No. etc).  

hello everybody... I urgently need an answer to this question: I use the
now() fuction but I need it to write only in medium date format. All the
textboxes are formatted in medium date and also the table. But when I use
now() in the table everything is stored with

OK Say I have a table called COURSESECTIONS  that lists schedule
numbers of courses and also facultyID's.  I then have a form called
FACULTY.  On this form, I want to display the courses that the current
faculty member teaches.

     How is it possible to protect data fields in forms so that if a user
wishes to alter a field with data he or she is prompted "Do You Really Want
to Do This?". I understand that the fields should be Locked initially but it
is how to automate the Unlocking and Locking once ...

I have a form with Header and Footer sections.  I click a button in the
Footer section and want to set focus to the Detail section.  But I want
the focus to go back to the control that had focus prior to when the
button was clicked.  I don't want to use the LostFocus event on every

How can I set a form so that only additions to the table can be made, and
only one record (the current one) shows?
IOW, the form will be used for entering data only.
Thx.

I am using Access 2000 and I want to alternate row colors in a form or table.
I know very little about using Access.  I tried copying the code from
Stephan Lebans example http://www.lebans.com/alternatecolordetailsection.htm 
but I could not get it to work.  I would appreciate ...

I'm using the "Order Entry" template supplied with Access.
I rearranged the fields on one of the forms, so the Tab Stop settings were
disrupted. I attempted to re-configure these Tab Stops with no luck. See the
screen shot below:

Hi all!  What I am doing is this:
I have a combo box named:  cboBridge and it is a drop-down to a list of 5
bridges. In the table Bridges I have ID, Bridge and Height.  I have set up my
row source with the SQL.  Also, I have Column Count set to 2, and my Column

How can you do this in Access VBA code?