Computer Learning Zone CLZ Access Excel Word Windows

The more time they take deciding, the more money they will spend.

-293rd Rule of Acquisition
 
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
Home > TechHelp > Access >
Back to TechHelp    Comments List
Very Difficult form Upload Images   Link   Email  
Maarten Brusselers      
2 years 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      
2 years ago

Maarten Brusselers      
2 years ago

Maarten Brusselers      
2 years ago

Maarten Brusselers      
2 years ago

Maarten Brusselers      
2 years 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      
2 years ago
The staff fields come from a query.
Juan C Rivera              
2 years 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       
2 years 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       
2 years ago

Maarten Brusselers      
2 years 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       
2 years 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      
2 years 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      
2 years ago

Maarten Brusselers      
2 years ago

Kevin Yip       
2 years 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      
2 years 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       
2 years 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.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in TechHelp.
 

 
 
 

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
PCResale.NET
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
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 7/25/2024 12:52:01 PM. PLT: 1s