PeopleSoft Adoption Made Smooth & Simple!
On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool. Claim Your Free WalkMe Account Now
Course Of The Month
4 days, 18 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Creating and comparing text fields
Posted on 2011-03-04
I have a form called “frmppm” that displays Monthly Accounts, Amounts & Total of the Amounts when you enter the Person ID and Select the Period. This data is all from a table called “ppm”.
Question
My next task is to create another text box next to my Totals that has the Annual pay of this user divided by 12. This data comes from the “Annual Pay” field from another table called “Vendors”. The Fiscal year starts on the 1st of September of a year and ends on August 31st of the following year. Example we are in Fiscal Year 2011 which is indicated by “FY11” in the "FY" field of the vendors table. If the period selected for example is October 2010, then the “Annual Pay” that should be selected from the “Vendors” table is the one that has “FY11” and divide that amount by 12 to display in this new text box. If the period selected for example is October 2009, then the “Annual Pay” that should be selected from the “Vendors” table is the one that has “FY10” and divide that amount by 12 to display in this new text box. These 2 amounts from the text boxes are suppose to be the same but if they are different I want an error message to display Saying they are not equal. Can you please help me to accomplish this task. Attached is a copy of the database with the ppm table, query and form. Also Attached is a copy of the Vendors table in excel format. I have also hi lighted the fields that matter in the vendors table.
Database11.mdb
Vendors-Table.xlsx
Question
My next task is to create another text box next to my Totals that has the Annual pay of this user divided by 12. This data comes from the “Annual Pay” field from another table called “Vendors”. The Fiscal year starts on the 1st of September of a year and ends on August 31st of the following year. Example we are in Fiscal Year 2011 which is indicated by “FY11” in the "FY" field of the vendors table. If the period selected for example is October 2010, then the “Annual Pay” that should be selected from the “Vendors” table is the one that has “FY11” and divide that amount by 12 to display in this new text box. If the period selected for example is October 2009, then the “Annual Pay” that should be selected from the “Vendors” table is the one that has “FY10” and divide that amount by 12 to display in this new text box. These 2 amounts from the text boxes are suppose to be the same but if they are different I want an error message to display Saying they are not equal. Can you please help me to accomplish this task. Attached is a copy of the database with the ppm table, query and form. Also Attached is a copy of the Vendors table in excel format. I have also hi lighted the fields that matter in the vendors table.
Database11.mdb
Vendors-Table.xlsx
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3-
3
7 Comments
Active 1 day ago
You can use the DLookup function to "lookup" your value:
Me.YourTextbox = DLookup("Annual Pay", "Vendors", "FY='FY" & Cstr(Right(Me.txFY,2) - 1)) & "'")
Me.YourTextbox = DLookup("Annual Pay", "Vendors", "FY='FY" & Cstr(Right(Me.txFY,2) - 1)) & "'")
Sorry hit the wrong button!
I have made the requested changes (and a couple more)
See what you think
Bye the way, before you add too much more to the database, you need to take a serious look at the table structure
It will make your life a lot harder in the future if you dont sort it out now Database11.mdb
I have made the requested changes (and a couple more)
See what you think
Bye the way, before you add too much more to the database, you need to take a serious look at the table structure
It will make your life a lot harder in the future if you dont sort it out now Database11.mdb
This is it but they need to type the Person_nbr in the Person ID field as it was originally. Is it not possible to accomplish both
Changed it back for you Database11.mdb
Featured Post
Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Suggested Solutions
| Title | # Comments | Views | Activity |
|---|---|---|---|
| Microsoft Access - limit entry to numbers and letters | 10 | 62 | |
| Outlook 2016 VB code syntax | 4 | 38 | |
| Error message for incorrect or missing hyperlink | 3 | 27 | |
| MS Access Duplicate Data Assistance | 9 | 25 |
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear? Sometimes you may have an additional problem: where the devil did they go? If you last had a popup form open…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Suggested Courses
Course of the Month4 days, 18 hours left to enroll
738 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.