how to create a passwoard to a tab page, example, I have 5 tab pages, I would
like to keep page 4 in private, have to have passwoard to view fields...any
idea, thanks

Can anyone tell me how to code my command button to reset textbox values to
blank after it has completed updates to tables?
Many thanks in advance and kind regards, Nick

Hello and thanks in advance....
Does anybody know if there is a way to change the background color of the
'unused' space on a datasheet form?  I have a datasheet subform and would
like this color to match the color of the main form, rather than the dark

I have an order form with an Order Number and some Customer Information and
use a subform enableing input of each line item.  The line item has item
number, price and weight.
I would like to keep a running total of the price and weight on the main

I have an employee profile form that I would like to filter by what
location the employee works out of.
The location is already determined based on a login I have in the
beginning. The location value is stored in a Query (call it query1).

I use this code to check for no records in the before update event to prevent
the forms from trying to validate a blank record.
If Me.RecordsetClone.RecordCount = 0 Then 'don't try to validate empty record
        GoTo CCExit

I would like to create an R&D database with the following:
I want to create a Tests table, PartNumbers table, PartNumberTests table and
a Results table.
We will enter tests in the tests table, and part numbers in the PartNumbers

I have sub form and master form
the data sheet sub form contain this data
serial     roomtype        GName
1            DBL                ahsdkl

My question is which is better to use if I want to enable/disable controls
on the form based on the value of another control on the form.
I know I should probably know this, but....
TIA for the help

I have an excel file that takes a while to load. I'd like to have a form open
that has code top open this file at 7 AM. Task Scheduler for windows won't
work. Anyone have a code they would suggest?

1. What is the maximum number of items that can be listed in a combo box?
2. What is the maximum number of items that can be listed in a list box?
3. If one needs more that the max, what does one do?
Thanks much in advance.

All of a sudden a clients comobo boxes dont display the first colum (happens
to be the ID). We dont know of anything fundementally changing over the
weekend.
Other ocmbo boxes work! So the only thing we can get to is a more complex

I have what may be a very simple question.  Unfortunately, I haven't worked
in Access in several years and am now lost!
I am "updating" someone else's database - from a very simple level to one
designed to make life easier.

I'm using the "JustifyString" function (from Stephan Lebans) to right
justify three columns in a ListBox.  Two of them are working fine ... one's
a simple number (long integer) and the other's currency.  The third causes
an Access 2003 crash!

I have a mdb on the server. when a user click on the shortcut to the mdb
they get an annoying security warning message.
Is there any way to suppress this message?