Search results

Wait a moment, let me explain. I have taken that code as a reference, but I have only taken the lines where it gives value to the SQL statement and then executes it. I have removed everything else, even Next. I have done the latter because of the relationships between tables. Thus, I have...

Hello. I found a code to delete all records from a database: Public Function empty_tables() As Boolean '====================================================== ' Author: wongm003 ' Use to empty all visible tables in current database. ' ' Note: if you do not want to prompt the user for each '...

All done. I leave point 1 with a procedure to place the cursor at the end of the text and if the field is null, so that there is no error, I put it at the beginning. I discovered point 2 was because it had the OnClick event, which was distorting its operation. It was deleted and this point was...

Can you tell me how to do it please? Thank you so much. See Point 2 (Video) As you can see in the video, and then check in situ with the database that I attached previously, when I select text, and then try to click on some part of it, it does not undo the selection. Hence it asks how to know...

I am creating a class module to manage mouse movements in a textbox and the ribbons that should appear in rich texts. I have some questions: 1. How can I use VBA to set the option to place the cursor at the end of the text that can be set in the Access options (Client Settings)? This way, I...

Hi, yes of course. Look, the Instagram account is https://www.instagram.com/el_informal_fan/ And the video in particular is this: https://www.instagram.com/p/CiqOSJVDRRi/ He talks about the High Speed Train (AVE), making a parody about the project they wanted to do. You have to know Spanish...

Thanks to all. I have found it in Instagram.

https://www.youtube.com/watch?v=2blkHYq5aEo

Anybody else?

Thank you very much for trying. I would like to give you the lyrics in English, but I think it would lose the joke a lot, besides that you would have to know a little about the culture of Spain to understand what it says. Regarding the blocking, is there anyone in the US room who can test?

Hello people. I wanted to ask you for help. I'm looking for a video of a sketch from a program that was broadcast in Spain at the end of the 90s. I found it on YouTube, but it's restricted by copyright, something I don't understand why because there are more videos of sketches from that...

What I do is write down the beginning of each of the events. I can't know, when I clock in, if I'm going to be working 2 hours or 1 hour, or if the break is longer and you only have to count half an hour... For this reason, I only want to manually note the start. Since @MajP recommended saving...

Can you tell me how to get the start date of the day, which is in the first record, and the last one, which is in the last record?

Yes, you are right, but I don't know how to get the start date of the day, which is in the first record, and the last one, which is in the last record.

If your idea of three events seems ideal to me, and I think it's the right thing to do. However, you have taken a date that I do not know. I'll give you an example: I arrive at half past seven, and I register it as an entrance. At this point, I don't know when I'm going to stop. At eleven, I...

@Pat Hartman, I'm not the one making the rules. I work for the Government, and this is the one that sets the rules that govern the working hours of civil servants. I'm just trying to copy the method to use to calculate the hours, hence I have to have those details.

Several things: 1. You are taking the start and end date, and I have it set to calculate the end date by adding one minute to the start date. Reason? The goal is to record the hours, and when you punch in, you don't know when you're going to go out, or have breakfast, noon, or lunch. I should...

Yes, but I have several doubts: 1. How do I get the values of the above fields? You could use DLookUp, but that would slow down the computation. 2. How do I configure the rule that I put in the first post for breakfast and lunch? At breakfast the half hour is added (if you are more, you have to...

I think it's a good idea.

Here you have the database with all my records for the month of March. I am also attaching the Excel with the values that the database should obtain.