Trying To Create An Automatic Payroll Form
Hello,
I am basically doing FORM to automatically figure out my stylists commission pay, based on 5 levels of sales and 3 different pay levels, that I will cut and paste in a table from my POS system.
3 Total Tables.
tbl_Employees, with the headers ID, Name, Payroll ID, Comm_Level.
tbl-Current Year with the headers ID, Payroll ID, Name, Service Sales.
tbl_Comm with the headers ID, CommLow, CommHigh, Level1, Level2, Level3
In a query, Qry_Years, I have Payroll ID, linked between the tbl_Employees and tbl-Current Year.
I am close in a FORM to getting this to work, unless DLookup is the wrong why to go about this.
This is not correct, but gives you an idea of what I am trying to do. In a FORM text box (called framePayrollIDLookup) I have
=DLookUp("Level1","tbl_Comm",[tbl - Current Year.Service Sales] & " between [CommLow] and [CommHigh]").
This pulls up the correct pay percent for level1 employees, but i need to change out Level1 to something variable.
This also doesn't work, but gives you an idea of my though process.
=DLookUp(" " = framePayrollIDLookup,"tbl_Comm",[tbl - Current Year.Service Sales] & " between [CommLow] and [CommHigh]"), but this doesn't work.
I might be way off base on how to do this, but I am trying. Thanks for any help.
Chris
View Complete Forum Thread with Replies
Related Forum Messages:
Payroll Form
Hey there, I have a form that has 7 days (Mon, Tue, Wed, Thur, etc...). The time is formatted like 08:00AM. Under each of those controls I have something that uses the expression: =(((([Sunday End Time]-[Sunday Start Time])*24)*60)/60), which if the hours were 08:00AM - 04:00PM, would give me 480, and then I convert it to hours (8). I have all these fields defaulted to 12:00AM to 12:00AM. I have another box that totals all these fields and uses the expression: =([SUH]+[MH]+[TU]+[WH]+[TH]+[FH]+[SAH]). These boxes are all of the results of End time-Start time. Now the problem. I have a payrate field on the form that looks at the hours worked, so I needed to separate overtime from straight. I have a box that looks like this: =IIf([Hours Worked]>"40",40,([Hours Worked])). The hours worked box is the result from the sum of SUH+MH+, etc...The problem is, each time I have any hours in there less than 10, it will return a crazy result. If I only enter 8 hours, it enters in the hours worked box: 40 hours. If I add 2 more hours, it fixes itself. What is the problem. I would be happy to send the file over, or ANYTHING to get this to work. Sincererly, Raymond
View Replies !
Create Automatic Interchangable Hyperlink
I am attempting to creae a hyperlink to set into a table that is generated automatically by other information curently residing on the table, and with the ability to change the disc location. The table I have created is an application that will name reports that I have in .PDF format. I put in the report title, date, inspectors, etc. and it gives me a unique name for the document. I then go to my document and name it what the application gives me. Now, we would like to have a link to that file that resides on the table, so if we look it up in the future we don't have to search any further, we can just click right there and go strait to it. I know how to insert a hyperlink to get to the file, assuming it stays on the same directory. Our directories change fairly often (can go from C:/My Docs/File to E:/My Docs/File in a matter of a week), so I would like to know if there is a way to create a partial hyperlink that I can change the begining to whenever need be. Any ideas or suggestions are greatly apericiated. Thanks guys!
View Replies !
Payroll Help
I am trying to develop a simple payroll. I have already developed three tables named tblEbmployee, tblPayment, tblDate. These are related with one to many between tblEmployees and tblPayment and one to many between tblPayment and tblDate. I dont need much calculations in the system. I will add salaries in tblPayments of the employees manually (as there is no set formula relating to the salary an employee). What i need is: To make a form which uses tblemployee for each month salary To carry the previous month salary data to next month without adding date for each employee indiividually. (is there a way to change month once that applies to all employees, keeping the record of previous month ) Do i need to add some other table to keep record of previous month payments and a table keeping record of rate of salary yours Arshad Slatch
View Replies !
Payroll System
Hi All, Need your expert advise. Is it ok to develop a simple payroll system using MS Access or do i need switch to Visual Basic? Also, is there anybody can help what tables do i need to produce a payroll system, i.e. tblEmployee. Thanks, 19Summer95
View Replies !
Payroll Calculation
I am trying to type a code based on 1 & 2 criterias. However, I am having a problem on the first criteria because it is adding 8 hours when it shouldn't. Can someone help to either fix my code or write a new one? Thank you very much! Criteria 1: If the day_of_wk is 1, calculate time-reg_time/60, If the day_of_wk is 1 and time is less than 0, calculate time-reg_time/60+24 Criteria 2: If the day_of_wk is 2, calculate time/60, If the day_of_wk is 2 and time is less than 0, calculate time/60+24 My code: pre: IIf([day_of_wk]="2",[time]/60,IIf([time]<0,([time]-[reg_time])/60+24,([time]-[reg_time])/60))
View Replies !
Payroll Dilemna
Hello excellent helpers, Thanks first of all for the responses I always get on here. Question: There are several number fields on my form that are calculate fields, which I will show later what the expression is, that are not rounding off to 2 decimals as I am asking it to. How do I fix this? The expression: =(((([Wednesday End Time]-[Wednesday Start Time])*24)*60)/60). This is a control box located under two fields (Start time and End time). The fields are formatted as 08:00AM. So if I did 08:00AM to 05:20PM, the result would be 9.333333333....This does not mean much for the day as it adds up to be only cents, but over the week it becomes dollars. If the actual number was 9.33, it would be ok. No use in explaining that, you all get the idea.
View Replies !
Employee Payroll
I'm trying to use a query to calculate the payroll for all the employees but it won't work. The two tables I have are 'Employees' and 'Employee Payroll'. In the 'Employee Payroll' table there are three fields- Employee ID, Days worked and Earnings. I need to calculate the sum of the earnings field but it just displays a blank list of records when I try it. Can anyone help? Thanks
View Replies !
Calculate Payroll In Order Database
I have an order database Access 2000 for an inspection company, tblInspectors, tblOrders, tblCustomers, I want to be able to calculate inspector pay within order database. Each inspector is an independent contractor, so it just needs to calculate percentage, for each inspection performed and total for pay period. Each inspector is paid a different percentage, which is stored in tblInspectors. Payroll is paid every two weeks . . . I've been trying to figure out the best way to do this ... :confused: Any advise be greatly appreciated.:confused:
View Replies !
Automatic Entries On A Form
I'm trying to build a Form that will allow one field to be automatically populated when data is entered in another field. I have a table that contains two Fields: Course Name and Course Code. When I enter the Course Name in a Form, I would like the corresponding Course Code to appear in the relevant box on the Form. Can anybody point me in the right direction as to how this can be achieved Thanks DD
View Replies !
Payroll Database- Advice Needed On Relationships/normalisation
Hi, I would like to get your advice on my table setup and relationships for this payroll project. The company is an engineering company with Projects (or construction sites) around the world. The 'Candidates' are current or potential employees and contractors. There are three main pay categories: 1.Shift-workers All shift workers doing a particular job on a particular project are paid the same rates e.g. all welders on a particular project or site in England are paid the same as each other. For that reason I want to link the pay rates with the job description for these workers. This avoides creating 50 records for 50 welders on the site in England to say that they make £10 an hour normal time (or whatever it is) etc. 2. Contract Contract workers usually get paid a flat rate per hour. As these are negociated on an individual basis I would need to have this information linked to each individuals job (M_CandidateJobDetails). 3. Salary Again this information needs to be input for each individuals job. For the contract and salary people the pay frequency can vary (weekly, bi-weekly or monthly). So can the currency they are paid in. I haven't got as far as the currency issue yet. The reason for the one-to-many relationship between M_JobClassifaction and M_CandidateJobDetails is that many candidates can have the same type of job e.g. there can be many employees that in the job classifaction of 'Electrician'. For many of the jobs at managerial level e.g. 'site manager' there will only be one. I will have a table with the hours worked by each person per week. I can use this for those on shift work or contract to calculate what they will be paid. One of the main reasons for this database is so that the company can print reports to see what is paid out in payroll for each site and in total (in euros). These will be gross figures and I don't need to take expenses, vacations, bonuses or taxes into account. They other thing we will need to be able to do is assign candidates to vacant positions and change them from one position to another - possibly between different projects. So basically does anyone have any comments on the relationships, normalisation or anything else. Is this the best way to do it? I've attached a screenshot of the relationships.
View Replies !
Automatic Population Of Fields On A Form
Hello, we are creating an input form to update a file in access. We would like to enter an order number and use that number to retrieve extra data from, a non access database. The extra data would be used to populate the fields in the access file.
View Replies !
Refreshing The Form And Automatic Saving Question
Dear all My inquiries is 2 fold 1) The first relates to refreshing of the data. What I have now is a main form and a combo box control that generates the list of values based on the current data shown on the main form. In more elaborate terms, I have a Main Client Form, and a Fee tracking subform. Each Client can have more than one account, so in the Fee tracking subform, I have a account combo box that provides the value that correspond to the client on the main form based on a query i generated. >> My question is everytime i scroll through the clients, I still get the same drop down values for the previous client. I installed a refresh command button and upon clicking that, it gives me the new account numbers that correspond to the current client upon. What I would like to ask is if there is any simpler or automatic way of refreshing? 2) I am not that familiar with how Access records the data in the underlying tables, but right now, all the changes I make is recorded. Is there anyway to do so such that changes will be saved only upon the user confirmation and not automatically? Thanks a lot in advance on any advice Regards TK
View Replies !
How To Make Automatic Refresh / Realtime Form Datasheet
fyi : database use SQL Server 2000 ,frond end use Ms.Access 2000 and allready use with multi user the problem is : I want to automatic refresh / realtime form datasheet, if the data allready changed, deleted or add new. I try to solve it with 1. timer event + requery but i thing it's not a good idea because if data not changes, the form will be allways requery. 2.I use winsock so every user change the data, the will be send an event and i use arrived event to refresh form datasheet. And it's not solve the problem again because prosedure save/add data is more slow than event send data with winsock. so guys , plx help me to solve the problem. thx Esugiawan
View Replies !
How To Create Users In Form
hey guys, i just needed a guide on how to create a form with different users in it. also, is there a way in which i can create a button that will open the wizard to create a report ?? [guess wat, no deadline.... but that doesn't mean dont answer ;) ] hope a reply soon.. thanks in advance.
View Replies !
Create Form From Wizard
During the create form from wizard process, there is a screen which gives the option of applying a style. Can this be bypassed or can a 'none' option be added.I'm new to access, so any suggestions are welcome. I think creating a form in design view will build with no syle, but how do you add fields?thanks
View Replies !
How To Create A Form As An Executable
hi everyone i'm super new at access. i think it's neat for now. i just made a form that people can use to insert information. we have a network drive here and it would be super cool to be able to convert the form into an Executeable file that way people can just click on the exe Icon and open up the form without having to go into access and then open the form. please let me know
View Replies !
Create A Chart On A Form
i have about 1500 records in my database and i want to display a bar chart for each record, i can tryed creating one but when i try adding the months it says i only can add 6 fields but i want to include each month not just 6 months in the chart, this is an on going database so in the future there will be more months added. here is the picture of the form i want to be able to show 2005 and 2006 figues in the same chart
View Replies !
Create Records From A Form
Can someone direct me as to the most efficient way to add records to a table from a form? I have a table of members and a table of invoices and want to automatically create an invoice for each member by clicking a button on a form. Is there a way to do this using a macro, query, or do I write it in VBA? Thanks much!
View Replies !
Need To Create A Form Letter....
I need to add a basic button on a form that would populate the current on-screen data in a form letter. The fields I have are name, address, city state zip and amount. I currently have the basic buttons on my form - Search, Next, Previous,Add, Delete Print Current Record. Thanks in advance for your assistance.
View Replies !
Create New Record With Form
How do I create a new record (in the table to which the form is bound) automatically if, when the form opens, there is no record in the table that meets the criteria in the form filter? Thanks!
View Replies !
Help- Create Search Form
hello, i know i have seen example from here, nome of them seems to help. My is just a simple search. i have 4 tables: Artist Name, title, country and location all i want is create a form that has a search. I want to type the artist name and it lists the country of the artist. How to i do this. I create the command button and text box but it just does not work. This is the code i use on the command. Quote: Private Sub ButtonSearchForRecords_Click() Dim StringQuery As String Dim StringWhere As String StringWhere = "" If Not (TextBoxSearchName = "") Then StringWhere = StringWhere & "AND [Name] = '" & TextBoxSearchName & "' " End If StringWhere = Right$(StringWhere, Abs(Len(StringWhere) - 4)) StringQuery = "SELECT [Name], [Title], [Country], [Location] " _ & "FROM [2-75TH SCAR] WHERE " & StringWhere _ & "ORDER BY [Name], [Country]" Me.ListBoxRecordsFoundInSearch = StringQuery Me.ListBoxRecordsFoundInSearch.Requery End Sub
View Replies !
|
TRACKER
