main form based on table with no date field-need to tie-Sun dt w/s

B

babs

Posted before- haven't heard back -any idea anyone?

I have the one Table with the Employees as the One side (Main Form) linked
to the subform Many side with the soc. sec.# and what they are scheduled for
on the TimeCard Table (see below) the date they are scheduled for is listed
in this table -

Not clear how to put the Start Date field on the Main form if not on that
table.

Do I make a query with all fields from employee table and add the date field
here??

Not clear on in the actual query how to set up the WHERe code - am I
prompting the user for EACH record (0n Main what they are schedule for for
that given week????

Just really want EACH record (main) to be a give start of the week( all jobs
schedule for That week have the SAME Start of the week date - ex. all say
8/9/09 for that week

Want to see each employee for that given week as one RECORD - and subform
would show spec. jobs worked that week.

Next record can be another employee for that week , or another week for that
same employee

ie. each main record is an employee and their scheduled/actual work for a
given week.(

thanks for your help,
Barb


Klatuu said:
When you say "without having to filter", it males mp sense. To get only the
days for a week beginning on Sunday, you do have to filter, but not at the
form level.

Use a query as the form's Record Source with:

WHERE [WorkDate] BETWEEN Forms!MainForm!StartDate AND DateAdd("d", 6,
Forms!MainForm!StartDate)
--
Dave Hargis, Microsoft Access MVP


babs said:
I have an employee table - listing each employee one time (soc. sec #) PK,
Man Name, address, Position, etc.

Then I would like for ONE Given WEEK (Date field- Just shows the Scheduled
date at the Sunday for that Given Week)- example 8/9/09(not sure where this
goes)
- to show what that employee is schedule for That 8/9/09 week ONLY for one
visible record on the main form

I have a TimeCard Table that show the Date Sheduled(8/9/09) at well as the
Job#, Job Name, Number of hours Mon, Tue, Wed, thur etc. sheduled

When I make the form with the employee on the main for ALL jobs for All
dates that the employee is sheduled for show up. - really only want to see
the ones for a Given Week- all would say 8-9-09 since they are sheduled on
the Sunday.

not sure how I can Just show this weeks Jobs automatically with having to
filter???

What am I missing????

Thanks,
Barb
 
K

KARL DEWEY

It seems that you are mixing Tables and Forms/Subforms in your statements.
Post the structure of the two tables with field names and datatype.

Your earlier post had --
TimeCard - Sheduled, Job#, Job Name, Mon, Tue, Wed, thur etc. This is bad
structure.

Your latest post says - each main record is an employee and their
scheduled/actual work for a given week. What do you mean by 'main record'?

In addition to post structure post sample data of each table.

Also how are you going to use this information? It looks like a spreadsheet
would do what you want but I am only guesssing as to what you need the data
for.

--
Build a little, test a little.


babs said:
Posted before- haven't heard back -any idea anyone?

I have the one Table with the Employees as the One side (Main Form) linked
to the subform Many side with the soc. sec.# and what they are scheduled for
on the TimeCard Table (see below) the date they are scheduled for is listed
in this table -

Not clear how to put the Start Date field on the Main form if not on that
table.

Do I make a query with all fields from employee table and add the date field
here??

Not clear on in the actual query how to set up the WHERe code - am I
prompting the user for EACH record (0n Main what they are schedule for for
that given week????

Just really want EACH record (main) to be a give start of the week( all jobs
schedule for That week have the SAME Start of the week date - ex. all say
8/9/09 for that week

Want to see each employee for that given week as one RECORD - and subform
would show spec. jobs worked that week.

Next record can be another employee for that week , or another week for that
same employee

ie. each main record is an employee and their scheduled/actual work for a
given week.(

thanks for your help,
Barb


Klatuu said:
When you say "without having to filter", it males mp sense. To get only the
days for a week beginning on Sunday, you do have to filter, but not at the
form level.

Use a query as the form's Record Source with:

WHERE [WorkDate] BETWEEN Forms!MainForm!StartDate AND DateAdd("d", 6,
Forms!MainForm!StartDate)
--
Dave Hargis, Microsoft Access MVP


babs said:
I have an employee table - listing each employee one time (soc. sec #) PK,
Man Name, address, Position, etc.

Then I would like for ONE Given WEEK (Date field- Just shows the Scheduled
date at the Sunday for that Given Week)- example 8/9/09(not sure where this
goes)
- to show what that employee is schedule for That 8/9/09 week ONLY for one
visible record on the main form

I have a TimeCard Table that show the Date Sheduled(8/9/09) at well as the
Job#, Job Name, Number of hours Mon, Tue, Wed, thur etc. sheduled

When I make the form with the employee on the main for ALL jobs for All
dates that the employee is sheduled for show up. - really only want to see
the ones for a Given Week- all would say 8-9-09 since they are sheduled on
the Sunday.

not sure how I can Just show this weeks Jobs automatically with having to
filter???

What am I missing????

Thanks,
Barb
 
B

babs

Here goes.

We are using this date to Generate Paychecks(weekly for the employees) based
on their number of hours worked

One table is Employees

Soc Sec # is PK Text
Man Name - text
address - text
city-text
state-text
HrlyRate-currency
Plus just other info like date Hired, not much more here

The second TABLE is the Time Card MD
Right now this data is Manually ADDED in from an EXCEL spreadsheet(on a
daily basis) where the person totals Up FOR the WEEK the number of hours
worked for STRAight time, double time, etc for that WEEK(puts in the START
week date(Sunday DATE)- same on spreadsheet.

Really trying to set it up so that the person putting in the excel info can
just directly put it into ACCESS - after that we are good - set up an append
query and generate paychecks and Payroll table(GOOD on that!!)

The person putting in the data into Access would have to put it in daily and
maybe set up the WEEks Schedule in advance and click some button- actualy
worked for the day.

Here are the Column headings in EXCEL:
Man Name (Employee), Job Name, Job Number,Day(going down is the
Day-Mon,tues,wedetc) StraightTimeHrs, OverTimeHrs, DoubletimeHrs, NOTES
So can see what type of hours are work on Mon, tues, etc.
Each TAB is a seperate WEEK(starting on Sunday)-Actual DATE worked doesn't
seem to matter?? Just what Day for that week.

I made a Form - using the Form Wizard grabbing the Employee Table1st and
then the Timecard Table(not sure of best way - to list the hours worked field
for each day of straight time, over time, double time-have MonST, TueST, etc,
MonOT, TuesOT-the usere needs to Visually see the DAY!!)-ideas- also on
timecard table is soc sec#, job#, job name, startwkDATE(this is what is one
the tAB in excel)

they are a One to Many Link so the form ends up being the Main(single record
) is the employee and then what they have worked is in the subform -- but I
see ALLLLL of what they have worked

REally would like to put the date field(for beginning of week -like what is
On the TAB for Excel file)so the user can visually see ONE week at a time for
each employee- NOT sure how to see Only what is scheduled/worked for ONE
employee for One week(only put in the Sunday date for that week anyway) just
not sure how the Many side(subform) can show just ONE WEEK


thanks sooo much for helping,
barb

KARL DEWEY said:
It seems that you are mixing Tables and Forms/Subforms in your statements.
Post the structure of the two tables with field names and datatype.

Your earlier post had --
TimeCard - Sheduled, Job#, Job Name, Mon, Tue, Wed, thur etc. This is bad
structure.

Your latest post says - each main record is an employee and their
scheduled/actual work for a given week. What do you mean by 'main record'?

In addition to post structure post sample data of each table.

Also how are you going to use this information? It looks like a spreadsheet
would do what you want but I am only guesssing as to what you need the data
for.

--
Build a little, test a little.


babs said:
Posted before- haven't heard back -any idea anyone?

I have the one Table with the Employees as the One side (Main Form) linked
to the subform Many side with the soc. sec.# and what they are scheduled for
on the TimeCard Table (see below) the date they are scheduled for is listed
in this table -

Not clear how to put the Start Date field on the Main form if not on that
table.

Do I make a query with all fields from employee table and add the date field
here??

Not clear on in the actual query how to set up the WHERe code - am I
prompting the user for EACH record (0n Main what they are schedule for for
that given week????

Just really want EACH record (main) to be a give start of the week( all jobs
schedule for That week have the SAME Start of the week date - ex. all say
8/9/09 for that week

Want to see each employee for that given week as one RECORD - and subform
would show spec. jobs worked that week.

Next record can be another employee for that week , or another week for that
same employee

ie. each main record is an employee and their scheduled/actual work for a
given week.(

thanks for your help,
Barb


Klatuu said:
When you say "without having to filter", it males mp sense. To get only the
days for a week beginning on Sunday, you do have to filter, but not at the
form level.

Use a query as the form's Record Source with:

WHERE [WorkDate] BETWEEN Forms!MainForm!StartDate AND DateAdd("d", 6,
Forms!MainForm!StartDate)
--
Dave Hargis, Microsoft Access MVP


:

I have an employee table - listing each employee one time (soc. sec #) PK,
Man Name, address, Position, etc.

Then I would like for ONE Given WEEK (Date field- Just shows the Scheduled
date at the Sunday for that Given Week)- example 8/9/09(not sure where this
goes)
- to show what that employee is schedule for That 8/9/09 week ONLY for one
visible record on the main form

I have a TimeCard Table that show the Date Sheduled(8/9/09) at well as the
Job#, Job Name, Number of hours Mon, Tue, Wed, thur etc. sheduled

When I make the form with the employee on the main for ALL jobs for All
dates that the employee is sheduled for show up. - really only want to see
the ones for a Given Week- all would say 8-9-09 since they are sheduled on
the Sunday.

not sure how I can Just show this weeks Jobs automatically with having to
filter???

What am I missing????

Thanks,
Barb
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top