Dear people, good afternoon...
I have a form in msAccess with lots of controls and a specific routine must be triggered if the mouse_down event happens in any control.
Than I need to discover what was the control clicked and then, take an action.
In my case, I have a form and a subform inside it and the controls are inside this subform.
I have tryed to use the property form_mousedown, but when a lable is clicked, the event...
Ricardo de Mila
Last Activity: Jun 4 '23, 04:17 PM
Joined: Jan 30 '11
Location:
-
Ricardo de Mila started a topic Problems to capture mouse_down event on a control within a form with lots of controlsin AccessProblems to capture mouse_down event on a control within a form with lots of controls
-
Hello Rabbit and everybody else.
Thank you very much for the valuable support.
In the next days, I will try to test your code to try to meassure time differences.
Your code is very clear and appears to be a very nice solution for me.
It seems you gave the best answer for this question, But I really don't know how to mark it as "the best answer".
I feel this has been already done. Not sure.
... -
Hello everybody... Thank you very much for replying. Didn't expect to have some many answers here.
Let me try to clarify a little bit better what I'm doing and let me see if you can help me.
In my specific case, My interactions are taking more than 3 days to be completed.
The intention here is to have a simple criptografy process applyed into a file that is around 230MB long.
This big file is splited in blocks of 2MB....Leave a comment:
-
How to speed-up access to strings
Dear Bytes comunity...
I'm trying to speed-up the way I'm interacting with big strings.
I have an string with more than 2M caracteres and would not like to use the function mid$ to read, and change a specific character.
I'd like to use VARPTR or STRPTR, but I could not understand how to access the memory to get the content of a character directly.
Could somebody give me some help?
Best regards
Ricardo -
Dear twinnyfo...
Thank you for your valuable help.
I have understood your explanation and will test your options.
As soon as I have an exactly feedback I will post it here.
To satisfy your curiosity about why should the first form still be maximized, the explanation is:
The first form is a list of contacts with phones and e-mails etc. But the phone numbers can be showed in...Leave a comment:
-
Issues while maximizing or restoring forms
Dear Bytes community, good afternoon...
It can appear to be a very sily question, but I'm having problems while trying to restore the size of a form.
In my case I have already a form opened and maximized and when I click over a control I want a second form to be opened. But this second form must be sized as "Restored" and the first one must be kept as "Maximized" .
What is happening is that... -
Ricardo de Mila started a topic vbCrLF issues while trying to replace a sentence in a HTML e-mail model.in ASP ClassicvbCrLF issues while trying to replace a sentence in a HTML e-mail model.
Hello everybody, good morning.
Once more I come to you to request some help for VBA and other information.
This time, I am facing some problems to change a sentence in the body of an HTML e-mail due to the need of changing the line in the new sentence.
Please consider the following.
In my original .oft file (Outlook's e-mail model), the e-mail body contains a string that is "ItmLst".
...Last edited by Ricardo de Mila; May 19 '17, 01:11 PM. Reason: I have found the solution to the doubt. Want to contribute informing here. -
Dear ADezii...
Thank you very, very, very, very much!!!!! :-)
It solved my problem!!!!
Just to finish the question...
Is it possible to turn this macro into a VBA code?Leave a comment:
-
Is it possible to disable the CTRL-A key in Access 2013
Hello people...
I have a security problem in Access and I'm trying to protect it a little bit better.
The first thing I'd like to do would be to cancel the CTRL-A key that opens the Pannel.
Is it possible to do that?
Best regards
Ricardo de Milano -
Hi everybody...
Thank you very very much for helping.
I'm chewing all these information and will come back with news as soon as possible.
Thank you everydoby again.Leave a comment:
-
Is it possible to create a Exchange or email server in VBA under Access?Leave a comment:
-
Hi zmbd...
I'm not sure if I'm doing something wrong, but can't find the answer for my reply. could you please help me to understand where do I have to go to reach the correct forum if the answer is there?Leave a comment:
-
Hi Seth...
Is it possible to send an e-mail just using Access? I mean... I don't want use outlook and don't want to use Gmail or similars neither.
I'd like to have Access sending the e-mail straight from itself.
Is it possible?
Best regardsLeave a comment:
-
Hi Seth...
Thank you for replying.
Yes the error number -2147720973. But I have also tryed with the port number 587 and the result was the same.
I've heard that google is accepting just 465 and that's why I have tryed it.
I also have an information on my screen saying that the source of the error was on CDO.Message.1.
Thank you for helping.
Best regards
Ricardo de MilanoLeave a comment:
-
Hi Seth... Thank you for replying.
The error I got was:
"It was not possible to send the message to the SMTP server. The transport error code was 0x80040217.The server answer was 'not available'"
Translated from portuguese.
Best regards
Ricardo de MilanoLeave a comment:
-
Troubleshooting NonOutlook Email Code
(Split from: How to make Access to send an e-mail without using outlook. )
Hi Seth...
It has been a long time since you have answered my question. I've starting my studies using the outlook as a way to transmit my e-mails from Access and just now I tryed to use Gmail as the server.
But after copying the code of the link you have suggested into my code, I got the following error:
Fail in the conection of the transport...Last edited by zmbd; Sep 25 '16, 05:26 AM. Reason: [z{please use the [CODE/] formatting tool when posting VBA/SQL-scripts}] -
Ricardo de Mila started a topic if event Frm.Current is not triggered when recordset is empty,which one should I use?in Accessif event Frm.Current is not triggered when recordset is empty,which one should I use?
I'm not sure, but I think that the form.current event does not occour if the recordset is changed and coincidently it does not contain any data.
Is there any event that occour everytime the recordset is changed in a form even if the new recordset is empty?
Best regards
Ricardo -
Hello everybody...
I'm not sure I'm making a basic mistake, but here is my detailed problem and the concepts I have in my mind to originate the question:
I have a specific form FRMa00 with the field FLD1.
I have two other forms that are FRMb00 and FRMb01. The recordset for both FRMb00 and FRMb01 are the same there's a field FLD2 in this recordset. The filter is FLD2=FRMa00.FLD 1.
If I change the record in FRMa00, I have to...Last edited by zmbd; Jan 2 '16, 06:02 PM.Leave a comment:
-
Dear NeoPa... About the scenario that has originated by problem, please, keep in mind that there are a lot of information to be showed in just one form, so I have divided the showing in 5 forms. This causes some problems with sincronization and I was wondering if there is any "magic" function to say that two recordsets are exactly the same. I'm not sure if I understood what you mean about comparing both recordset.. Are you stating something...Leave a comment:
-
I really should have to had asked this to you before. I feel you are totally right. But now I will have a lot of work to correct my mistake. The tabbed controle would save me a lot of time.
Thank you Zmbd.Leave a comment:
No activity results to display
Leave a comment: