I have code to prevent duplicate entries placed behind the before update of
a text box.  This code works when I have a field in a table with datatype of
text.  I am trying this code with a field of data type numbers, but cant get
it to work.  Its suposed to alert me when a ...

Error Text:
This action can't be carried out while processing a form or report event.
Code:
rivate Sub Command2_Enter()

I get a runtime error '6'
   overflow
when I run an append query.
Any ideals as to what is causing this?

I am trying to make a list of all controls on a form which are empty.  The
reason is obviously to ensure all required fields are filled before adding
the record.  I would like to list all the empty fields into a message box to
alert the user what is still required to be filled.  ...

Hell all!
How to round a time into 15 minutes period for example
--------------------------
Now is:   |  After rounding

I have most of a custom wizard working and can use unbound text boxes on a
startup form to help me keep track of things for my next button.
However even though I can get the back button to go back to the previous
form and close the existing form, I can not get the back button to ...

using Access2000
How can I useVB code to add a new text field to a linked table?

Hello out there!
I have a continuous form that displays a number of rows and a total at the
bottom. There are times that I want to use this form for display purposed
only, and other times that I want to allow the user to enter a number in a

You can specify in Outlook, the default template and style etc when starting
a new message. But, when Access sends a message body string with SendObject
the default email template is ignored/overwritten.
Is there a way of preserving the email package default template/style whens

I am new to Access.I am trying to acheive the following.
I have a table in a database which needs to be cleaned, by which, I mean I
have to check if the values entered in the fields is right or wrong.
So I created a form and coded the same with the appropriate values in them.

hello all,
This should be even simpler than it sounds but its not working! I want to
see if there comboboxes on the form are empty or not, there is a set of combo
boxes that exist across several forms and i want to test if they are empty or

in my a2k app'n, i have a form (Audit Reports), the 'main form', on which
there are two child/sub-forms, 'Evaluations' and 'Patients'. for now, i would
like to create a command button on the Audit Reports form which will add a
new/blank record into the table ('IRB') behind it. ...

I have created a combo box in a form that is built from a table. The table
contains 2 fields- an ID(PK) and the course status text which is Passing,
Marginal or Failing.
The combo box works fine in the form, but in the table and report, the

I have a continuous subform with an option group in the header.  There is no
default for the group.  I want the user to select one of the choices.  When
the user
selects one of the options, the detail section of the subform becomes

I have a form which is opened from another form.
In the form open event I set the rowsource for the listbox - this works fine.
When you click on a button to edit details (opens another unbound form which
changes the original data) and return to the said form I cannot get the