I have one application that runs all day, it never needs to be closed until
the end of the day, it is an app that monitors for connections to a series
of databases, what its purpose is, it warns the other user that a reboot or
shutdown is about to happen to the server and after ...

I have some code on a form that runs for the "On Not in List" Event.  When
the code runs, I get the error msg: "Object variable or With block variable
not set".  Essentially, what the code does is as follows:
If a user tries to enter a new product that is not currently part of our

I'm attempting to write an "If...Then" statement and am encountering a
syntax error.
In the AfterUpdate property for the field "STATE," I am writing a code that
will automatically populate the field "DISTRICT."  The districts are

Hi. I'm sure this one will be simple. I have an On Open event (see below) in
Form called frmSetImage that's designed to check a field value and stop the
form opening if there is content in the field. I've got as far as showing a
message but when I click on the MsgBox OK button, the ...

I am trying to use the following code, which works fine when in its own
database, but when I import it into the actual database I get this compile
error message Sub or function not defined. It then puts a yellow arrow next
to private & highligt it & puts the words BrowseFolder in ...

I want to give user a prompt(inputBox) to input value of a field nam
of table
Private Sub form_open(Cancel As Integer)
On Error GoTo Err_Form_Open

Im having trouble with a cascading combo set up. It works OK but when the
requery runs after the first combo is used, any previous settings made in the
second combo disappear. Im using Access 2002 on XP.
Here is the detail. I have a main form called frmSECStudents and a subform

I have two forms bound to different tables.  I will use an example to
illustrate my problem.
I have 4 people who have each sent me 5 documents. I do not currently know
the identity of these 4 people so I can not create a lookup table. In the

Hi!  I'm trying to add phone # to Outlook Contact and it works good except
with phone # format is "123-4567".     Many different ph# format works fine
(like (999)666-8888, x1234 etc.,)
Error example: Business  (323243) 123-4567

I want to automatically trigger an event when a particular time has been
reached or elapsed.  Your help will be greatly appreciated. Thanks.

I can't figure out how to use the FindRecord command.
I have read about it in Microsoft Access Help, but it does not give any
examples.
I have a form based on a table (tblSAR).  While the user is already on the

My Afterupdate event doesn't fire since I'm inserting a value into the combo
field programatically.  After researching the archives, I see that the
suggestion is to call the event using code similar to this:
- Forms!frmNameofForm.NameofControl_Nameofevent (with or without the key

I have a form consisting of a list box and a command button. On pressing the
button, I want a report to show a list of records (the Recordsource is a
view), but only those where the value of one particular field is that same as
the one selected in the list box in the form.

I created a module titled "modSendEmail" as shown below. I tried to call it
in a command button using "txtSendEmail_Click" but it returns an error
"Object is required". What I've done wrong.  Thanks in advance.
Public Sub txtSendEmail_Click()

How can I assign unique username and password for users in a network
accessing my MS-Access 2000 database.
Any help will be appreciated
Thanks