Search:

Type: Posts; User: Zvoni

Page 1 of 13 1 2 3 4

Search: Search took 0.04 seconds.

  1. Thread: TwinBasic

    by Zvoni
    Replies
    973
    Views
    374,560

    Re: TwinBasic

    We already have that.
    His name is Wayne Phillips....
  2. Replies
    12
    Views
    394

    Re: How To Parse WMI Return

    My solution:
    No hassling around
    Filter-Function works as "Contains" or "Like". That way i can ignore the "_0" in sInstances
    No Error-Checking whatsoever


    Sub main()
    Dim sDevices(2) As String...
  3. Replies
    12
    Views
    394

    Re: How To Parse WMI Return

    Well, then.....
  4. Replies
    12
    Views
    394

    Re: How To Parse WMI Return

    Enum the Monitors, and then use GetMonitorInfo -->
    https://docs.microsoft.com/en-us/windows/win32/api/winuser/nf-winuser-getmonitorinfoa
    with MonitorInfoEx...
  5. Replies
    17
    Views
    525

    Re: Organization of VB6 Source Code

    Like a constant array? :D
  6. Re: Access Print to pdf and lock pdf after printing

    PDFCreator offers a COM-Interface
    https://docs.pdfforge.org/pdfcreator/en/pdfcreator/com-interface/
    and you can set Security from code (sample is in JavaScript)...
  7. Re: Access Print to pdf and lock pdf after printing

    You are contradicting yourself.
  8. Re: Help Navigating Through WMI Service (winmgmts)

    Here's the Description: https://docs.microsoft.com/en-us/windows/win32/wmicoreprov/videomodedescriptor

    Basically, it's an Array, so you can run LBound to UBound through it, and then access the...
  9. Replies
    9
    Views
    196

    Re: Running Macro Based On Checkbox

    Ahh....Crap.
    IIRC, only ActiveX-Controls can be addressed like above.
    The "other" controls i'd have to look up how to address them (been a long time for me...)
  10. Replies
    11
    Views
    332

    Re: sqlcmd command not found server ?

    On your Win10-Machine, open a CMD with Admin-Rights, and try sqlcmd -L again
  11. Replies
    17
    Views
    525

    Re: Organization of VB6 Source Code

    In Lazarus/Freepascal i like the Unit-System

    Write your own Unit with Functions, types, Classes (multiple classes per Unit!), Constants, dirty socks, discarded girlfriends, whatever.
    You can put...
  12. Replies
    9
    Views
    196

    Re: Running Macro Based On Checkbox

    untested


    Sub REVERSE()
    Dim ws As Worksheet
    Dim MAIN As Worksheet
    Dim LastRow As Long
    Dim K As Long
    Set ws = Sheets("agility")
    Set MAIN = Sheets("Main")
  13. VS 2019 Re: Re-seed SQL database table via APP

    drop table if exists ?
  14. Replies
    13
    Views
    242

    Re: Print barcode on Datareport

    *sigh*
    You've created a DataReport
    You've created it in A4-Size (297mm x 210mm)

    That Label-Printer has smaller "Paper"

    Have you ever tried to put 4 Liters of Water into a 0.5 Liter-Bottle?
  15. Replies
    9
    Views
    196

    Re: Running Macro Based On Checkbox

    Your problem is the "MAIN"
    Is the Sheet-Object called MAIN, or is the Name of the Sheet MAIN? (Those are two different things)
  16. Replies
    13
    Views
    242

    Re: Print barcode on Datareport

    Ask your friend or read the manual to the labelprinter
  17. Replies
    13
    Views
    242

    Re: Print barcode on Datareport

    Well, and there is your problem.....
  18. VS 2019 Re: Re-seed SQL database table via APP

    I agree with Chris: This sounds like a nightmare.

    Question: Does the Data on the Spreadsheets have a unique identifier?
    And i'm not talking about a Primary Key as in a database (though it could...
  19. Replies
    13
    Views
    242

    Re: Print barcode on Datareport

    Uh, No, since i don't have a clue which Label-Printer this buddy of you uses.
    At a guess, you print your barcodes on your Canon-Printer in A4/Letter
  20. Replies
    11
    Views
    332

    Re: sqlcmd command not found server ?

    No, you don't (or at least only in the lower screenshot)
  21. Replies
    13
    Views
    242

    Re: Print barcode on Datareport

    YesYes
  22. Replies
    9
    Views
    196

    Re: Running Macro Based On Checkbox

    Stab in the Dark: Don't use ActiveSheet
    And there is an End if missing


    Sub REVERSE()
    Dim ws As Worksheet
    Dim LastRow As Long
    Dim K As Long
    Set ws = Sheets("agility")
    ...
  23. Re: Double click .SQL file open in extant instance in SSMS

    Are you running SSMS as Admin?
    https://stackoverflow.com/questions/7123365/how-to-open-multiple-sql-files-in-only-one-ssms-instance
  24. Replies
    11
    Views
    332

    Re: sqlcmd command not found server ?

    The upper is executed in a cmd-window for standard-user,
    the lower has admin-rights?
  25. Replies
    28
    Views
    574

    Re: [RESOLVED] First workg day of Month

    A step to the right?
  26. Replies
    28
    Views
    574

    Re: [RESOLVED] First workg day of Month

    I actually did until the Covid-Crap, well at least it was the "first day of the year" :-)
    Starting December 2017 i've been to California to skydive every new year.
    We called it the "New Years Day...
  27. Replies
    28
    Views
    574

    Re: [RESOLVED] First workg day of Month

    Uh, no.
    I know it from my day-job, that there are things i only have to do on the first working day of a month.



    The OP's a Member since 2013.
    This would be a very long overdue homework.....
  28. Replies
    6
    Views
    319

    Re: Get chart datarange

    So basically, you want to find the Last Row in Excel using VBA? *hint hint hint*
  29. Replies
    4
    Views
    160

    Re: Save Image to Database TSQL issue

    Cheers wqweto.
    Since i've never worked with MS-SQL-Server (and thusly with TSQL), i didn't know that, so my "img.* " was kinda of "be on the safe side" (as safe as it can be)
  30. Replies
    11
    Views
    332

    Re: sqlcmd command not found server ?

    From: https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility?view=sql-server-ver15
  31. Replies
    28
    Views
    574

    Re: [RESOLVED] First workg day of Month

    Even if "resolved".
    The way i would go about it (at least at first glance):
    1) You need a Data-storage (Textfile, Database, sockdrawer, whatever)
    2) once a year (at the end of the year for the...
  32. Replies
    4
    Views
    160

    Re: Save Image to Database TSQL issue

    Not having worked with TSQL, my Bet would be


    insert into tblPicture1 (AcctNo, MCard,FileName)
    SELECT '900901', img.*,'ChurchPhoto' FROM Openrowset( Bulk...
  33. Replies
    3,266
    Views
    324,670

    Re: What song are you listening to right now?

    Who would have thought, that an Iron Maiden-Song could be played in "chilled" Style?
    Absolutely brilliant

    https://www.youtube.com/watch?v=5CtMFJDmKmY
  34. Re: Access 2003 selecting dates. Can't seem to do a single day

    Easy!
    Store the dates as Double in your Database.
    MS Access only understands US-Format or ISO-Format, but a DateTime is still a Double.


    -- ISO YYYY-MM-DD HH:NN:SS
    MY_DATE_FIELD = #2021-06-23...
  35. Re: Setting submenu item Checked results in error 387

    IIUC, the moment he checks to invite his drunk uncle, that there is also a checkmark at "invite family".
    the same the other way round:
    the moment he unchecks the last Family-member in his sub-menu...
  36. Replies
    4
    Views
    195

    Re: very strnage string trancate issue

    Maybe something here: https://www.sqlshack.com/sql-truncate-enhancement-silent-data-truncation-in-sql-server-2019/
  37. Replies
    4
    Views
    195

    Re: very strnage string trancate issue

    Why do you have a Default when you allow Null?
    Would have expected to be enough


    [CrCustomerData] [nvarchar](150),


    OTOH, this would make more sense.
    It would Default to empty String if no...
  38. Replies
    35
    Views
    667

    Re: Got a new computer - password story

    Truer words were never spoken….
  39. Replies
    35
    Views
    667

    Re: Got a new computer - password story

    Fair enough.
    I actually do tell the users that NOT sharing their password is part of the job instructions (and thusly part of their contract).

    If they adhere to it, that‘s what i don‘t care about.
  40. Replies
    35
    Views
    667

    Re: Got a new computer - password story

    Let's just say, that specific guy "enjoys" living in the "ivory tower" (and lets everyone know it.... "Me=Cake, you=crumbs")

    When my boss asked me, if i could give him advice on who needs what...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width