Search:

Type: Posts; User: Zvoni

Page 1 of 13 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    7
    Views
    185

    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...
  2. Replies
    7
    Views
    185

    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?
  3. Replies
    7
    Views
    185

    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...
  4. Replies
    9
    Views
    3,279

    Re: Remove NULL char's from a String

    I thought necromancy is frowned upon....
  5. Replies
    15
    Views
    310

    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...
  6. Re: Open module with text editor from Project Window's context menu

    He means: Put the word "Add-In" in the Thread-Title
  7. 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
  8. 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",...
  9. 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
    .
    .
  10. 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...
  11. Replies
    4
    Views
    306

    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...
  12. Replies
    9
    Views
    321

    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
  13. 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...
  14. Replies
    4
    Views
    206

    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...
  15. 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...
  16. 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
  17. Re: error replace text in word Doc. if textbox is empty

    Your Variable "ReplaceWith": what Datatype is it?
  18. 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: -->...
  19. 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
  20. Replies
    11
    Views
    248

    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...
  21. Replies
    11
    Views
    248

    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
    ...
  22. Replies
    11
    Views
    248

    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...
  23. Thread: Concurrency

    by Zvoni
    Replies
    2
    Views
    191

    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...
  24. Replies
    4
    Views
    206

    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...
  25. 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

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

    Looks like italian holidays.
    a simple SELECT to grab from Database
  27. Replies
    1
    Views
    197

    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,...
  28. Replies
    22
    Views
    612

    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...
  29. Replies
    22
    Views
    612

    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....
  30. Thread: Combobox default

    by Zvoni
    Replies
    6
    Views
    267

    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...
  31. Thread: Combobox default

    by Zvoni
    Replies
    6
    Views
    267

    Re: Combobox default

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

    by Zvoni
    Replies
    16
    Views
    434

    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)
  33. Replies
    10
    Views
    560

    Re: calculate benefits

    I didn‘t even look at his SQL.
    olaf‘s right: that sql doesn’t make a lick of sense. He‘s summing up the difference of a price to a value.
    But: not my problem if people don‘t use provided solutions....
  34. Replies
    10
    Views
    560

    Re: calculate benefits

    There is no confirmation, since it is the most simple math combined with basic joins
    i don’t need to test such simple stuff
  35. Replies
    2
    Views
    270

    Re: calculate in two tables

    Why are you cross-posting?
    You started the same thread in database
  36. Replies
    10
    Views
    560

    Re: calculate benefits

    And what output is it giving?
    it‘s always nice to know what‘s expected and what you get
  37. Replies
    10
    Views
    560

    Re: calculate benefits

    1) there is a mistake in your second table. Pur_total for sugar should read 30
    2) untested
    select sum(s.sal_qty*(s.sal_price-p.pur_price)) as Benefit from sales_tbl as s
    inner join purchase_tbl...
  38. Thread: W11 idiotic.

    by Zvoni
    Replies
    60
    Views
    1,266

    Re: W11 idiotic.

    Nahhhh…..
    nothing beats half a mile of endless paperstrip with holes in it
  39. Thread: W11 idiotic.

    by Zvoni
    Replies
    60
    Views
    1,266

    Re: W11 idiotic.

    I remember as a little boy in the early 70ies visiting my dad at his workplace (biggest freight carrier company in Germany at the time)
    he showed me around, and there was this huge room with a...
  40. Thread: W11 idiotic.

    by Zvoni
    Replies
    60
    Views
    1,266

    Re: W11 idiotic.

    Don't forget the "perforator" so we could use the second side of the Floppy-disk
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width