|
many types of absences
Hi all! Access 2003.
I need suggestions, advices and/or tips to solve a problem raises during the
design phase of my DB. this DB will be used to manage human resources in a
farm. All employees can go on vacation (and it is enough natural) but they
can use several types of benefits like short absence (1 day to recovered in
the future), holidays (a different amount of days used all in one t...
|
3 |
12/31/2008 4:30:00 PM |
|
|
unable to "share" database
I have an aceess 2000 database being viewed in Access 2003 (can't change DB
to 2003 as not all users have 2003). When the database is opened by one user
(2003 Version) then other user (also 2003) can open the DB but can't make any
additions or changes to the database.
It is set up as a shared with the parameter set to "open databases with
record level locking" but default record lockin...
|
2 |
12/31/2008 5:08:09 AM |
|
|
Database Design
Hi, I wonder if anyone can help. I am trying to create a bowls pairs league
database. At the moment I have 6 tables, league, fixture, game detail, team
names, players names & score which are linked in relationships league (can
have many fixtures), fixtures (can have many game details). The league table
consist of league ID (primary key) & league. The fixture table consist of
fixture ID (...
|
2 |
12/30/2008 8:02:26 PM |
|
|
Table Design
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 schedule table to the Country table via the CountryID field. My
problem: The Coun...
|
6 |
12/30/2008 6:59:45 PM |
|
|
Call Management Database Access 2007
Hello Everyone,
I have spent time online doing training and have just finished Oreilly's
Missing Manual for Access 2007. While I am better now than when I started I
am still stumped on what I think should be a very simple DB.
I am an account manager for an insurane company. Basically a travelling
salesperson for all intents and purposes. I need a database that I can input
all my dail...
|
12 |
12/30/2008 6:06:01 PM |
|
|
Keeping A Diary/Appointments in Access DB
I am writing an app in C# which keeps my diary appointments in an Access
12 DB. Accessing one off appointments is fine but I have to do a lot of
calculations in respect of repeat appointments.
If I have a weekly appointment that started on 1 Jan 2002 and I want to
find out if it should be displayed today I loop through the record adding
7 to the start date until the date is => than...
|
7 |
12/30/2008 6:04:08 PM |
|
|
CONSTRAINT [pk_SwitchboardItems]
Helllo:
In the table structure of the following, can anyone explain what is the
meaning of :
CONSTRAINT [pk_SwitchboardItems]?
CREATE TABLE [Switchboard Items] (
[SwitchboardID] LONG NOT NULL,
[ItemNumber] SMALLINT NOT NULL,
[Language] TEXT(50) NOT NULL,
[ItemText] TEXT(255) NOT NULL,
[Command] SMALLINT,
[Argument] TEXT(255) ,
CONSTRAINT [pk_SwitchboardItems]
PRIMARY KEY (...
|
2 |
12/30/2008 9:30:51 AM |
|
|
table redesign
i thought i posted this yesterday, but i can't find the post, sorry if this
is repetitive.
i have a table for tree demography info. each record has a tag id, census
date, stage, and size. there are 1700 trees and 5100 records. instead of
having multiple records with a unique key for each, i want the tree tag id to
be the key. i know this runs counter to the idea of a key, but it's easie...
|
4 |
12/30/2008 2:23:24 AM |
|
|
Employee Hours Database
I need to design database that tracks employee hours. What I need to be able
to do is input an employees daily hours week by week and get the total hours
at the end of the week. How could I go about doing this.
Jon...
|
4 |
12/30/2008 1:17:31 AM |
|
|
Pulling records based of another tables, column
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 unique, have one record per row and Audit is not unique.
Here are the columns and r...
|
3 |
12/29/2008 11:26:56 PM |
|
|
Cannot view postings
Hi all,
This is very strange. I posted a question few days ago about "Table
Design". I got the email notice that I had a response, but when I log into
the forum, I cannot see my post or the response(s). I tried to search for it
by "Table Design" but I cannot see any. All I saw were postings date back
all the way to 12-23-2008. I switched between Firefox and IE, but none
worked.
...
|
2 |
12/29/2008 8:32:05 PM |
|
|
Forum moderator, help...lI can't see my post thread
Hello forum moderator,
I got a email notification for response to my post, but unfortunate for some
reason I cannot see my post or the responses to my post. I got an email
notification that I have response to my post, but I can't see them when I
click the link. In fact I cannot even see my post.
Can the forum moderator please help?
Thanks,
Ben
http://www.microsoft.com/wn3/a...
|
3 |
12/29/2008 7:53:01 PM |
|
|
Table design
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 head, there can be multiple
departments within each division.
3.Within each departm...
|
5 |
12/29/2008 7:52:01 PM |
|
|
ATTN: Ben who asked for the forum moderator: there is no such person
>Hello forum moderator,
>
>I got a email notification for response to my post, but unfortunate for some
>reason I cannot see my post or the responses to my post. I got an email
>notification that I have response to my post, but I can't see them when I
>click the link. In fact I cannot even see my post.
>
>Can the forum moderator please help?
>
>Thanks,
...
|
2 |
12/29/2008 7:31:10 PM |
|
|
custom numbering which resets when new year is entered
Hello,
I would like to assign sequencial numbers to invoices (YYYY/sequecial
number), where YYYY - year:
2008/1
2008/2
2008/...
but when a new year is entered I want the sequencial number to be reset
automatically:
2009/1
2009/2
2009/...
I don't want to use Autonumer to keep numbering consistent in case data
entry is cancelled.
Do I have to store the custom numbering in a...
|
9 |
12/29/2008 1:56:51 PM |
|
|
set ALOWEDIT property to "YES"
i have set AllowEdith property in my form as "No", now i want to change it to
"Yes" again, how should i do this...
|
2 |
12/28/2008 3:27:52 PM |
|
|
organization and keys
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
(how it is identified in the field) as its key, so to speak. i understand
keys...
|
5 |
12/28/2008 1:19:56 PM |
|
|
auto field update
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...
|
4 |
12/27/2008 6:30:25 PM |
|
|
Add 7 days to last record date?
Hello,
I am still a novice at database design so maybe this will be easy. I
would like the default value for my date column to continually increase by
seven days. It is a schedule and the date value needs to be every Monday....
|
5 |
12/25/2008 11:35:00 PM |
|
|
Timesheet design help
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)
EmployeeID (fk)
Date (always the first day of year)
BeginningSickTime
BeginningAppro...
|
2 |
12/25/2008 2:33:46 PM |
|
|
Help will pulling records based of another table
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 unique, have one record per row and Audit is not unique.
Here are the columns and r...
|
2 |
12/25/2008 2:26:18 PM |
|
|
Need to eliminate the [form name] in access2003 application title
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
please and thank you
san diego cal
--
Joe Sr...
|
2 |
12/25/2008 2:24:50 PM |
|
|
Recursive Table
I need to store and retrive hierarchial data. The data represents categories
for a product catalog that can have an undetermind number of subcategories. i
andt to use a recursive table but am not sure if that's right. I have the
recursive idea down but my problem is finding the lowest level category so i
can store it in a new product reecord without knowing that it is lowest level
becaus...
|
5 |
12/25/2008 11:54:52 AM |
|
|
Expression Question
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
answer 1 = 3 points
answer 2 = 2 points
Total Points
Is there a way to ...
|
2 |
12/24/2008 6:58:56 PM |
|
|
E-mail links to Outlook in Access fields
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 to a
hyperlink, but it took me to the web instead.
Any suggestions would be m...
|
2 |
12/24/2008 5:10:39 PM |