473,778 Members | 1,901 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Help with Data entry

3 New Member
I have two tables, tblEmployees and tblEmployeepaym ent. tblEmployees has the following fields the data to this table comes from our payroll system

EmployeeID
Name
Paygroup
Employeestatus
Annualsalary

tlbEmployeepaym ent has the following fields which will be entered by the user.

EmployeeID
PayPerioddt
Paybegdate
Payenddate
Partialpayment
Hours
Annualsalary

I have created query from these two tables. I have one to many releationship between tblEmployees and tblEmployeepaym ent based on EmployeeID. I need annualsalary in my tblemployeepaym ent tble because I want to keep track of their salary based on payperiod. For exmple if on 5/15/2007 their salary 50000 and on 5/31/07 their salary 55000 I want keep their salary history for each pay period. The question is that when the users start data entery I want to auto populate the salaryfield for them to reduce data entery errors. Can someone help please.
May 7 '07 #1
5 1463
JConsulting
603 Recognized Expert Contributor
I have two tables, tblEmployees and tblEmployeepaym ent. tblEmployees has the following fields the data to this table comes from our payroll system

EmployeeID
Name
Paygroup
Employeestatus
Annualsalary

tlbEmployeepaym ent has the following fields which will be entered by the user.

EmployeeID
PayPerioddt
Paybegdate
Payenddate
Partialpayment
Hours
Annualsalary

I have created query from these two tables. I have one to many releationship between tblEmployees and tblEmployeepaym ent based on EmployeeID. I need annualsalary in my tblemployeepaym ent tble because I want to keep track of their salary based on payperiod. For exmple if on 5/15/2007 their salary 50000 and on 5/31/07 their salary 55000 I want keep their salary history for each pay period. The question is that when the users start data entery I want to auto populate the salaryfield for them to reduce data entery errors. Can someone help please.

my first thought is that you need to add an Index to your tblEmployeepaym ent table
UniqueID
EmployeeID
PayPerioddt
Paybegdate
Payenddate
Partialpayment
Hours
Annualsalary

How are you set up for data entry? A primary form with a subform?
J
May 7 '07 #2
mobaligh
3 New Member
my first thought is that you need to add an Index to your tblEmployeepaym ent table
UniqueID
EmployeeID
PayPerioddt
Paybegdate
Payenddate
Partialpayment
Hours
Annualsalary

How are you set up for data entry? A primary form with a subform?
J

Yes. I have a primary form witha subform. I do have a uniqueId in tbleployeepayme nt table forgot to mention it.
May 7 '07 #3
JConsulting
603 Recognized Expert Contributor
Yes. I have a primary form witha subform. I do have a uniqueId in tbleployeepayme nt table forgot to mention it.
>>The question is that when the users start data entery I want to auto populate the salaryfield for them to reduce data entery errors. Can someone help please.

When you're beginning your data entry...

They open a record to a specific Employee?
Are they entering Hours?

How about on the form's On_Current event you do a look up based on the employee id and assign it as the Salary

me.salary = nz(dlookup("Sal ary","EmployeeT able","Employee ID = " & me.EmployeeID))

something like that.
J
May 8 '07 #4
mobaligh
3 New Member
>>The question is that when the users start data entery I want to auto populate the salaryfield for them to reduce data entery errors. Can someone help please.

When you're beginning your data entry...

They open a record to a specific Employee?
Are they entering Hours?

How about on the form's On_Current event you do a look up based on the employee id and assign it as the Salary

me.salary = nz(dlookup("Sal ary","EmployeeT able","Employee ID = " & me.EmployeeID))

something like that.
J
I dont' want to do a calculated field, because I want to store the salary for each pay period. When the user opens the form they enter pay period, begin date and end date and hours. I would like to keep the history for each of the pay period
May 8 '07 #5
JConsulting
603 Recognized Expert Contributor
I dont' want to do a calculated field, because I want to store the salary for each pay period. When the user opens the form they enter pay period, begin date and end date and hours. I would like to keep the history for each of the pay period
Maybe you / I misunderstood.. .The small lookup code wouln't be in the control source of your Salary textbox...it would be in a VBA module to automatically populate it.

Isn't that what you asked for?
May 8 '07 #6

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

Similar topics

2
3653
by: Darryll Petrancuri | last post by:
Greetings! I could really use some suggestions on how to improve on the following, it at all possible: Table 'Customer' --------------------- ID GUID PK ....
6
1348
by: Guttyguppy | last post by:
I have <?xml version="1.0" encoding="ISO-8859-1"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="/"> <html> <body> <xsl:for-each select="category/entry"> <xsl:value-of select="job"/><br/>
8
5481
by: baustin75 | last post by:
Posted: Mon Oct 03, 2005 1:41 pm Post subject: cannot mail() in ie only when debugging in php designer 2005 -------------------------------------------------------------------------------- Hello, I have a very simple problem but cannot seem to figure it out. I have a very simple php script that sends a test email to myself. When I debug it in PHP designer, it works with no problems, I get the test email. If
2
1631
by: Wayne Wengert | last post by:
This is my first attempt to re-write an old VB6 application that exported a CSV file to a .NET application that exports an XML file with the equivelent data. I have limited understanding of OO programming concepts (am trying to learn) and XML serialization is all new ground for me. Anyway, here is what I am trying to accomplish: Goal ---- We sponsor competitions in ehich various teams compete. An "event" is made up of a set of "shows"....
4
9321
by: Allan M. Bruce | last post by:
I have a small implementation of a queue which I am trying to get to compile but cant figure out why it doesnt work. I have copied the minimum compilable code below. On gcc I get temp2.c: In function `pop': temp2.c:24: warning: initialization from incompatible pointer type temp2.c:25: warning: assignment from incompatible pointer type temp2.c: In function `destroy': temp2.c:38: error: dereferencing pointer to incomplete type
0
2368
by: blazerguns | last post by:
Hi all, Iam trying to do some certificate management using CAPICOM lib. Iam writing this website with a backend c#. All i want is know is how to select the website on IIS to do certificate installation and viewing. That is currently when i run my program from the ASP .NET dev server it installs and views the certificates present in "Default Web Site" of IIS Manager console. Lets say if i run a new website "xyz", how can i do...
3
1896
by: Pino | last post by:
HI all, I am learning c++ ( just 1 month) and would want an aid for a code. I have a integer vector of length N. ie 3 3 3 4 4 1
1
1874
imrosie
by: imrosie | last post by:
Please help with this one,,,,,I've been trying everything in my arsenal to fix this one. I'm stumped.... I"ve got a unbound combo box (customername) that has two events (on click); AfterUpdate and NotInList. The AfterUpdate uses a 'me.recordsetclone' in order to display other data in controls associated with customerid/customername from the Customer table. The NotInlist, does just that, adds a new customer name to the list along with...
2
1826
by: TexasAggie96 | last post by:
I have XML that looks like below from which I want to make the VALUE tags that are empty (ie <Value/>) default to <Value>0.00</Valueand then I want to pull out certain values, for which I already have the XSLT for, which is also seen below. Can someone please help me with how to do this? Thanks ***Data to be processed *** <GetNamedProfileReturn> <NamedProfile> <ProfileId>115512</ProfileId>
2
1491
by: helraizer1 | last post by:
Hi folks, I have a file for my chatbox called data.line, which the posts are in the layout CHATBOXTEXT 7 username=helraizer 1202416953
0
9629
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9470
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
10069
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9923
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6723
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5500
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4033
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3627
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2865
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.