I have an Access 97 database used in our software that has two tables in it
and I can’t see either of them so I can’t modify the data. I checked and they
aren’t marked as hidden or as a system object. I also checked the permissions
and I am opening the database as Admin. The ...

I have a database that keeps track of discipline.  In a table Infractions,
there is a field Consequence.  The consequences are based on the number of
demerits (one of three types of demerits).  The consequences up to this point
are being entered manually.  Every two weeks ...

I'm having problems setting up a database to calculate production averages. I
want to be able to enter date of payroll ie. 3/4/2004 in field payroll
ending. I want to enter production rate, ie. 49 in Production Rate Field. I
will average two payroll ending fields to get March ...

I have an Employee database design I have been working on -
tblEmp -Emp_Id links the following tables:
tblFulltime - Emp_Id, Position_Id
tblParttime- Emp_Id, Position_Id

Trying to develop a database that will track employee attendance.  I have a
form that  has dropdowns, and a rolodex to select employees.  I would like to
insert a subform to track sickdays.  The subform would have to be linked to
the employee selected from the dropdown.  So as a ...

In a FORM, I can have combo box 1 limit the results in combo box 2, but how
can I do this in a TABLE? For example, I have three tables: "Terminal_Info",
"Die_Info", "Terminal_Setup". In "Terminal_Setup", I have fields:
"ParentPart", "Terminal", "Die".  The "Terminal" field has a ...

I have several fields I want to populate by using #s and then have the
associated label populate the field. How do I set this up? Thanks for any
advice.

I have thousands of scanned iamges associated with a *.doc or *.tif.  I have
the file names held in a table with their full directory associations.  I
want to be able to click on the file that I want and have it open.  How do I
do that?

I am a novice Access user and want to have a field in my database number up
sequentially using the month number then 001 and on.
For example,
1001

I've been tasked with organizing legal files for a corporate office.  I
believe that Access should provide me with the best way to organize, and
ulitmately display the data.  Still, try as I might, I can't get a setup that
I like.  If you have suggestions to help me get control ...

I inherited a database at work that has (oddly enough) too many tables.  All
30+ of the tables have the exact same design.  How can I merge them into one
new or existing table?

I have started the design for a new project where financial advisors can
store the customer info.
The problem is , there have to be stored about 100> different information
for each

Hello Anyone,
I finally figured out how to chang the optiongroup number to a text string in my form.  Now, could someone tell me how to create a control source for the field in a table so that when I generate a report I don't have to do an update query to make the change?  Thanks.

I am designing my own patient record database.  I have a form for entering
patient data.  The table from this form has a one to many relationship to a
table for patient treatment episodes.  When I am entering data in the
treatment form I want to be able to see data from the ...

I have an application that needs to track commissions. Each salesperson can
sell different products that each have a certain bonus amount assigned to
them.
OK, that part is no problem. The caveat is that if the salespeople sell