473,395 Members | 1,679 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

Payroll / timecard

hyperpau
184 Expert 100+
CAn anybody give me an advise on the best way to create a payroll or timecard ms access database?

This database should be on a recurring basis, meaning, it talks about all the days in a year.

I can't think of the best way to do this since i am imagining a table with a lot of columns representing the days of each month, which I am sure is not advisable.
Aug 15 '07 #1
5 2023
BradHodge
166 Expert 100+
I guess I don't understand why you would need a table with the days of the months in it. Are you thinking that you would have say the 1st of September and 35 people worked on that day?

Brad.
Aug 15 '07 #2
hyperpau
184 Expert 100+
I guess I don't understand why you would need a table with the days of the months in it. Are you thinking that you would have say the 1st of September and 35 people worked on that day?

Brad.
this is for checking attendance on a daily basis as a basis of how much a trainee would get paid.
Aug 20 '07 #3
BradHodge
166 Expert 100+
My apologies if I'm going off in the wrong direction, but...

What if you just had your Trainees table and then a form with a multiselect list box on it that showed all the trainees. You could choose all the trainees that were present that day, and use a SQL statement to append them to the payroll table?

Just a thought.
Aug 20 '07 #4
hyperpau
184 Expert 100+
My apologies if I'm going off in the wrong direction, but...

What if you just had your Trainees table and then a form with a multiselect list box on it that showed all the trainees. You could choose all the trainees that were present that day, and use a SQL statement to append them to the payroll table?

Just a thought.
i'm looking into that idea. thanks
it's just that I have never worked with list boxes before. :(
is it easy to study?
Aug 28 '07 #5
BradHodge
166 Expert 100+
No problem. I've not used them much b/c I usually use combo boxes. Here is a link that has some good info in it for you though List Boxes. Rabbit also has a good article on using multiple combo/list boxes to feed one another Cascading Combo/List Boxes.

Hope this helps,
Brad.
Aug 28 '07 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: zexx | last post by:
Need some advise.... Payroll program Access97. Payroll is printed then posted to a hx table thro' a query with the payroll calculations that freeze that payroll's numbers for that period. The...
1
by: cheungs7 | last post by:
Hi all, Wondering whether you can anyone help me. We have Sage Payroll (and accounting/payroll software), which has a MS Access database where the data is stored. Now I want to access the...
1
by: Akinyemi | last post by:
I am developing a payroll program.. The data generated will be saved in an Access Database. I want a situation whereby when an employee leaves the organization or retires, instead of deleting his...
8
by: John Sitka | last post by:
Hi, There are four pay types standard shiftpremium doubletime doubletimepremium each hour a person books can be one of these types
0
by: samridhi | last post by:
Hi Do anybody have code example in .net of providing a url for posting or requesting cxml timecard data. I searched the net but didn't found any example.
1
by: Akinyemi | last post by:
I have almost finished writing my Payroll Program. But I am wondering how the program can be used for different months. For example, after, say January 2007 Payroll, the user would want to prepare...
0
by: sajithamol | last post by:
In perspective of PeopleSoft what is the basic difference between the Pay roll of North America and Global payroll? Are there any possibilities that Global payroll applied to U.S.A?
7
by: =?Utf-8?B?V2FubmFiZQ==?= | last post by:
Is there a way to use a gridview in a timecard application, and if so, how? I was looking at using a gridview to display a person's hours worked in a week. To do this, many different data records...
4
by: jnce | last post by:
hi everyone! im a student and im trying to make a basic employee payroll system using ms access 2007. can anyone give me an idea on how to create a employee payroll system using ms access...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.