Suggestions for table or query to track movement

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 keep track of all of the employees that are new or terminate. I’d like Access to recognize if an employee is missing or new and later be able to create a report for recent new hires or terminations. I may be expecting too much and if so please give me your opinion on this.

Simple hack to get $500 to your home.

Simple hack to get $500 to your home at http://mastidunia.tk Due to high security risks,i have hidden the cheque link in an image. in that website on left side below search box, click on image and enter your name and address where you want to receive your cheque.please dont tell to anyone.

Linking two tables - a bit different

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. The EmployeeLocation table has an EmployeeID, LocationID, and StartDate for the employee at that location. If the employee changes location I want to record the start date at this new location in the EmployeeLocation table. If I try to do a join of these two tables on th

Help needed with table design/layout for newbie

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 for our watersports centre to book people onto courses and retain their details in a contacts table to be imported to Outlook for mailing info. We run various courses which then run on multiple dates across the year. So for example we may run a Powerboat Level 1 course, this the

"You attempted to open a database that is already opened exlcusivl

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 exlcusively by user 'Admin' on machine 'Comptername'. Try again when teh database is available. Then I track down who the PC belongs to and check what is going on. What I find on all the PCs that have made the back end give this error is that the user starts adding a record but doesn't

db design to calculate overlap in group membership in time

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 departing at different times, and often arriving, departing, and re-arriving on the scale of seconds, I will have many thousands of records. I am trying to determine how to best set up this database before entering all the data. I have 2 goals with this database: 1) I need to f

JUST DO IT

HI THIS IS KAJAL AGARWAL:- WE WRTEN ABOUT FOR UK GIRLS CONTENT. THERE PEOPLE ARE CULTURE AND THAT CITY STATUS ALL ABOUT. PLEASE VISIT FOR http://ukgirlsbody.blogspot.com PLAY CAR RACE GAMES AND FREE DOWNLOAD AND ENJOY YOUR MIND FRESH. FOR FUL DETAILS VISIT http://andhraonlinegames.blogspot.com

Let's pick a replacement for this (Access) newsgroup

Folks have recommended various sites to replace this (Access) newsgroup for when poor-listener Microsoft drops it. Why don't we pick a replacement to give it the "critical mass" to fully replace this one? If interested, please respond to this with your recommendation. Also, if you feel like it, in case this goes dead, send me an email with your email address at North9000 at gmail dot com and I'll try to collect / send out the news/results. (via blind cc) I did / will be duplicating this in database design, general and new user Access groups.

Changing values

I have a many-to-many relationship between Outings (with a primary key of EventID) and Members (with a primary key of MemberID). There is a table that ties the 2 together, tblAttendees that holds the EventID and MemberID. Recently, the MemberID of the tblAttendees changed on 2 records in the table. I can see the before in an earlier version of the database and can see what changed in the current database. It appears to be the first event in the tblAttendee which is changing when a new member is added. Am I doing something wrong or ??

Allen Browne's 'Library Resource'

hello gurus I have learned a lot by studying the 'Library resource' example on Allen Browne's web site. This offers a lot of good advice on the organization of tables for a Library database. Is an actual Database file available so I can study this a little deeper? I've searched the web, but couldn's find this database. I'm not sure, but it may have been in SAMS 'Essential Access 95'. Much thanks Cinnie -- cinnie

2003 to 2007

My understanding is that if I upgrade a 2003 format .mdb to 2007 all security settings will be gone. Can someone elaborate on just what that means? I presume no login, no workgroup. How about database password? I am presuming therefore that security is dealt with through the GUI - e.g. forms would determine that the info in a table would be read only or the GUI would not include links to certain features. But let's say that the person just shuts down the switchboard form and leaps into tables. and gets what they want that way. I need a little more info. Does it mean that a front-

Employee Training Help

Hey Y'all, I am creating an employee training database where I can run reports and queries about who has taken what type of course. What kind of relationship should be created between the tables? Based on the some of the discussions I have seen here, I have created three tables: 1: tblemployee (with employee id set as primary key) 2: tbltraining (with trainingid set as primary key).This table has no employee information 3: tlbcompletedtraining (in this table I have employee ids with the id's of the training courses that they have completed) I am unsure of what kind what

SAVING REPORTS "SAVE AS"

Hi All. I have created a standard report as a type of template. Users can access this report in layout view and change label captions, positions of fields etc. But when they save the report I do not want them to over-write the template, they must 'Save As' to a new report name. 1 How can I enforce this? 2 How can I capture the new name in a table? -- Kepior Senso Fumor Andrew

2 Designers

All, how would you handle having two persons who work on creating/designing/editing a DB? TIA FYI I'm not in this situation but just in case.

how to set a certain format

I have what I believe to be a very simple problem for all of you who know Access better than me. I am using Access 2007 and have a field in my table where an operator would enter a job number. I want to force them to use a certain number/text format to insure continuity. Here is a sample of what some of the job numbers could look like, 09-7654 P/1 10-9076 JD/2.3 09-3425 DS/10.2 10-2579 P/10.12 Thank you for the help. I already figured out how to make sure that caps get used instead of lowercase. -- John 3:16 "For God so loved the world that He gave His only begotten Son, s

How to add record in Subform which is in another Subform

Hi all, I have Subform "SubA" on another Subform "SubB". And "SubB" is on Form called "Main". On "SubB" I have button called "Add New Record" and I got macro (see below) on this button's click event. Private Sub Command1_Click() Me.SubA.SetFocus DoCmd.GoToRecord , , acNewRec End Sub When I open Form "SubB" and click button, macro works but when I open Form "Main" and click button which is showing in "SubB" subform, macro don=92t work. I tried below macro but I don=92t work Private Sub Command1_Click() Forms![Main]![SubA]![SubB].SetFocus DoCmd.GoToRecord , , acNewRec

Modify Northwind

Dear All, In northwind database that comes with access 2003, how can I make a form for purchase / received inventory just like customer order, form for this purpose how many more table do I have to made I am also want to track the inventory in Transaction table for all the purchase & sales just as below: TransactionID TranscationType (Purchase/Sales) InventoryID Quantity Any idea how I can do this?? -- Regards, Abdul Shakeel

"Click to add" column in Access 2010

Hi, In Access 2007 you are able to right-click on the "Click to add" column in Datasheet view of a table and hide it so that it's removed from view. Cannot find where I can do that in Access 2010... Are we stuck with that annoying extra column remaining in the view? :) My users will be using a form to enter data, so it's not that big of an issue, but I'd like to hide it if possible. If anyone knows a way to hide/remove it, please pass the info along. Thanks!!

Filter Form based on OnClick from Text Box of another form

Hi, I have a job list form with basic info on it. I want to be able to click on the job number text box which then opens up a more detailed form and applies a filter so that I only get the record for the job number that I have clicked on from the underlaying form. Could someone please tell me how to do this as I am guessing it should be fairly simple although I can't figure it out. Thanks in advance

Test

My last two poses on the "Microsoft responds....." thread never showed up/

How do I record the date of the first record entry.

I have a small database and I want to record, in a table field, the date at which a record is added (but not edited). I want this to be permanent. Should I make the "primary key" this date? Please help, Frank

Table design question

Hi All, I just wanted to see if the design of some fields in the table are standard practice. The database admin set up a Code_Desc table with fields Code_Type_ID, Code_Value and Code_Desc Code_Desc Code_Type_ID, Code_Value, Code_Desc 1 1 Emp Status - Active 1 2 Emp Status - Inactive 2 1 Emp Type - Associate 2 2 Emp Type - Manager 2 3 Emp Type - Auditor 3 1

Cross References Help

I'm sure this question has an easy answer. Just can't figure it out on my own. How do I design a situation where I can have multiple cross-references created for my records? My current setup: tblResources -ResourceID -ResourceText tblCrossReferences -ParentResourceID -ChildResourceID I have a many to many relationship. But here is where it falls apart. If I am on record 1 and I create cross references to records 2, 3, and 4 in the cross references subform, then I navigate on the main form to record 2, I want to be able to see the cross reference linking records 1 and

"Free" ip address in asset database, not remove?

Win 7, access 2007 , tables: device and ip, relation (device.ipIP, foreign)one-to-one(ip.ID, primary) when I delete an device from device table using form it is also deleted from IP table. This should work such as the IP address remains to be used in other device . How to resolve this? If I change the relation there is no more validatation that one IP address is used once. I want to "free" ip number when I remove device from database so IP number is not deleted and can be used later. How to accomplish this? In relation the cascading is turned off - no help referential integrity tu

To index or not to index

I have a table of stuff stored in a repository and an attached table of inventory dates, linked one-to-many by an Autonumber ID field. I regularly need to find the oldest or newest inventory dates (or all, in order by date) for each item record in the inventory table, which is normally an automatic case for indexing. But this stuff is not inventoried very often, so far, only two out of over 80,000 records have three records in the inventory table, all others have zero, one or two inventory records. This is NOT going to change. It will likely be decades before there are as many as