Search results

  1. MsAccessNL

    How to prevent a Keyboard Hack?

    I am totally shocked. Is it really so easy to hack someone's keyboard entries? With just one api it's possible to see everything i type, all my private emails, passwords on sites. I tested my banksite and it records every entry, everything you type in any programm. This api can also be used with...
  2. MsAccessNL

    Introducing me..

    Hello,welcome to the group. I personnaly wouldn't start with a template. They often have strange behaviour. They are also very outdated. Do you have experience with vba?
  3. MsAccessNL

    Assign class module to Form controls

    Hello Majp, I react to this old feed. I don't succeed to get your code working. If I add a HelloWorld funtion it works, but it doesn't pick up the Event Procedure. I am using Access 2010 and had to adept the form load code: Private Sub Form_Load() Dim ctl As Access.Control Dim MyTasks As...
  4. MsAccessNL

    Textbox can act like "Combo Box"

    The easiest way is to put a small subform control over the drop down arrow and put in the Combobox on focus event me.Combobox dropdown..
  5. MsAccessNL

    Textbox can act like "Combo Box"

    put on focus of txtRecipient me.cmdRecipient.borderstyle = 1 and me.subform.visible = true the listbox is not a listbox but a subform with shade effect.
  6. MsAccessNL

    Random Crash of Access 2010

    It's probably an update of Windows itself that causes Access to crash. Take a look at Devhut.net, there are a lot of the update bugs.
  7. MsAccessNL

    Sendkeys makes Numlock Toggle in RunCode Module

    It's a litte bit better. When numlock is on it stays on (it seems), but when numlock is off it turns back on (thats oke) but the run after it turns back off. I noticed that the CheckNumLock code is ready before the Sendkeys are executed. May be there is an order of excecuting code. First the...
  8. MsAccessNL

    Sendkeys makes Numlock Toggle in RunCode Module

    Tried it , same outcome...
  9. MsAccessNL

    Sendkeys makes Numlock Toggle in RunCode Module

    I have this Runcode module that i use a lot with coding. You can run a private event in the vbe editor. It only toggle the Numlock on and off. I tried a lot (with the code from this forum). I narrowed the problem down. The CheckNumlock function works, stand alone, but in the code beneath it...
  10. MsAccessNL

    Solved Copy and paste telephone numbers.

    For who is interested, the GetNumber function: Public Function GetNumber(sNumber As String) As String Dim s As String, sTemp As String Dim i As Integer 'x = " (212)-555-12.12) " For i = 1 To Len(sNumber) sTemp = Mid(sNumber, i, 1) If IsNumeric(sTemp) Then s = s &...
  11. MsAccessNL

    Solved Copy and paste telephone numbers.

    Great that you solved your problem! You inspired me to turn your code into a general character remove function: sRemove can hold any length of characters like ("_,@,%") Public Function MyRemover(sInput As String, sRemove As String) As String Dim i As Integer, s As String Dim aVal As...
  12. MsAccessNL

    Passing Variable from Form to Query using Click on Label Caption

    if you are going to use the pagename for your tempvars, you probaly can use: Tempvars!pagename = Label19.Caption & ".jpg" or just ..pagename= "xxxx.jpg" or put the name in the tag property of the label: ...pagename = Label19.Tag or replace the labels with buttons now you can use: ...pagename =...
  13. MsAccessNL

    Linking to multiple CSV files and renaming tables without ".CSV"

    You can also import textfiles with SQL directly, may be it can shorten your code ( i love short codes). SELECT * INTO NewTable FROM [Text;HDR=Yes;FMT=Delimited;Database=C:\Users\Daniel\Documents\Test].TestFile.txt
  14. MsAccessNL

    Help in refreshing/repainting a form and passing updated data to another form

    Hello Majp, A small side question. How do i get my table/query headers look like yours with the color and the blue line. Or is this a continuous form?
  15. MsAccessNL

    How to contact the administrator

    it's solved by the Docman, there was an ,outcommented, url link in the code.
  16. MsAccessNL

    Best help for depression

    that’s definitely step 1, don’t watch the news! Why? When you are depressed you are living in a survival state, your body is in a constant state of fear. Adrenaline and cortisol are ruling your world. Now your subconscious thinks that everything and everybody is a danger, even your own family...
  17. MsAccessNL

    Convert PDF to Doc

    There are alse versions of Excel where you can read pdf with Power Query...
  18. MsAccessNL

    Convert PDF to Doc

    I got a similar problem with stack overflow, i can't post anything any more. Do you have any tips?
  19. MsAccessNL

    Convert PDF to Doc

    Thnx DocMan, or Superman! There was (outcommented) url in the code. Really happy with your quick reply!
Back
Top Bottom