Search results

You need to know what kind of event it is because for breakfast you have half an hour, so if you go over that half hour, it only counts half an hour. The same with the lunch break: they give you half an hour. I clocked in at 2:30 p.m. and clocked in again at 2:31 p.m. and I had 29 minutes left...

The subtractions that are made between each of the types, have to follow the rules of the first post, because it is how it later appears in my work time record.

Hello, sorry. I explain. If you enter FCalendario, and double click on March 8, you can see an example of the hours. It is in Spanish, but here is its meaning in English: entry (entrada) breakfast start (inicio del desayuno) breakfast end (fin del desayuno) lunch start (inicio de la comida)...

Good afternoon. I have a table with start and end times for work, and, in between, stops for breakfast and lunch. I have created a dropdown with the type of time record: entry, breakfast start, breakfast end, lunch start, lunch end, and output. Now what I have to do is subtract: breakfast...

Ok. I take note. I'll tell you about the results.

Yes, but my idea is to simplify it as much as possible. I mean, I would remove the weekly and daily view, which is useless in my case, so I would no longer need to store two dates for each record.

I saw your comment, but then I discovered the database that @MajP proposes, and I think it is more suited to what I'm looking for.

Thank you very much for your suggestions. I find it interesting to prevent an output without an input in the first place. What I see unnecessary is to give a start time and an end time. It seems to complicate the life of the user, in addition to saving information that I am not going to use at...

Ok. I take note. I cannot put a check so that there is only one entrance, because we have to make a half-hour stop and we have to clock in when we go out for breakfast and come back. That is to say: 7:30 Entrance 11:30 Departure for breakfast 12:00 Entrance after breakfast 14:00 Departure And...

Now, I have seen how it works and at first glance it seems easy to adapt it, because what I will do is simplify the appointments. What I don't know is if I'll have problems with the code, that there's something I don't understand. Beyond that, I don't think it's necessary, because this will be...

@MajP , where can I download this calendar? I can't find the post you shared and I can't find it on the Internet either. I don't care if I have to buy it, but I'm interested. They do have an application to record time, but it does not allow you to plan your day to find out if you are meeting...

I explain. I am a civil servant, and the Administration and I have a working day of 37.5 hours per week, but the calculation is made monthly by the Administration. Therefore, I have to, as you say, time the hours I dedicate to work, which an internal application tells me when I clock in and out...

Good night. I have searched this forum for examples of calendars, and I have found this attached majP that more or less adapts to what I am looking for. What it lacks is that it can add the hours that I record each day when I enter and leave work, in such a way that it later allows me to...

Thanks, @arnelgp. It works for me.

Ok, thanks. The code is based on an example that I got in Microsoft Help. I have to change recordset to recordset lone and put your code in the criteria.

Hello. I have a table where I keep the days on which a given event occurred. What I want is to search for a specific date (I have done this), and, if it does not coincide with any of the saved dates, search for the closest previous one. For example: 4-jan-22 6-jan-22 9-jan-22 13-jan-22 If I...

I appreciate your effort, @MajP . I think I'm going to use the simple form. Like @The_Doc_Man says, it's better to create a demo form with basic code. That's what I'm doing now: a demo database with basic features that I can use to create a database and save time, not doing from scratch.

That's amazing. Do you think it's worth to do all that only for not to write a couple of lines in each form?

I will wait, don't worry. Thanks

I'm looking at the page and I can't find how to do what you are doing. Could you show an example that I can apply?