Art, sorry I just now saw your reply.
I will try to upload something within the next few days. Not sure I know where to upload it since I am new to this site. will look for the Needs Assistance folder.
Paula
--- In MS_Access_Professionals@yahoogroups.com, Art Lorenzini <dbalorenzini@...> wrote:
>
> Paula,
> I would really appreciate any snapshots or other examples of your timesheet modules. I think you can just upload them to the Needs Assistance folder.
>
>
>
> With warm regards,
>
> Arthur Lorenzini
> Sioux Falls, South Dakota
>
>
>
>
>
>
> ________________________________
> From: pstr0ud <paula_stroud@...>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Monday, November 21, 2011 9:42 AM
> Subject: Re: [MS_AccessPros] Timesheet requirement
>
>
> Â
> Hello Art,
>
> I am a new member so not too clear how this all works.
> I have developed a similar MS Access app to record tutor hours worked, and get reports and extracts for Payroll. This is a module that is part of a larger budget/fiscal app. for our University department.
>
> I could send you some screen shots of what I developed and the reports extracted, as well as how I set up the tables. The tables are probably not as nifty as what John Viescas suggested (he's written books on the subject), or some others have mentioned.
> This module has been working nicely for 2-3 years and is the basis of how our tutors are paid.
>
> Paula
>
> --- In MS_Access_Professionals@yahoogroups.com, Art Lorenzini <dbalorenzini@> wrote:
> >
> > Is there an example somwhere I could look at because right now my brain is going whaaa! :)
> >
> >
> >
> >
> > With warm regards,
> >
> > Arthur Lorenzini
> > Sioux Falls, South Dakota
> >
> >
> >
> >
> >
> >
> > ________________________________
> > From: Duane Hookom <duanehookom@>
> > To: Access Professionals Yahoo Group <ms_access_professionals@yahoogroups.com>
> > Sent: Saturday, November 19, 2011 2:42 PM
> > Subject: RE: [MS_AccessPros] Timesheet requirement
> >
> >
> > ÂÂ
> >
> > I would keep a table of pay periods with at least the start date of the period.
> >
> > Can we assume that every person needs a single entry for each work date?
> >
> > Your table structure had
> >
> > -- TTSHours Long Integer 4
> >
> > I think you want double or other that allows partial hours
> >
> > I would append daily records to the timesheet detail table and display this in a continuous form for entry of hours.
> >
> > If you want to get fancy, you could use an unbound form with daily text boxes and then use code to append values/records to the timesheet details.
> >
> > Duane Hookom
> >
> > MS Access MVP
> >
> > ________________________________
> > > From: dbalorenzini@
> > >
> > > Any ideas on how this can appear on a form, I get the relationship now
> > > but can picture how to put the timesheet form together especially when
> > > a pay period is two weeks.
> > >
> > > With warm regards,
> > >
> > > Arthur Lorenzini
> > >
> > > ________________________________
> > > From: John Viescas <john@<mailto:john%40viescas.com>>
> > > To:
> > >
> > > Exactly.
> > >
> > > John Viescas, author
> > >
> > > -----Original Message-----
> > > From: Art Lorenzini
> > >
> > > Something like this?Table: tblTutorTimesheetNew Page: 2
> > > Columns
> > > Name Type Size
> > > TTSID Long Integer 4
> > > TutorID Long Integer 4
> > > TSSPayPeriodID Long Integer 4
> > > WorkTypeID Long Integer 4
> > > Approved Yes/No 1
> > > ApprovedByID Long Integer 4
> > > ApprovedDateTime Date/Time 8
> > >
> > > Table: tblTutorTimesheetDetail Page: 1
> > > Columns
> > > Name Type Size
> > > TTSDID Long Integer 4
> > > TTSID Long Integer 4
> > > TTSDate Date/Time 8
> > > TTSHours Long Integer 4
> > >
> > > But I am not sure how I am going to put two weeks together to form a
> > > pay period...
> > >
> > > With warm regards,
> > >
> > > Arthur Lorenzini
> > > Sioux Falls, South Dakota
> > >
> > > ________________________________
> > > From: michael simpson <saccity101@<mailto:saccity101%40yahoo.com>>
> > >
> > > Looks wrong lots of repeating data
> > > Perhaps break it out into two tables
> > >
> > > tblTimeSheet
> > > tblTimeDetail
> > > Michael
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar