Re: Use entire table as a record in Access?

Tech-Archive recommends: Fix windows errors by optimizing your registry

Silly me! Of course, using the Make Table Query is going to produce similar
results... It's still referring to the original table for those dates. I
guess I'm going to have to refresh the criteria for the temp table with the
new dates and append that. Currently, I'm thinking of creating a form with a
calendar add in to select the new dates and using that. I'll let you know
how it turns out!

Jaybird

"Jaybird" wrote:

Muy facil, Tina! Gracias! However, as you'd expect, the update query wants
to update all of the records in the table, not just the ones from the latest
week. I'm thinking of several solutions. Tell me which sounds more
promising...

1) Set the critera of the append query to soemthing that will limit the
records it updates... Can't think of one that will work right now.
2) Instead of appending the same table, how about updating to a temp table,
and appending to the original table each time the action is run. That way,
only the records from the previous week are modified and added to the
original table.
3) Suggestions I haven't thought of?

Thanks again...

Jaybird

"tina" wrote:

just create an Append query to append all the necessary records to
tblEmpHours. then run the query, from a macro or VBA. then requery the form
that's bound to tblEmpHours. you can set the OrderBy property of the form in
VBA. something along the lines of:

Dim db As DAO.Database, strSQL As String
Set db = CurrentDb
strSQL = db.QueryDefs("AppendQueryName").SQL
db.Execute strSQL, dbFailOnError
Me.Requery
Me.OrderBy = "SomeField, SomeOtherField"
Me.OrderByOn = True

hth


"Jaybird" <Jaybird@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9CFEF83D-5162-4204-A92E-F4A62BABEAC8@xxxxxxxxxxxxxxxx
Aha,

I didn't read your post carefully enough. Sorry. I'll concentrate my
efforts on looking for an example of just such and appending code. I
appreciate the response. Of course, my VBA skills stink. Maybe someone
could walk me through it? Hint, hint...

Jaybird

"tina" wrote:

you need minimum two tables:

tblEmployees
EmpID (primary key)
FirstName
LastName
<any other fields that describe an employee.>

tblEmpHours
HourID (pk)
EmpID (foreign key from tblEmployees)
WorkDate
WorkHours

the table design is standard and simple. to do the data entry
efficiently in
forms, you can get about as creative as you need to be. exactly how you
set
up the data entry form depends on how the user needs to be able to enter
the
data. for instance, will the user enter all the hours for all employees
for
Monday 2/20/2006, then for Tuesday, etc? or will the user enter all the
hours for one employee for each day of the week, Monday 2/20/2006
through
Friday 2/24/2006, then for the next employee, etc?

in either case above, you can add code to the data entry form to append
records for all employees for each date of the work-week at one time,
and
then sort the records according to how the user needs to enter the data,
thus presenting the user with a group of "already existing" records that
s/he can quickly move through in order, entering just the hours - the
employee and date information is already present in the record.

hth


"Jaybird" <Jaybird@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BE378A2C-A089-4FEE-B133-F3BF127F66AC@xxxxxxxxxxxxxxxx
I am attempting to get Access to behave in a way that is similar to
Excel
in
some respects... Currently, payroll is using excel to post weekly
employee
hours. The current list of employees is posted with the hours they
worked
for each day during the week on one work***, the next week's hours
are
posted on the next work*** and so on. To get an Access application
to
be
adopted by payroll, I need it to behave in the same way. I want to
design
a
form which pulls up the current list of emploees with the hours they
worked
for that week as one record, with the next week's hours as the next
record.
Currently, Access wants to treat each employee and their hours as
individual
records. You have to scroll down the list of employees one at a time
to
find
the weekly hours you want to enter. Obviously, you can design a
report
that
organizes the data by employee and the weekly hours after they have
been
entered, but I want a way to enter this information in a form all at
once.
Does anyone know how to get Access to behave in this way?






.

Quantcast