dcsimg

Search:

Type: Posts; User: Zvoni

Page 1 of 13 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    15
    Views
    395

    Re: Run time Error 35603 Invalid Key

    When you open your Recordset, do you have (valid) Recordsets (RecordCount>0)?
  2. Thread: xls to csv

    by Zvoni
    Replies
    4
    Views
    161

    Re: xls to csv

    I think it's the other way round: He's taking data from an Access-DB, shoving it into Excel, and then what? Export to CSV?
  3. Replies
    7
    Views
    253

    Re: Centering text in a MsgBox

    Nice Victor, but.....

    ....do i really have to say anything?.... :p
  4. Replies
    15
    Views
    395

    Re: Run time Error 35603 Invalid Key

    Correct.
    It's also why i said to first delete from Database, and if that is successful, then (and only then!) delete from Listview.

    EDIT: Using the first Parameter of the Execute-Method of the...
  5. Re: SQL - Error when formatting string to date in yyyy-MM-dd

    Have you tried "5" as conversion-type?

    or this:


    SET DATEFORMAT dmy
    SELECT convert(datetime,DocApprovedDate)

    http://sqlusa.com/bestpractices2005/sqlserverstringtodate/
  6. Replies
    7
    Views
    253

    Re: Centering text in a MsgBox

    You don't!

    1) create your own Form "frmMessageBox"
    2) Use Task Dialog (as mentioned by Sherin)
  7. Replies
    15
    Views
    395

    Re: Run time Error 35603 Invalid Key

    Probably because he expects, after he does the ListView.ListItems.Add, that the added item is automatically the SelectedItem....

    Nevermind, that if that code had worked he would fail a few lines...
  8. Re: SQL - import also the hyperlinks when bulkcopying from Excel

    AFAIK, a Hyperlink is a separate Property of a Cell (like Formula), since there is a difference between the hyperlink, and the "friendly" Name/Text shown in the cell.
    So if you grab just the data...
  9. Re: How do I get a screenshot of an entire Form, not just what is visible in the wind

    Mabye this?

    https://docs.microsoft.com/de-de/windows/win32/gdi/wm-printclient?redirectedfrom=MSDN
  10. Replies
    20
    Views
    756

    Re: Detect power outage

    Laptop! I wouldn't know of a (Desktop)-PC to run on batteries.
    You need to recognize the switch from AC to DC
  11. Replies
    20
    Views
    756

    Re: Detect power outage

    To build up on that: An (old) Laptop, connected to the LAN and server.
    Code a small app with the API-call in my Post#2
    Since it's a laptop which is plugged directly into a power outlet, a power...
  12. Replies
    4
    Views
    154

    MsOf365 Re: [excel] For Each Overflow

    Correct until Excel2003.
    2007 and later (xlsx) don't have that boundary anymore
  13. Replies
    20
    Views
    756

    Re: Detect power outage

    If it's recently bought i would be surprised if it doesn't have that feature.
    Could you tell as the brand/model of the UPS?
  14. Replies
    20
    Views
    756

    Re: Detect power outage

    You're right. I missed that.
    Usually a UPS is connected to the server via Ethernet or USB, and the UPS itself should send a "Shutdown"-Signal to the server in case of an outage,
    or the server...
  15. Replies
    24
    Views
    663

    Re: Capture hotkey and insert text in textbox

    Written in Excel-VBA with UserForm and Label1. Adapt to VB6


    Private Declare Function GetAsyncKeyState Lib "user32.dll" (ByVal vKey As Long) As Long
    Private Const VK_CONTROL = &H11
    Private...
  16. Replies
    20
    Views
    756

    Re: Detect power outage

    How about this?
    https://docs.microsoft.com/en-us/windows/win32/api/winbase/nf-winbase-getsystempowerstatus
  17. Replies
    7
    Views
    336

    Re: Question about Design-Concept

    GM, that matches the second approach of jmc's post.
    Hmm, so basically it would boild down to a SQL like ".... WHERE tbl_logbook.RiggNumber=tbl_Rigg.RiggNumber AND JumpDate Between tbl_Rigg.StartDate...
  18. Replies
    22
    Views
    656

    Re: string and substring

    Well, Luca is italian, but so are you.
    takes one italian to know another........
    *runaway*
    :p:cool::D:wave:
  19. Replies
    7
    Views
    336

    Re: Question about Design-Concept

    tg, that's basically my approach with the 4 Foreign Keys from the Rigg-table to copy them into the Logbook (replace (and expand) tbl_logbook.Rigg_ID with tbl_logbook.AAD_ID, tbl_logbook.Harness_ID...
  20. Replies
    7
    Views
    336

    Re: Question about Design-Concept

    Mc, thx for your insight. It comes close to initial thoughts i had on that problem.
    What i wanted to avoid is that there are multiple entries for a RiggNumber, albeit i know that those entries would...
  21. Replies
    22
    Views
    656

    Re: string and substring

    Nice one!
    But keep in mind, this is only going to work if you actually have something between text and number you can use as a delimiter.
    My code works without space/blanks between text and number....
  22. Replies
    7
    Views
    336

    Question about Design-Concept

    Hi Folks,
    i was asked by my skydiving club to design a database (incl. a Frontend written in Lazarus/Freepascal) to manage our students.
    Development is going to be probably on a SQLite-DB, Rollout...
  23. Replies
    22
    Views
    656

    Re: string and substring

    Private Declare Function StrSpn Lib "SHLWAPI" Alias "StrSpnW" (ByVal lpSource As Long, ByVal lpCharSet As Long) As Long
    Private Declare Function StrCSpn Lib "SHLWAPI" Alias "StrCSpnW" (ByVal...
  24. Replies
    22
    Views
    656

    Re: string and substring

    Chris, i was thinking about that, too, but, frankly, Regex just looks like Chinese in backwards to me :D
  25. Replies
    22
    Views
    656

    Re: string and substring

    Hmmm, if it's always "SomeText - SomeNumbers - Sometext" i'd rather go the route with the strCSpn/Strspn-API-Combination, then it doesn't matter what Text (which/how many characters are before or...
  26. Re: ERROR: The process cannot access the file . . .

    1) Is the "*.mdf" pure happenstance, or why do you access a SQL Server-File directly (instead through the Server-Instance)?
    2) The File is in the C-Rootdirectory (where usually no user has any...
  27. Re: StrPtr( ) for UDT has a strange problem

    I'm more surprised the OP's example compiles.
    ReDim b(1) As cc
    You reserve Memory for 1 (!) Variable, which has Index 0
    He prints StrPtr(b(0).zq) and StrPtr(b(1).zq), which both have the same...
  28. Replies
    17
    Views
    541

    Re: Recursive permutation

    Permutation = Order of draw matters —> bab<>abb
    Combination = Order doesn‘t matter —> bab=abb
    in OP‘s case it‘s a Combination with repetition
    e.g. classic Lottery or classic Poker is a combination...
  29. Thread: Forms display

    by Zvoni
    Replies
    4
    Views
    257

    Re: Forms display

    No cigarette lighter and ashtray? I'd complain.....
  30. Replies
    29
    Views
    674

    Re: Find missing rows

    Pete,
    brilliant!
    I always forget the damned SUMPRODUCT-Function.

    Martin,
    i tried Pete's formula.
    Attached.
  31. Replies
    17
    Views
    541

    Re: Recursive permutation

    and according to his sample-data i wouldn't be surprised if it's not a permutation he's looking for, but a combination.
    Permutation: Order matters
    Combination: Order doesn't matter
  32. Re: Memory is full and proccesorload is increasing

    I've just read the manual for the dll (it's in german).
    What it says for "OpenDevice":
    It opens a Communication Link to the Card, and if successful, returns the Address of the card.
    It loads the...
  33. Re: Memory is full and proccesorload is increasing

    The only thing i cannot judge is the ConnectCard, LogPrint, Clear-/SetAllDigital and Clear-/SetDigitalChannel-Functions
    A Memory-Overflow is often due to creating Objects as new without...
  34. Replies
    29
    Views
    674

    Re: Find missing rows

    As i said for Non-VBA: What i could find out: Only with Helper-Columns
  35. Replies
    9
    Views
    397

    Re: How do i remove all know space from string

    I'd say dil's approach is the best one, if the OP's provided sample is correct that all "spaces" are trailing spaces.
    IIRC, the Trim-Function (and its sisters) would also take care of all other...
  36. Replies
    29
    Views
    674

    Re: Find missing rows

    Martin,
    please find my VBA-Approach without HelperColumns, but with "Look&Feel" of native Excel-Functions.
    And i'm pretty sure the code can be improved. :D
  37. Replies
    9
    Views
    329

    Re: Latest Windows 7 update

    The TreeView is part of MSCOMCTL.OCX
    Is the file in the System-Directory? Have you tried re-registering it?
  38. Replies
    29
    Views
    674

    Re: Find missing rows

    I'll take your word for it, cause i couldn't really find anything related to it
  39. Replies
    29
    Views
    674

    Re: Find missing rows

    Even as hidden columns somewhere to the far right?
    Because in any case: It's either the Helpercolumns or it's VBA.

    The functionality you're looking for is a VLOOKUP (find out if a Value is in a...
  40. Replies
    29
    Views
    674

    Re: Find missing rows

    Maybe, but this implies VBA, and Martin wants to avoid VBA
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width