retrieving info and saving in a dfferent location

[autoIT]

I am new to the access world so please bare with me.

I am creating a new db for hr. It has a form that pulls info from a table. The info being called on includes two lookup columns for name and pay period. Other info is staic info(i.e. hours scheduled to work) other info will be supplied by the user(i.e.vaca time used etc.)

Is there a way for me to pull this info from the table to the form and save to a seperate location so not to keep overwriting the info on the table? Do I need to involve a query or two? Right now what happens is I will select John Doe pay period 10/13/06 and enter the remaining info. If I were to select John Doe 10/27/06 and change any info it will change the previous entry to the current info. This is b/c I contiue to overwrite the info on the table. Again, can I pull from one location and save to another.


Thanks
Adam

 

[dhookom]

Please share your table structure and what you are attempting to do.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[autoIT]

ok ill do my best. HR needs a db that will allow them to enter employees information on a biweekly basis so here's what I came up with.

tabele1-contains a column of employees name(approx 50)Department, payperios(a lookup column which will allow them to select a pay period), a few more columns regarding vaca hours, sick time etc.(these are mostly user input fields)

table2-has one column that is a lookup column called employees that retrieves the names from the names in table1


both tables are related by ID


frm1-will get the employee column from table2 as well as other columns from table1.

*in some attempts to achieve my goal I have used a query called qry1 that would get info from the tables and be called upon from the form. Using a query also allows me to calculate certain fields like holiday hours remaining by calculating what they started with and what was used(both user inputs)



what I need to do is extract the fields from the tables display them in a form, have the end user fill in the info for that pay period and save it somehow without overwriting the information on the tables.In other words can I have information saved into basically a blank form as it's entered. I know how to export the info as an excel spreadsheet from there. Maybe I'm choosing a very difficult way to do this and there is and easier solution?

Adam

 

[dhookom]

You need a table for "biweekly basis" with a record for each employee for each time basis. Your employee table must have a primary key field which could be an Autonumber or always unique employee code/ID. Then create a table like:

tblEmployeePayPeriod
======================
EmpPPID autonumber primary key
EmployeeID to link to your employee table primary key
PayPeriod Date field
... whatever other fields you need



Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]