I have some code in the on_current event of a bounded form.  The on_current
event fires off when a record is deleted and the cursor position is still on
the deleted record.  Is there an equivalent to "me.form.NewRecord" that I
can determine if a delete is active in the on_current ...

I have a form with a combo box that lists applicants names.  If you enter
an applicant not in the box a msg box pops up to add the applicant.  The
add applicant form opens and you can update the applicants name address,
etc.  When this form closes, the combo box is repopulated with ...

I have a main form on which I have  tab control with about 10 pages
in order to test and rerquery on page changes i put the following code
Private Sub TabCtl5_Change()
   Select Case Me!TabCtl5

I am using Access 2000
I asked this question last Friday, but can not find my
question now.  So here I go again.  I want to create a
form in which I have two fields - "EmpID" and "Name".  I

I am using Access 2000
I have a field that enters the date automatically - using
Date().  This date changes every day.  But I want a
permanent date - a Date that does not change from the date

I'd like to enable a user to find a file and link it in a text field so that
for each record it has a link to a unique document that the user sets. For
example, each press release we send out, we want to attach a link to it so we
can refer to it.

Hope someone can help me here.
I have data on central SQL Server - and using Access 2003 as front end via
ODBC. I have a form with a subform datasheet that adds items up in the
subform based on a condition e.g. =sum(iif(X,[Number],0), that sums the field

My form has 3 bound fields, 2 text boxes for data entry and a list box to
make a selection.  For the last week i've been playing around with different
code snippets trying to learn a bit about what you all do.  I had some code
that did not allow the user to go to another field ...

My database menu does not always show up completely on users' machines.  The
menu titles are cut off so that the users can't read the entire thing.  I
have checked the screen resolution and we all have the same setting.
Is this a problem with the monitors?  I have an HP monitor ...

I am running a form on a dot matrix printer.  When the form prints it goes on
past the actual length of the form to a full size page. How can I set the
length that it actually feeds after printer to the actual size of the form?

I have a subform within a form (linked by a common customer ID) that has a
series of combo boxes.
The first set of combo boxes has a list of vendors, the second set of combo
boxes has list of products.  The combo boxes are controlled so that only the

I am using Access 2000.  I put an option group on my form that with the
control source a y/n field.  When I click in the circle for yes, the table
field is updated but the circle is not filled in on the form so both the yes
and no field are white.  How can I get this to fill in ...

I am using Access 2000
I created a form (with a DB view) to search for certain
records.  I designed the form to have field 1, field 2,
field 3.  But the form comes up in a different format,

I have designed a database by using the Switchboard Manager.  On my main menu
screen, I have a button called "Modify Information" and another one called
"Input New Information."  I have a two questions that relate to how the forms
will be used.

Any suggestions on this? Does Access destroy the underlying recordset when
the last record is deleted?  All controls dissappear including the close
button!
Thanks.