Search:

Type: Posts; User: Zvoni

Page 1 of 13 1 2 3 4

Search: Search took 0.03 seconds.

  1. Re: I want the code to turn off the computer, can you help?

    Then read the documentation: https://learn.microsoft.com/en-us/windows/win32/api/winuser/nf-winuser-exitwindowsex
  2. Re: I want the code to turn off the computer, can you help?

    https://www.developerfusion.com/code/145/shutdown-restart-or-log-off/
  3. Re: Is there a verification code for this program installed on this computer?

    Just check the Registry
    For 32-Bit-Packages
    Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Windows\CurrentVersion\Uninstall\
    For 64-Bit Packages...
  4. Replies
    4
    Views
    156

    Re: add 2 element in array

    Untested


    Set RS = New ADODB.Recordset
    RS.CursorLocation = adUseClient
    'Debug.Print SQL
    SQL = "SELECT GG FROM CALENDARIO_FESTIVI"
    RS.Open SQL, CON, adOpenForwardOnly,...
  5. Replies
    4
    Views
    156

    Re: add 2 element in array

    And why are you sorting in code instead of sorting in the SELECT-Statement?
    btw: Depending on the range of (Date-) Values in your Recordset it might even be that you have to sort your array again if...
  6. Re: No longer being notified when someone responds

    I remember having the same problem some years ago with my GMX-Account.
    IIRC it was a misconfiguration of VBF having to do with a missing/wrong "tag" in its Mail-headers, so GMX denied acceptance of...
  7. Replies
    2
    Views
    76

    Re: Configuring IP Address

    Agreed, and i would set up the static IP-Address for the Printer from the Router/DHCP-Server, like:
    Printer connects to DHCP-Server
    DHCP-Server looks up MAC-Address of Printer in its own internal...
  8. Re: Looking for a simple function which returns TRUE if a string contains emoji ...

    Look at the StrSpn-API (the "A"-Version!!!) https://www.tutorialspoint.com/c_standard_library/c_function_strspn.htm


    Public Declare Function StrSpn Lib "SHLWAPI" Alias "StrSpnA" (ByVal lpSource...
  9. Replies
    7
    Views
    203

    Re: count a filled cell in colunn 4

    Agreed. I don't see the sense in "counting" a column of Dates until you hit "empty".
    If you just want to find out, what's the Last day of a Month


    'LDOM = LastDayOfMonth
    Function LDOM(ByVal...
  10. Replies
    7
    Views
    203

    Re: count a filled cell in colunn 4

    MSFlexGrid is basically like an Excel-Worksheet (or 2D-Array)
    How would you look there in a specific Column if it has an entry or not?
  11. Replies
    7
    Views
    203

    Re: count a filled cell in colunn 4

    Not possible without loop,
    except the source of the Grid (ListView?) is a SQL-Statement

    btw: "without to loop the row" --> Why loop "a" row? Do you mean to loop through all rows?

    What does...
  12. Replies
    9
    Views
    3,312

    Re: Remove NULL char's from a String

    I thought necromancy is frowned upon....
  13. Replies
    15
    Views
    334

    Re: This code doesn't wok in 64bit

    You could start with reading the documentation:
    Most important: The compile Constants VBA7 and WIN64 --> Nowadays you only need WIN64 to check if your Office is 32- or 64-bit...
  14. Re: Open module with text editor from Project Window's context menu

    He means: Put the word "Add-In" in the Thread-Title
  15. Re: How to delete consecutive blank lines in richtextbox

    You should "Trim" the lines. A line having only spaces would appear to be "blank" but is not
  16. Re: Best Alternative to VB6 for teaching and training

    After close to 20 years of vb6/vba i didn't had much problems to switch to Freepascal with Lazarus as the IDE some 4 years ago.

    Yes, Pascal is different with its Syntax-Quirks ("Begin.. End",...
  17. MsOf365 Re: Excel365 64-Bit - Filter removes SeriesCollection from Chart

    Quick update:
    I've kinda "solved" it by adding a line to the vba-code


    Dim ns As Series
    .
    .
    'Delete all Series from Collection in a loop
    .
    .
  18. MsOf365 Excel365 64-Bit - Filter removes SeriesCollection from Chart

    Hi Folks,

    noticed something "weird"

    I have a workbook with two sheets
    Sheet 1 has a "standard" Worksheet with regular columns and rows, conditional formatting, formulas and what not (what you...
  19. Replies
    4
    Views
    313

    Re: Webcam copy & Paste

    The Common Dialog doesn't have anything to do with that. It just provides a UI to set properties (FileName etc.)
    With or without Common Dialog you have to grab your frame, put/copy it to a...
  20. Replies
    9
    Views
    323

    Re: problem reading registers open for random

    Here's your problem:


    For c = 1 To n

    Get #Canal, , tk


    List1.AddItem vbTab & tk.Id & vbTab & tk.Name & vbTab & tk.Date
  21. Re: error replace text in word Doc. if textbox is empty

    And there is your Problem.
    If the Column the Textbox is bound to is Numeric/Integer, but doesn't have a default value, then any new inserted Record, which doesn't fill that column with an...
  22. Replies
    4
    Views
    269

    Re: Grid-like Userform

    Well, i was thinking about how i would do something like this, and i'd probably go down the route to use CommandButtons which are named:
    cmd00 -- Top-first (from the left)
    cmd01 -- Top-row second...
  23. Re: error replace text in word Doc. if textbox is empty

    Wait a second.
    you said access.
    is that textbox bound to a column in a table?
    because that’s the only thing coming to mind to cause a textbox being „null“
    i don’t have that much experience with...
  24. Re: Best practices to check if an array is empty

    https://www.vbforums.com/showthread.php?896856-RESOLVED-Create-an-object-array-with-a-length-of-zero-(or-UBound-1)&p=5572569&viewfull=1#post5572569
  25. Re: error replace text in word Doc. if textbox is empty

    Your Variable "ReplaceWith": what Datatype is it?
  26. Re: Best practices to check if an array is empty

    Do you mean if a dynamic Array is actually dimensioned (As in ReDim-med)?
    I think we had something similar some weeks ago.....

    EDIT: Found it: -->...
  27. Re: error replace text in word Doc. if textbox is empty

    Have you tried to fully qualify your Textbox?


    FindText = "[Pd1xxx]"
    ReplaceWith = Me.c169_Pd_value.Text '<---
    .Execute FindText:=FindText, ReplaceWith:=ReplaceWith, Replace:=2
  28. Replies
    11
    Views
    263

    Re: prevent typing html

    Just saw this:


    txtNick = Replace(txtNick, char, "")
    Maybe a stupid question: Does this trigger the Change-Event (recursively?)?

    After reading the thread again, i'd rather go for the...
  29. Replies
    11
    Views
    263

    Re: prevent typing html

    you could use a global/module-level Boolean "FromButton" which you set to True in the Button


    Private FromButton As Boolean


    Private Sub Button_Click()
    FromButton = True
    ...
  30. Replies
    11
    Views
    263

    Re: prevent typing html

    Haven't understood OP's answer, too.

    BUT: Arnout's idea is "dangerous". What if the user wants to enter something like "... If var<6 Then..."? Arnout's idea would prevent it.

    Bottom line from...
  31. Thread: Concurrency

    by Zvoni
    Replies
    2
    Views
    196

    Re: Concurrency

    My first try would be:
    1) Start Transaction (To get isolation, preferably serializable)
    2) SELECT Min(RefN) As MinRef FROM RefNum WHERE available=1 --> get the lowest available RefNum
    2a) If none...
  32. Replies
    4
    Views
    269

    Re: Grid-like Userform

    This is going to be a PITA, since in Office VBA there is no FlexGrid and no control-array out of the box, nevermind 32-Bit vs. 64-Bit Office
    Bottom Line: Create it yourself from controls which have...
  33. Re: FILL listview or msflexgrid b ased year variable

    'provided data IS of DataType DATE, and not string, text, socks, girlfriends, whatever
    SELECT data, giorno, festivita FROM holidays
    WHERE Year(data)=" & CLng(ComboBox1.Text) & " ORDER BY data

    ...
  34. Re: FILL listview or msflexgrid b ased year variable

    Looks like italian holidays.
    a simple SELECT to grab from Database
  35. Replies
    1
    Views
    199

    Re: Need help with app idea

    Since JSON is (more or less) "hierarchical", TreeView comes to mind, which implies your best bet would be code traversing the nodes (recursively?).

    JSON knows 6 types of "elements"
    Null, Boolean,...
  36. Replies
    22
    Views
    618

    Re: C POINT Data Type passed ByRef in x64 ?

    Correct me if i'm wrong, but that works because of memory alignment in this case:
    A struct with two longs has the same memory-layout/alignment on the stack as two consecutive long-arguments.

    The...
  37. Replies
    22
    Views
    618

    Re: C POINT Data Type passed ByRef in x64 ?

    In this particular case: What's wrong with passing the POINTAPI-Structure as byRef? The Api doesn't change the Value, it returns a boolean

    And don't use "LongLong" in your Declares. Use LongPtr....
  38. Thread: Combobox default

    by Zvoni
    Replies
    6
    Views
    274

    Re: Combobox default

    You're asking "Debug" to print a boolean expression....


    Option Explicit
    Option Base 1
    Dim x As Integer
    Dim Month(12) As String
    Dim MonthSelected As String
    Dim Day(31) As String
    Dim...
  39. Thread: Combobox default

    by Zvoni
    Replies
    6
    Views
    274

    Re: Combobox default

    ListIndex=-1 means "unselect all/any", so it implies ListIndex=0 being the first item of the List
  40. Thread: Ancient History

    by Zvoni
    Replies
    16
    Views
    442

    Re: Ancient History

    Try RPG.
    I've seen RPG-Source-code, once!
    I think after reading 2 or 3 lines of it i was going cross-eyed (with c-code i at least "manage" to read 5-6 lines before going cross-eyed :D)
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width