Paula,
Is there anyway to get a copy of a dumbed down version of the timesheet module? So I can see how it works. The payroll is a whole different application in our system. Your snapshot look exactly like what we are after. Ok actually its way beyond our needs.
With warm regards,
Arthur Lorenzini
Sioux Falls, South Dakota
________________________________
From: pstr0ud <paula_stroud@hotmail.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Monday, November 28, 2011 12:44 PM
Subject: Re: [MS_AccessPros] Timesheet requirement
Art, I've uploaded the screenshots for the Student Timesheet/Payroll app. We've been using this module for about 3 years now and it's been customized for our University and our Program budgets. I have modified this module infrequently at the request of dept Users when our fiscal reporting requirements have changed. Or when they've seen what wonderful data can be extracted for their budgeting use.
Paula
--- In MS_Access_Professionals@yahoogroups.com, Art Lorenzini <dbalorenzini@...> wrote:
>
> Sounds great. If you go to the Home page of this group you will see Files, click on that and you you will see the Needs Assistance folder. Click on that, then Click add files.
>
>
>
>
> With warm regards,
>
> Arthur Lorenzini
> Sioux Falls, South Dakota
>
>
>
>
>
>
> ________________________________
> From: pstr0ud <paula_stroud@...>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Monday, November 28, 2011 8:28 AM
> Subject: Re: [MS_AccessPros] Timesheet requirement
>
>
> Â
> 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]
> >
>
>
>
>
> [Non-text portions of this message have been removed]
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar