I am using a DateDiff function in a query to calculated shift length.  For
example, in my query, I calculate total time worked on Sunday as:
TotalSunday: DateDiff("n",[SundayStart],[SundayEnd]).
However, if an employee works a shift that begins in the afternoon and ends

I am making a database to track employee schedules.  I am stuck on a form and
cannot get a very simply action to take place.  I based the form on a query.  
One of my fields is a look-up column of the employee's first name,last name,
and store

Probably a simple solution to this, but here goes:
I have several forms with text boxes that are currency amounts. The default
value that the user sees is $0.00. When the user clicks on it, I want the
entire text box to be highlighted, so that they can just start typing over

I have a form that has the following: 5 boxes for fiscal years and 5 boxes
for budgets for the idicated fiscal year.  i want the form to let me choose
the first year from a drop down box (got this part) then have the next five
years be auto filled (got this by doing =year+1, ...

I would like help attaching a query to a text box. Below is examples of my
tables and the query I would like to attach. The query works fine, I just
would like to attach it to a text box.  Any help would be appreciated.
I have two tables, Class and CostTable

I have a folder containing pictures, password protected by me, now I have
forgotten the password.How do I remove / change it

I would like to initiate actions based on which tab is selected on a tab
control.  How do I know which tab is clicked?
Thanks

I have been wrestling for a while with a problem, and finally have to admit
that I cannot find a solution (assuming there is one).  In a vendor database
I have decided to put phone numbers into their own table rather than having
Phone1, Phone2, etc. fields.  I have made a phone ...

I have 4 queries that I want to output to an excel file.  I want the user to
have the option to choose a file location and file name each time they output.
The transferspreadsheet works well with multiple sheets in the same workbook
but I have to define a file location and name.  I ...

I'm using the following code to display images on a form.  It works fine.  
However, If you scroll to fast through the records, access crashes.  How can
I prevent this from happening?
Thanks.

Can any one please tell me the steps that how to run an update query on
the table.
Thank You

I'm looking for a detailed book on forms and reports. Is Paul
McFedries' "Microsoft Access 2003 Forms, Reports, and Queries" good?
Any other suggestion?
Thanks in advance!

I have a cascading combo box that shows duplicate entries.  (ie. I have the
first box set up as a category and the second box w/ suppliers based on
category.  My 3rd box has supplies.  One supplier may have multiple supplies.
I only need to see the supplier once, not for every ...

I have a form with a recordsource set to a table.  One of the fields in the
table is a memo field.  I added a text box to the form and set its control
cource to be the memo field.   This data entry form works perfectly until the
memo field reaches between 2 - 3K.  The user will try ...

I have a form that links directly to my master table.  I have two
fields that I need to track/document when they were changed and the
keep the old value.  For example, if the car goes for sale on 8/19,
then sold on 8/20, I want to see that history.