Suggestions for table or query to track movement
Mon, 7 Jun 2010 13:06:22 -0700
I have a table for employees that includes the usual description fields for
employees. This is one of my master tables with the employee ID being the
primary key. Then I have another table that stores all employee hours that I
add on to monthly via an import from Excel (emplID is foreign key). I want
to k ...
|
database strange behavior
Mon, 7 Jun 2010 07:25:01 -0700
I do not know if it was already posted !!!
Hi to all,
I am wondering if some of you MVP can shed some light on this strange
behavior.
I have develop a database FE/BE and trnasfer old data from a legacy Access97
db. Everything was working just fine until this past monday.
I am starting getting error 3044 .. ...
|
i have a good 'schema, where do i go from here?
Sun, 06 Jun 2010 10:23:33 GMT
Hi, I have used this and many other forums to develop what i believe is a
good table layout and have established my relevant relationships between the
tables.
My knowledge of Access is limited (i have built DB's but a long time ago).
I am now trying to build the second phase of my database, the queries.
My DB i ...
|
Linking two tables - a bit different
Fri, 4 Jun 2010 13:48:04 -0700
I understand how I need to link two tables in general. However, I have a bit
different situation.
I have two tables, an Employee table and an EmployeeLocation table (1 to
Many). In the Employee table I have an EmployeeID (primary key) and a
LocationID field. The employee may, over time, change locations. ...
|
Core Competency Assessment
Fri, 4 Jun 2010 12:55:36 -0700
I have been tasked with assisting our Employee Training and Development
Division with developing a core competency assessment instrument were
employees can self assess and be assessed by peers, colleagues or direct
reports. Once the assessments have been completed, we want to generate a
report with charts, ...
|
Help needed with table design/layout for newbie
Fri, 04 Jun 2010 18:20:53 GMT
Hi, i have just joined the forum and have built a few DB's in the past but
found i have forgotten almost everything!
I do remember with a previous DB i layed the tables out incorrectly which
impacted on the flexibility down the line so would like advise before i start
in order to get a good foundation.
My dB is ...
|
Confused over new db
Fri, 4 Jun 2010 10:40:17 -0700
I am in the process of creating a db for a project, I have been given several
forms (paper forms that folks will be using to ask patients questions) that
need to be created which is whats confusing me. I know how to create access
forms, but I'm confused on how I should build my tables.
I know I will have a ...
|
|
|
"You attempted to open a database that is already opened exlcusivl
Thu, 3 Jun 2010 15:33:55 -0700
Two days ago I deployed a split 2003 access database that is accessed by 20
users. Since going live with it I have noticed many people having trouble
with hanging or crashing of the front end. When I try to open the back end I
get the message "You attempted to open a database that is already opened
exlcusive ...
|
Making 2 colums into one
Thu, 03 Jun 2010 21:03:32 GMT
I have an excel file that I imported into Access. There are 5 fields.
Item 1-5
The item names are in column 1 and column 3. I need to combine the two
columns in to just one column. Can this be done?
Thanks for your help and reply.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/F ...
|
db design to calculate overlap in group membership in time
Thu, 03 Jun 2010 15:32:04 GMT
Hi all,
I am a biologist studying the social structure of birds. I am currently
brainstorming ideas for constructing a database that will allow me to easily
calculate the number of seconds that one bird is in the same group as another
bird. Because group membership changes frequently with birds arriving and
d ...
|
