I have an Access 2000 database (although using the 2003 app) that has several
tables (one table per remote office) linked by the date field (using basic
referential integrity, no cascading updates nor deletes).  I created a form
that pulls the data from all these tables and then ...

I have a query with reference to 2 tables.  This query is used to input data
in a form.  There are 4 pieces of data supplied by one table (Employees) and
all else is inputed to the form.  When I close the form, the 4 pieces of data
from the 1 table is not saved.  The data is ...

I have a combo box (DesignJobSize) wich the row source type is set to Value
list and the row source is "XS";"S";"M";"L";"XL".  What code can I add to the
After Udated event to update the HrsAllocated field.  I want that field to
show "2" if the XS is selected from the combo box, ...

I want to create a form to track what employees are working on what area of a
specific project.  Project is usually 3 or 4 days long, but the same employee
may work on a different dept on different days.  Also, the first day may need
5 employees, but the next 2 days may only need ...

I apologize that this is probably a really easy solution but it is Friday the
13th and my brain is not working.  I am also new to Access.  
I have a Command Button in my form that Starts a new record.  When I click
on it, I would like to have a specific field (Company Name) to be ...

I'm using a listview control to show the filenames in my templates folder.
Is there a way to get the standard icon (eg for word, excel, pdf files etc)
to appear beside each filename?
TIA

How can I play a sound when I open a form with out using code.
Thanks,
Cage

It’s probably very simple thing, but I can’t find it out:
I have following calculation as control source in the “Completed Date” field.
=IIf([Status]="Comp-Completed",Date(),"")
It’s updating the date when the status is changing.

I have a form with a subform. I want to change the subform from a datasheet
view to a single or continuous form. When I do this the background of the
form has a sandstone format and for some reason I can't change it. I have
gone into the form and changed the background color. ...

I want to make a form/subform that can be used across clinical
trials.  The form container for the subform won't change.  However,
the columns of the sub-form will change based on records in a table.
I have a table of subjects with unique identifiers.  I have a table of

I seem to remember that when inserting a hyperlink into a field in Access
2000, it was stored in UNC format, no matter if the user navigated through
the network or via mapped drive letters.  In Access 2003 the hyperlink is
stored as a mapped as a drive letter if the user ...

How do i create an audit table or history table where transactions of
people login will be tracked?

how do i insert watermark to my form

I am trying to create an expression to calculate annual leave entitlements
for staff, based on the following premises.
1) If the staff member has completed less than (but not equal to) five years
service, the annual leave entitlement (a) will be

I am really new to VBA, currently I have one form were I create meetings,
than another one were the individual is inputted (all works great - this is
not the problem).  I am trying to open a form(Travel) from that form by
clicking on a button (This I already have and that part ...