Where is the proper place in my form to add the following
Area Table  CostCodeLast3  CostCode
1000           001                   10-001
1100           001                   11-001

I am using Time and Billing form.  I would like to be able to add to the drop
down status menu which already gives me some options but I need some to cover
warranties.   How can I add an item to the drop down menu?  I am new to this.
Tks.

If Form A has been opened and the user has maximized it, how can I prevent
Form B from opening in a maximized state?

I have a table for OT(primary Key is ID  that auto numbers) that the employee
goes in to a form and enter in the hours they are available to work for the
week and that does create a good record.  The problem I am having is that if
the employee goes back in to make a change a new ...

In a form, if I have 4 text boxes and 3 of them will contain a number. How do
you get the maximum value to display in the 4th. I have tried many different
things, I can make it work for a single field in a table, but that finds the
value through all records. I just want it to ...

           I posted a question yesterday which Karl helped me, but I want
to take it further by linking the master fields to the subform where
whichever control I place a value I want it to return in the subform
accordingly.

   I have a table with date information in it, if a particular date is
within a defined range I wish to colour code the individual cell colour red.  
On the dataset view I can not find a property that allows me access to an
individual table cell to change its colour.

Hi I am a novice with MS Access. I have created a form with picklists
deriving from tables. I've also created a refresh button that some-what works
on the combox and txt fields. When I hit refresh, the data is all cleared on
the form. However, when I add to data to it without ...

Hey all....
I have a form (in continuous form view) which has a combo box for order
status.  I would like to automatically create a date whenever someone changes
the status of an order.  So, I imagine I would create a seperate table

I have a query with a Where statement.  The results of that query are used to
populate the data iand peform calculations in the next query.  If the first
query produces no results, the second does not either.  How would I tell
access to put a value of 0 in one of the fields as a ...

I have 4 controls on a form which are used for data entry.  How can I make
sure they point to a new record when I open the form?  At present, each of
the controls displays the data from the last record

I have a equipment table(EqID,Descr,location,etc)and a equipment fixed
table(JobID, empoyee, Location, EqDesc,etc) what i need to do is select in a
form from a combo box the location(already have) and select from another
combo box the equipment linked to the location filed, can ...

I want a command button to ask for a password when pushed or capture the name
of the user. If the password or the user is correct, it makes 3 other command
buttons visible (I assme using the isvisible control.) The 3 command buttons
then take the user to 3 different forms. Is ...

When ever I open this database, I get an error messages that says this.
"This file may not be safe if it contains code that was intended to harm
your computer.  Do you want to open this file or cancel the operation."
How do I find out or clean up the code that is causing this ...

Hey guys - I have a relatively straight-forward question that hopefully has a
simply answer:
I have a form based on a table (Call it Table A). Table A has alot of fields
(About 60).