Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
Home > Forums > Access
Microsoft Access Forum

Welcome to the Microsoft Access Forum. Access is by far our most popular topic here at Computer Learning Zone. This forum is for everyone to read but only students (paid customers) can post here. If you'd like to become a student, all you have to do is enroll in one of my courses. After you create a logon, you will have full access to the Forums.

Subscribe to this forum and receive an email update whenever new posts are added. You will also be notified by email if any conversations you are involved in receieve new comments. Yes, even non-students can subscribe to update notifications.

Having problems with your Access database? Before posting your question, check to see if it's already been answered. You can use the Search feature to look for keywords. There's also the Access Troubleshooting Checklist which covers solutions to many common problems. If neither of those things help, make sure you post exactly what you're doing, what the specific error message is, what you've tried, and any other details we might need to help you. Don't just say, "I get an error." Tell us what the error is and what you're doing. We're not mind readers. I wish. LOL

NEW: Access Developer Students, make sure you subscribe to the Developer Student Forum.

Click Here to Post a comment and start a new discussion


Form to display total hours Upload Images   Link 
Michelle Seidelin 
5 days ago
Hello Richard

I have just made a time Clock like you show in expert 11 listen six my question is it possible to get a total for hours to display at the bottom of query or do you need to make that totaling query when you want to display this in a form or can you feed the query as shown in expert 12 listen 2 you are showing  demonstrating how to A timesheet which I'm using to work out how long it takes for how many hours of video when I have multitaps then one job this information is not going to be kept permanently after I have calculated how many hours I will eventually use a delete query to empty ready for the next job best will be in a form like you show an expert level 12 listen 2 but I need to be able to have a look at the title  like the query you made at the end of expert 11 listen six
Michelle Seidelin
4 days ago
Hello Richard.

Just wondering if there's a way of showing minutes rather than .5 for 30 minutes an expert level 11 listen Six I know there was a tick help video showing this sort of thing but not sure if that information can be combined into this query which was designed as I see it an expert 11 listen 6 that is when where you created the work log table and work log query
Michelle Seidelin
4 days ago
Richard I realize .5 is half an hour but when you say something like .25 it is harder to workout in your mind well for me it is yes that would be great to show minutes like your latest tech  help video showing it in hours in minutes don't know if we can combine those two ideas into this query any suggestions and advice you can give me would be greatly appreciated
Richard Rost
4 days ago
1 hour is 60 minutes, right? So if you have hours and you want minutes: H*60.
Adam Schwanz
4 days ago
Am I right that you're trying to convert hour values into minutes? What Richard said will convert your hour value into minutes, and then you could also do something like =[TotalMinutes]\60 & Format([TotalMinutes] Mod 60,"\:00") and that will return a value like 6:40 (6 hours, 40 minutes) for 400 minutes if you're looking for that kind of format.
Michelle Seidelin
4 days ago

Michelle Seidelin
4 days ago
Hello Richard

I am looking for a way of filtering the work log form as I'm able to type a number EG 5 in an click a button and it will filter the current customer to just show a job number I entered this has been modified from the form that you teach an expert level 12 listen 2 as I'm able to show which Beaver job number I want with the click of a button on the form I have uploaded a photo of my design at this stage the photo shows only one job but the reason for versa is that I didn't have anything else written an at the time plus I changed my mind how to do things as I went through the video more and more
Richard Rost
3 days ago
See Time as a Duration. Also I have a function called HowLong which is in the Code Vault that will give you an exact readout like "3 hours, 15 minutes, 12 seconds."
Michelle Seidelin
3 days ago
Hello Richard thank you wondering if you have a VIDEO  demonstrating hey this code vault code how long does work and F it would be compatible with what we built and level 12 also does it need any other information put into queries for this

Richard Rost
3 days ago
I don't have a video specifically explaining how to use every function in the Code Vault, no. If you're not comfortable with using subs and functions, then keep watching the Developer series. I may do a video on the HowLong function specifically because it is one of the more popular ones. It's on the list. Not sure when though.
Michelle Seidelin
3 days ago
Thank you
Richard Rost
3 days ago
See if this video has what you need: Time Spent.
Add a Reply

Show All Comments

Start a NEW Conversation
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

You may want to read these articles from the 599CD News:

2/24/2021Access Developer Forum
2/24/2021Widows & Orphans
2/23/2021Access Runtime
2/22/2021Table-Level Validation
2/20/2021Not Updateable
2/19/2021Filter Records
2/18/2021Access Developer 26
2/17/2021Access Developer 27

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Account Login
Online Theater
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: microsoft access forum  PermaLink