Build a Query and add all fields from your Timesheet Table and EmployeeName from your Employee Table. The should be joined on EmployeeID. Make this Query the Record Source for your Form.

Julian

Don't add the EmployeeName field to the TCtable.  (remove this)

To create the query as Kevin stated:

1. On the Create Tab, select Query Design
2. Drag the EmpTable and TCtable into the blank space  (you can also just double click them)
3. Click and Drag from the EmployeeID from the EmpTable to the TCtable.  This will create a line showing these fields are related
4. In the bottom section, you can now select all the fields you want to display. (TimeclockID, EmployeeID, EmployeeName, TimeIn, TimeOut)
5. Save this query. (TCquery)
6. Use this as the recordsource on your form.

Hope this helps.

-Raymond

Thank you. Had to play around some but finally got it to work. Last time I worked with Access, late 90's early 2000's. Can't remember everything. Now to figure out how to turn time in/out to total hours worked and also show on query. I'm sure there is a video on it but if you would like to shed some light on the subject it would be greatly appreciated.

Timesheets
Employee Time Clock
15-Minute Increments
Total Time Spent

Thank you Kevin. I have another question that is probably right in front of me but after searching I have not been able to figure it out. How do I resize my form and table screens like in your videos. See photo.

See if this Overlapping Windows video helps.

Thank you Matt. That did the trick. I went into options but was unsure what to change or click on. I love when you can ask questions and get pretty fast response giving you just what you need.

No problem.  That's my favorite part about this site, too.

Hello again. I have ran into a problem that has me at stop. I am trying to set the Default Value for the Combobox in the time clock form to match/use the combobox in the main menu. When I type info into the default value box, "Forms" and "EmployeeCombo" will auto popup but my form name "MainMenu" does not popup like "MainMenuF" does in the video. It is as if my Forms can't be found or seen. See photo.

You are missing the Exclamation Points (!).

Example
    =Forms!CustomerF!CustomerID

Thank you Kevin. I saw there was something else there but I thought it was a straight line, above the backward slant key, which I tried and got errors. The eyes aren't what they use to be on small print. That might be something to point out during typing in the video for us old guys that have to squint.

Project completed and working but want to put some simple text directions on Main Menu on how to use the forms. I added a text box but I get an error and when checking results all text disappears showing only #Name?. I have researched the error trying many of the fixes even the fix of Ignoring Error but still get the error so I am turning to the best.

Is the text in the Control Source of the Text Box?
Is the text enclosed in quotes?
Did you start with an equals sign?

I created a text box and started typing. I see the text filling in the Control Source under Data and the error is saying Invalid Control Property: Control Source. No to the other two questions.

Either use this syntax: ="This is some text"
Or use a label.

Thanks Kevin. Works great. Learning all the ins and outs. Searching all the Internet I could not find the simplicity of your answer although knowing the answer is not simple.

I need the experts once again. I've created a form for my query but having an odd problem. The form shows one record out of five but I can scroll and see each of the five records one at a time. I have Continues Forms chosen and Data Entry set to No. If I choose Single Forms I see only one form with no scroll capability so it would seem that Continuous Forms is working. Some research indicates that it might be in my Join Tables Query but not sure. See photo as to how things look.

Shrink up the Detail section.

Thanks again. I did shrink it some and noticed that it made a difference but never all the way. I watched the videos on making a query form and making a continuous form template. After getting your response I went back and looked at making the template and sure enough Richard shrinks the detail section all the way up and even says it will get bigger as it fills with data! I think I was expecting it to be kind of auto like the query. I guess the saying applies, Lights on, but nobody's home!

I have been watching and working with the Archives Record video but not able to get it to work to well. I have two tables of info that I would like to archive and the video works with one table and just Contacts. I am trying to archive and delete all the info you see in my TC Query photo below. The EmployeeID and Name are in one table and the Time In/Out are in another. The minutes worked and hours worked are produced within the query. Not sure how to achieve this. The employer wants to start anew each week with the time clock info. It may not be necessary to archive if I can create a button to delete all records but would be good to archive.

All you need to archive are records from TCtables. You are not archiving employees.
When your current query runs it will display the records not archived.

Reading your response makes total sense. My frame of thinking is to include everything so everything gets deleted in the query which it may but not sure yet. For some reason when I do the datasheet view using only the TCtable I am getting a box to put in a parameter value. If I put in todays date it goes to datasheet view. I have setup and using an archive date <=Forms!TimeClockReport!ArchiveDate but it doesn't seem to see it. When I was trying to do this with join tables it didn't ask for a parameter value and went straight to datasheet view. What am I not seeing.

For your Query to see the field on the Form, the Form has to be open.

So simple I thought. When having to provide the parameter value the datasheet view showed all the records. Opening the form did solve the parameter value popup box but the datasheet view shows no records now. And if I click Run I get "Executing selected SQL text is only supported in the Monaco SQL Editor". No records are in the archive table.

Yeah, that Monaco editor has been giving people problems. It's come up several times in some of the MVP email threads that I'm subscribed to. It could be a problem with the Monaco editor. I know this is a long shot, but you might want to downgrade to a previous version that doesn't have it, like the last stable version. I'm still running version 2404 Build 17531.20152. It's been perfectly stable for me.

This is sickening. I have the Time Clock form working in every way that I want it except for being able to archive and delete. I bought Office 2019 because I don't care for subscription software. Subscription software is the very reason I am creating this Time Clock. I have a client that I have custom built all their computers, do their networking and designed and host their website so when their electronic time clock and its software aged out they ask me if I could help. The manufacture wants them to go to subscription time clock for $328.00 a month for five employees. Everything says Access 2019 does not have the Monaco SQL Editor. Then why am I getting an error for it. Its not available in Options to tick on or off and I tried some suggested code with no results. Their is no earlier version to go to with 2019. Does anyone know anything that can be done.

I don't believe it but I think I have figured out a way to get around the error for those that might encounter the "Executing selected SQL text is only supported in the Monaco SQL Editor" error. I created an archive query (Append) and a delete query of the chosen table. I chose the records to archive and delete but did not include any criterial and did not use an Archive Date. Created a DoCmd. button for both and upon use it put records in my archive table and deleted the chosen records. Now this may not be a WOW! for anyone but me but I'm happy. Even though it works for my Time Clock needs it may not work for others or other projects. I have to say I got the idea from watching the Archive Records and Delete Sample Records videos so thanks Richard.

Well, I'm glad you got it working. That Monaco editor message definitely shouldn't show up in Office 2019. It's a newer feature that's only supposed to be in the subscription (Microsoft 365) versions. No idea why it's popping up for you.

Personally, I do like the subscription model. I pay about $8/month and can install Office on five machines. Even if I don't upgrade often, I always have access to the latest features when I want them. Of course, that's not always a good thing. Like I mentioned, I'm still using an older build because of some recent bugs, but at least the option's there. I'd rather pay $8/month than shell out a few hundred every couple years.

That said, your workaround is totally valid. There are always a dozen ways to solve any problem in Access, so kudos for finding one that gets the job done.

One thing you might try: even though you're running Office 2019, it's still possible that an update pulled in part of the Monaco editor system by mistake. Office updates often patch shared components behind the scenes. I'd be curious - if you did a full uninstall and reinstalled from your original installation media without running Office Update, would that Monaco error still show up?

That's a lot of work just to answer a hypothetical... but if you care, give it a shot.

Yes, I am glad and I have no idea why it is popping up. Since I do not pay attention to subscription software I did not know that it could be that reasonable. Is that an everyday price for everyone? When I custom build a computer system most of my clients don't want subscription.

Good idea on the reinstall. I will try that when time allows or I may be putting Office 2019 on clients build and can try it there. I do have several websites waiting on me also.

Thank you for all your help. Great help I may add.

Each employee will clock in and out twice a day to cover lunch giving them each two different records. It will not be hard to add those two totals for the day but I was wondering if there is a way to auto add the sum of the two totals per employeeID. See the photo for example.

Yeah, it's very reasonable for a subscription price. Keep in mind your end users - if they're not actually modifying the database, they don't need to pay for access at all. You can just install the runtime for them.

As far as your total goes, you can do a running sum and then base the running sum calculation on the employee ID.