Ihave built many networked datases and have always used the technique of
splitting the data tables placing them on a mapped drive and providing each
user with a frontend that links to the data tables.
However we have a client that has a client/server network installed on one

I have a form that tracks vacation hours accrued and taken. The Fields are
as follows:
Week    Period End Date    Accrued Hours    Hours Taken    Balance
1            12/26/07                3.08                        0.0

I would like to have a field be mulitplied by a set number and that number be
stored in another field, for example:
We copy medical records and charge a .75 cents per page.  What I would like
to do is that when the number of copies is entered into field it will be

Created an employee database with the following tables:
Employee Info
Haz Mat Training Records
Safety Training Records

I am a new user of Access. I am not sure this is a right question.
Assume I have two tabels
        Jan    Feb    Mar    Apr    May    Jun
Table 1    Budget    98    98    56    45    879    99

I have a text field in a report named NumberRating and I want it to provide
the average rating of all the records displayed.  If I use the command
=Avg([NumberRating]) in the Control Source and set the Format = Fixed and
Decimal Places = 0, I get the appropriate results.  For ...

I have observed this problem on three different machines, with three
different applications.  I have come to the conclusion that it must be
something about the computer itself.  The problem is not related to the
number of users.  I have one user who opens that database and if ...

this for my own practice, not for profit. I have run into this situation a
couple times and never known hot to go about it
OK, I have 3 fields: date, time start and duration (or could be time end)
How can do I go about making it so that these fields can't overlap or  have

 I have been getting “#Delete” in every field between ID 1541 and 1542 in
my Table. I can delete the line by selecting the deleting it, and ACCESS even
asks me if I'm sure I want to delete it. The problem is this; It deletes’,
but when I close the table it comes back (same line) ...

Sorry I've been away so long, people, but I've been immersed in Web
2.0. These newsgroup posts take too long to open and read, so here's
some quick-fire answers based on the titles alone:
Q. Very basic ADO VB code on a Form

I have an unbound text box, on a subform, which is located on a tab. I
have been unable to make the source of this text box return any data.
I have tried DLookup from a query:
=Dlookup("AOH","[Amt Query]","productID="& Me.productID)

I am taking over an old application in Access 2003 which has reached 2GB in
size.
When the user tried to compress the database, he got an error message.
I converted the database to Access 2007 and now the size shows 2,096,160KB.

HI.. i need help on solving one big problem i can't get the solution..
I have a query that gets some values and also a month text from one table..
based on a form parameters.. What i want to do is to add/create a column on
the query and make that column depend on the text of ...

I have a column named Admin in a query, it's values are either "0", ".5" or
values > .5
In the expression I would like to return the "0" as "0", and if the value is

Hi hayley barker can u send an email ?