Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
Home > Forums > Access
Back to Access Forum    Comments List
Database Advice Upload Images   Link   Email  
Ina van Rooyen 
Hi Richard
I apologise for the lengthy message but I have to explain to you what it's all about. Hope it's clear enough.
We do a checklist for all the dogs each day, checking food, water, health, cleanliness, behaviour, etc (10 points in total)
We have, for example, 20 dogs and we have five pens that house four dogs each. We also have three mating pens and some whelping pens.
Once or twice a week we rotate the dogs.  Mating dogs are separated into different pens so do whelping bitches.
The check form should show the following:
-Todays Date
-Name of Dogs in one pen
-Pen Identification
-List of check items with a check box
I want to create a checklist form that the animal attendant can use from a notepad as she goes from pen to pen and tick it off.  
I was thinking of having a form with multiple lists/boxes where every list/box represents a pen.  If a dog change location, you just move it from one box on the form to another one  almost like moving records between two lists.  The difference is, there should be multiple lists or boxes.
The report will show each pen on a page with the dogs information in that specific pen.
This needs to be printed and displayed on the notice board.
I might expect too much, but do you have any suggestions on what the best approach would be.
Thank you so much!
Scott Axton 
How Do You Eat An Elephant?

There once was a village boy, just learning to hunt, with his father in Africa.

One day they were lucky enough to take an elephant.  
After seeing the size of the animal, the boy became quite concerned.

He remarked to his father, "This is so wonderful, but how will we ever get the elephant home, let alone eat such a HUGE animal?"

The wise old hunter just smiled down at his son and said, "One bite at a time son, One bite at a time."
Scott Axton 
Point  is -
Don't get so hung up on the end result that you forget to go back to the basics.
Get the yellow pad out, or index cards, or open a new file on your computer and plan out what you want and what you need.  
Then, just start breaking it all down into bite sized chunks - what info goes with what table?  
How do you relate them all together?  What kind of support ( Helper Data )
tables do you need?
How does this checklist tie into the overall data you are collecting? Are you better off just making a Word doc form?
90% of a database is done before you ever make a table or form or type a piece of code.
Richard Rost 
Scott is right. A lot of people have these huge plans for a database. I want it to do this and this and this and this... just start with the basics. Get your tables and relationships right first. Next, worry about your forms and the design interface. I'd set it up with Nested Continuous Subforms, but that's just me. You could use listboxes too. Moving a dog from pen to pen like you suggest would require a tiny bit of VBA and some SQL. But it's all do-able.

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

 
 
 

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: 3/28/2024 7:47:08 AM. PLT: 0s