organization and keys
Sat, 27 Dec 2008 13:45:01 -0800
i have data concerning tree demographics: census date, stage, size, species,
tag id.
currently, the table has unique keys for each tree for each year. there are
1700 or so trees and because of multiple censuses, there are over 5100
records, each with a unique key. i want to be able to use the tree's tag id ...
|
auto field update
Sat, 27 Dec 2008 00:06:01 -0800
I tring to use the date in one field in a database to update another field in
the same database automaticly (Primary date {field 1} â?? 280 days
=secondary date {field 2}) Please break it down barny style Iâ??m new at this.
Thanks ...
|
Table design
Fri, 26 Dec 2008 12:58:00 -0800
Hi all -
I have a list of employees and I wanted to know if you can share with me how
best to design the table so that it implicitly reflects the hierarchy.
The list of employees contains employees from multiple division.
1.Each division has a division head
2.Below the division head, is a department hea ...
|
Table Design
Fri, 26 Dec 2008 11:18:00 -0800
I've created a table called country with fields: CountryID (PK), CountryName.
For each Country I've created a separate schedule table with fields:
CountryID (FK), Low, High, Base, TaxRate. There are btw 4 to 5 rows of data
for each country's shedule table. In relationship mgr, I've linked each
country's s ...
|
Need to eliminate the [form name] in access2003 application title
Wed, 24 Dec 2008 17:24:00 -0800
don't want it to show the [form name]
wreckcheck-2008-[tab:form] when i open a form in application
just want it to stay at wreckcheck-2008 which is the application name..
also, don't want it to show wreckcheck-2008-[]
just
wreckcheck-2008
it is possible, i did it couple of years ago, but i forgot
...
|
Pulling records based of another tables, column
Wed, 24 Dec 2008 12:10:01 -0800
Hello all..
I am really really in need of a help. This query of my project has hold me
back now for months. The project is to develop a database.
I have two tables, table1 and table2. Table 1 has the following columns and
rows:
ID Audit
223 2
234 3
225 1
226 2
The column ID is uni ...
|
Help will pulling records based of another table
Wed, 24 Dec 2008 12:09:01 -0800
Hello all..
I am really really in need of a help. This query of my project has hold me
back now for months. The project is to develop a database.
I have two tables, table1 and table2. Table 1 has the following columns and
rows:
ID Audit
223 2
234 3
225 1
226 2
The column ID is uni ...
|
|
|
Timesheet design help
Wed, 24 Dec 2008 10:56:00 -0800
I am having problems normalizing my database. The staticTime table is the
time that the employee receives at the begining each year and was rolled-over
from the previous year. The Time table holds all the transactions.
Employee Table
EmployeeID (pk)
EmployeeName
StaticTime Table
Autonumber (pk)
Emplo ...
|
E-mail links to Outlook in Access fields
Tue, 23 Dec 2008 20:58:00 -0800
In MS Word, if you type an email address, it becomes a link automatically. If
you click on that link, it opens Outlook with a new message, ready to create
and send.
I have a field in an Access form (Text Field) for email addresses, and I
would like to have the same functionality. I tried changing the field ...
|
Expression Question
Tue, 23 Dec 2008 20:16:01 -0800
I have a series three of drop downs on my site. Each one establishing a
criteria in a text answer. Each text answer has a scroe attached to it for
example
Question 1
answer 1 = 5 points
answer 2 = 4 points
answer 3 = 3 points
Question 2
answer 1 = 5 points
answer 2 = 4 points
Question 3
...
|
