I have an employee information form that has a yes/no checkbox for the
employee to be an administrator.  There must always be at least 1
administrator or they will not be able to login to the options section(which
is where the employee form link is located).  What would you put ...

I have two cascading drop down menus.  In the second dropdown I have a where
in the carrierid section ("[Forms].[PackageInfo].[cboCarrier]"). It works
nicely, however I have noticed that when I have more than one record saved
the dropdown menu does not show the correct value(the ...

Thanks for all of your previous help!
I don't know if this is even possible to do, but here is my question:
I have created a backup procedure that cycles through and backs up any
user-created tables.  I would like to have a msgbox pop up that shows the

Is there a way to install Microsoft SQL from the Microsoft Office XP
Professional CD? If so, where is it located?
Any assistance is greatly appreciated.

I am trying to create a dlookup statement based on the values from forms. If
I hardcode the following statement with the values it works fine:
dlookup("PatientID", "Cases", "CaseID = 2 AND StaffName = 'Administrator'")
The problem comes when I try to refer to an open form for the ...

I have an SQL statement that deletes rows from a table. When the close form
code runs the user is asked for confirmation of deletions. I would like the
rows to be deleted without prompting the user for a response. My code
currently is:

I developed an application that uses a touch screen. The mouse/cursor is
never used. Can I hide the Cursor on startup of this application? or at least
park it out of the way?

I have a continuos form that the user can update i want to have a 'save
changes' and a 'cancel changes' button on the form
The Me.Undo command only undoes the changes made to the current record
How do I set up a 'cancel changes' button to undo changes to several records

From my company form in access, I'm looking to create an outlook contact
each time that data is entered. Can someone point me in the right direction
so that i could do this?
Thanks!

I have a 100 toggle boxes on the form. I have it programmed that when you
select a box, it goes to a public sub that looks at whether there is a record
in a table, and either creates a record or changes it. This works fine, I
like it. However, if the record DOESN'T need to be ...

Hi there! Using A02 on XP. Have mdb file in multiuser
environment. Have a mainform showing all contracts and
their info. Have a subform to key in records for
distributions from the contracts. Once in a while I am

Is is possible to somehow get an assosiated lable to a bound control where
the property Locked = True  to be displayed with Etched style?
The lable will get Etched style if the control Locked property = False and
property Enable = False. But I?d like to have two controls on my ...

I want to put my own navigation buttons on my form and enable / disable the
previous and next record buttons if the user is already at either end of the
recordset.  I have everything working correctly except for the initial record
that is shown when the form opens.  I have the ...

Ok, I have virtually no experience with Access 2000, so
I'm flying by the seat of my pants here.  Any help would
be greatly appreciated.  I'm running Access 2000 on Win
XP, and my email program is Outlook XP:

Is it possible to put some code in the database's "unload event" (is there a
such thing) that could run like a failsafe?  i.e. One key event that would
trigger the user being properly logged off, or any other appropriate closing
procedure?