Computer Learning Zone CLZ Access Excel Word Windows

It is impossible for a man to learn what he thinks he already knows.

-Epictetus
 
Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon  
 
Home > TechHelp > Access >
TechHelp


Back to TechHelp
 

Very Difficult form Upload Images   Link  
Maarten Brusselers 
29 days ago
I hope someone can point me in the right direction here but I might be going all wrong about this.  My staff uses an excel sheet to keep track of which days each of the farm staff works every month. I have attached a screenshot of the excel sheet they use.  I have created a form to simulate the excel sheet as they are used to it and like it. The dates are now completely automated with =DATESERIAL. Our salary month runs from the 29th till the 28th of every month as shown in the screenshot.  This part works fine.  My problem is the bit where you enter the ones, halves and zeros for having worked that day in full, half or not.  It is no problem to create the text boxes but how do I get the right date with the right employee and work value into my table.  I can't see how to query this thing.
Maarten Brusselers
29 days ago

Maarten Brusselers
29 days ago

Maarten Brusselers
29 days ago

Maarten Brusselers
29 days ago

Maarten Brusselers
29 days ago
I've put empty text boxes in the form but when I enter a number it the top box the whole column takes on that value.  When I then enter a new value in the box below the same thing happens.  It is a continuous form
Maarten Brusselers
29 days ago
The staff fields come from a query.
Juan C Rivera
29 days ago
Take a look at Project Management Template.
Richard even has a sample database that you can try and see if you like.
Kevin Yip
29 days ago
Hi Maarten, you need a crosstab query, which transposes some of the rows into columns, so you can create that look with ease.  But a crosstab query is uneditable, so you can't use it on a form for data entry.  A crosstab query is strictly for display purposes.  You need a more conventional form for data entry.  See pictures below.
Kevin Yip
29 days ago

Maarten Brusselers
29 days ago
Hi Kevin,
Thanks once again.for your help.
I'm at expert 15 now so I didn't get to Crosstab Queries yet. So there is no way that I can use this form format for data entry. I was hoping that with the the right SQL and VBA it could be made to work. Using a conventional form for for data entry is a lot more labor intensive.
Kevin Yip
29 days ago
You can use VBA and/or append queries to automate entries of some of the repeated data, such as names.  But yes, Access tables must be normalized, and a crosstab format is not.
Maarten Brusselers
28 days ago
Hi Kevin,
I've made a new form that should work but now run into another problem.  The Day field in unbound with a default value of 1.  However, whenever I change the value in the field all the values in this field for the other employees change as well. I cannot give them an individual value. I want to use this form with an append query.
Maarten Brusselers
28 days ago

Maarten Brusselers
28 days ago

Kevin Yip
28 days ago
An unbound field can only have one value for all the rows.  It's like a label; it can only be one thing.  You need a bound field if you want the rows to show different Day values.
Maarten Brusselers
28 days ago
So I can basically bound it to anything as I will be using an append query based on the form values, right?
Kevin Yip
27 days ago
If it's bound, that means it needs to be an actual field in a table or a query, so not exactly anything.  Sometimes I would create a dummy field (or even dummy table) just to make certain tasks possible.  Form design is an art, not a science, and it should be done to make data entry as easy as possible.
Add a ReplyUpload an Image


Back to TechHelp Comments
 

Start a NEW Conversation
 
Only students may post on this page. Click here for more information on how you can set up an account. If you are a student, please Log On first. Non-students may only post in the Visitor Forum.
 
Subscribe
Subscribe to TechHelp
Get notifications when this page is updated
 
 
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
amicron@gmail.com
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn