Search:

Type: Posts; User: si_the_geek

Page 1 of 13 1 2 3 4

Search: Search took 3.76 seconds.

  1. Replies
    11
    Views
    340

    MsOf365 Re: ADODB for 64-bit

    What is the actual error you are getting now?
  2. Replies
    11
    Views
    340

    MsOf365 Re: ADODB for 64-bit

    That is not the case, ADODB was not an issue at all.

    The previous issue was that the provider Microsoft.OLEDB.12.0 was not registered (and it wasn't, because it doesn't even exist).


    As you...
  3. Re: I am getting either the Errors in ListView1_Click Event

    The Workbooks collection only contains the files that are already open in that instance of Excel, and you haven't opened any.

    What you should do is open the relevant workbook, work with it, and...
  4. Re: I am getting either the Errors in ListView1_Click Event

    Your link is for VBA (rather than VB.Net), so various things are different - including the fact that there is a completely different ListView control (the VBA one has ComctlLib.ListItem as a data...
  5. Replies
    11
    Views
    340

    MsOf365 Re: ADODB for 64-bit

    This part is still wrong:

    ...and that will cause the error.


    Make sure you properly copy one of the examples in the link I provided.
  6. Replies
    11
    Views
    340

    MsOf365 Re: ADODB for 64-bit

    According to a quick web search, 'Microsoft.OLEDB.12.0' is not a provider at all.

    Presumably you intended to use the JET provider (but you can't, as that is 32-bit only) or more likely the ACE...
  7. Re: How to make Xamarin Android App talk to VB Desktop Application

    In that case something along the line of jmcilhinney's idea is probably the way to go.

    Presumably you currently have two separate databases (one for the VB app, and one for the Xamarin app), so...
  8. VS 2017 Re: [RESOLVED] NAudio - add silence into existing wav file

    The issue is because bytesPerMillisecond is an Integer.

    The value of 176400 / 1000 should be 176.4, but because you are storing it in an Integer only 176 is stored, and that difference creates the...
  9. Replies
    3
    Views
    201

    Re: Just to say ...

    We're happy to help, and we're glad you've joined our community :)
  10. Replies
    8
    Views
    332

    Re: If EndIf 4 possibilities

    Well yes, my caveat of "basically" wasn't really good enough... I was just trying to avoid confusing the thread starter. :)
  11. Replies
    8
    Views
    332

    Re: If EndIf 4 possibilities

    'Is' and 'IsNot' aren't meant for checking values (they are basically for checking if two object-variables have the same pointer).

    Use = and <> as you did in the other parts of the code.


    ...
  12. VS 2010 Re: need help understanding one line of code that does a replacement of text

    Those lines of code (especially the savebutton line) are much longer and more complex than ideal... and that means they are very hard to read, which increases the chances of issues like you are...
  13. VS 2022 Re: Removing the last line carriage from a string

    Not quite, the For loop is set up to start at item 1 (instead of item 0).

    That means for the first item you have no Newline, but you add a NewLine before each of the other items.
  14. Re: Looking for database in all the wrong places

    Try it without specifying the folders, ie:

    Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|MasterBase2.0.accdb
  15. VS 2019 Re: Filter & Search Inside FlowLayoutPanel

    In modern versions of Visual Studio you can spread a single line of code across multiple lines, in order to help readability.

    In this case, those first four lines are the exact equivalent of this...
  16. Replies
    438
    Views
    64,836

    Re: Hamilton 5x World Champion ?

    It certainly seems to be (I heard some stuff in commentary in the last race), but a quick web search didn't show anything recent

    Here's some highlights of the changes, which do seem like they will...
  17. Replies
    17
    Views
    668

    VS 2019 Re: [RESOLVED] Read Two Tables information

    Use similar code to what you already use elsewhere:

    Dim imageData As Byte() = DirectCast(cmd.ExecuteScalar(), Byte())
    If imageData IsNot Nothing Then
    ...
  18. Replies
    17
    Views
    668

    VS 2019 Re: Read Two Tables information

    For Access based databases you should put braces around each layer of joins, eg:

    FROM
    (OrdersAssigned
    LEFT OUTER JOIN Profiles AS ProfilesFrom ON OrdersAssigned.orderacc =...
  19. VS 2019 Re: Connessione sottostante chiusa errore imprevisto durante un'operazione di ricezio

    Welcome to VBForums :wave:

    This is an English speaking site, please post only in English.


    A translation of the original post:
  20. Replies
    438
    Views
    64,836

    Re: Max 1x World Champion ? You bet!

    Well done Max, a worthy winner. :thumb:

    The strategy decisions by his team all made sense... for example not pitting under the safety car was the right thing to do, because if Lewis pitted and Max...
  21. Replies
    3
    Views
    326

    Re: Recommendation

    VS 2022 has recently been released, and isn't in our prefix list yet... so please could it be added? :)
  22. Re: Procedure to delete certain files

    You are lucky I spotted your post. The best way to let moderators know about something like this is to use the "Report this post" link (triangle icon) at the bottom of a post.

    Based on the first...
  23. Re: convert date timespan with regional time

    The +200 part could be written as +2:00 (ie: 2 hours and 0 minutes), I'm don't know why the standard is without the colon.

    Note that some time zones aren't exact hours (eg: +0030 is possible), so...
  24. Replies
    15
    Views
    1,340

    Re: code conversion from vb.net to vb6.0

    XmlWriter is specific to .Net, and there is no VB6 equivalent that I am aware of (bear in mind that VB6 is older than XML).

    You would need to re-write the code entirely, so it is best to ask in...
  25. Replies
    4
    Views
    480

    Re: Recordset closure error.

    Welcome to VBForums :wave:


    We have anti-spam measures here, including a system that means some posts from new users are temporarily hidden until they are checked by a moderator - your first post...
  26. Replies
    63
    Views
    2,727

    Re: Ignoring moderators

    Well I guess some people might want to shave by candle light (during a power outage), so it isn't that bad... unlike the warning labels on packets of nuts, eg: "warning: may contain nuts"
    ...
  27. Replies
    9
    Views
    560

    Re: Project Gets Lost Somewhere

    The likely reason for the issues is not the order of references etc, but the fact that the contents of one of them is unknown.

    As a library is missing, the compiler cannot tell if it contains a...
  28. Replies
    5,019
    Views
    421,777

    Re: Corona virus, China major city lockdowns, etc.

    https://www.vbforums.com/member.php?39991-manavo11

    He moved to Bristol about 10 years ago, and we met up several times for drinks over the first couple of years... we even had a visit one weekend...
  29. Re: DllRegisterServer failed with error code 0x80004005

    Near the bottom of that programs list should be a folder called "Windows System", and Command Prompt should be in there.
  30. Replies
    63
    Views
    2,727

    Re: Ignoring moderators

    Moderators and Admins sometimes need to deal with rule violations etc and communicate something about that in a thread... In order for that to work, we need everybody to see our post.

    The forum...
  31. Re: DllRegisterServer failed with error code 0x80004005

    Another potential issue is that for this you should run command prompt as an admin (it doesn't happen automatically, even if you user is an admin).

    To do that, right-click on the link to command...
  32. Re: DllRegisterServer failed with error code 0x80004005

    If you are using command prompt, you can do it like this:

    cd c:\windows\syswow64
    regsvr32.exe "c:\PathToDll\dllname.dll"
    ...or:

    c:\windows\syswow64\regsvr32.exe "c:\PathToDll\dllname.dll"
  33. Re: DllRegisterServer failed with error code 0x80004005

    If you are using a 64-bit version of Windows and the dll is 32-bit, you need to use the version of regsvr32 in the windows/syswow64 folder
  34. Replies
    12
    Views
    720

    VS 2019 Re: Progress Bar count users + Timer

    That .ToString does not belong there at all, and it is causing the issue.

    The .Value property wants a number, and accountCount is a number... you shouldn't be converting anything to/from String.
  35. Replies
    15
    Views
    1,088

    Re: Many old unresolved threads

    Some threads can't be solved. Sometimes that is because it is technically impossible (such as: how do I determine the date format from "3/4/21") , and other times it is because the thread starter...
  36. VS 2019 Re: Drag & drop to Specific Listview folder

    I would assume that if there is no node at the specified point, the .GetNodeAt method will return Nothing/Null.

    As such, you should ensure that the Selected variable doesn't contain Nothing before...
  37. Re: Search String Array by Multiple Words

    Change the order of the loops, so that for each file you can check how many words match.

    eg:

    For Each file In files
    Dim foundWords = 0
    For Each searchWord As...
  38. Replies
    15
    Views
    962

    Re: Load Event Aborting

    In some circumstances errors that occur in the Load event get swallowed up, try moving the code to the Shown event instead, as that doesn't have the same issue.
  39. Replies
    5,019
    Views
    421,777

    Re: [RESOLVED] Corona virus, China major city lockdowns, etc.

    That is heavy for rain :D

    I think an editing is more appropriate this time
  40. Replies
    12
    Views
    724

    Re: Moving PictureBox with Timer

    Welcome to VBForums! :wave:

    Instead of checking the entire .Location , you should be checking just the part that changes (the .Location.Y).

    It would also be a good idea to not check for an...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width