Search Results - VBForums

Search:

Type: Posts; User: Arnoutdv

Page 1 of 13 1 2 3 4

Search: Search took 0.06 seconds.

  1. Replies
    18
    Views
    245

    Re: 862nd Form and "Out of memory" Error

    I'm not going to advise you to change your project, nor am I going to say get rid of some forms, I'm also not telling you to merge the functionallity of some forms in a single form, but somehow you...
  2. MsOf10 Re: External table is not in the expected format error

    Do you get the error from within Excel or when using Excel automation?

    http://stackoverflow.com/questions/1139390/excel-external-table-is-not-in-the-expected-format...
  3. MsOf10 Re: External table is not in the expected format error

    Have you tried the default xlsx format of Excel (2007 and up)?
  4. Re: Printer.Font.Underline not working

    When I replace the Printer object with the current form then it seems to work.


    Dim s As String

    With Me

    .ScaleMode = vbMillimeters
    .Font = "Arial"
  5. Re: progressbar with no timer possble?

    You need to give more information.

    A skeleton could look like this:


    Public Sub MyLengthyRountine()
    Dim oRS As ADODB.Recordset
    Dim iPercentage As Integer, iPrevPercentage As Integer
    ...
  6. Re: progressbar with no timer possble?

    But using the Sleep API you will hold all processing.
    It seems that you have a routine which needs to be initialized, then some processing needs to be done and then a message to indicate the work is...
  7. Re: progressbar with no timer possble?

    Sleep API
  8. Re: [VB Rich Client 5] - Getting out of memory error when opening RS

    Based on the size of your table you need also at least 600MB for the created recordset plus the amount of overhead of getting the data from the database -> interface -> recordset.
  9. Replies
    12
    Views
    209

    Re: IndexOutofRangeException

    Then it is not a string array, but a single string.

    You need to use string manipulation:
    https://msdn.microsoft.com/en-us/library/aa903372%28v=vs.71%29.aspx
  10. Replies
    12
    Views
    209

    Re: IndexOutofRangeException

    How is rx defined and how do you get the data.

    You are using the rx variable as if it's an array of string values, but it's seems it's not an array of strings, just a "large" string.
  11. Replies
    21
    Views
    359

    MsOf07 Re: VBA and ADO Connection

    Maybe start with something simple to get used with how to program in VBA.
    Then if you grasp the concept of variables, objects, strings etc etc, just then step into the world of database programming.
  12. Thread: response

    by Arnoutdv
    Replies
    18
    Views
    329

    Re: response

    Maybe you are calling the service to many times in a row and you are blocked and/or the connection is refused for some limited time.
  13. Replies
    21
    Views
    359

    MsOf07 Re: VBA and ADO Connection

    DAO?

    It should be possible using ADO 2.x and this provider "Provider=Microsoft.ACE.OLEDB.12.0"

    https://www.connectionstrings.com/access-2007/...
  14. Replies
    15
    Views
    320

    Re: framework 4...

    Just try it, but the target PC at least needs .Net Framework 3.5.
    Maybe it's already installed, maybe not...
  15. Replies
    21
    Views
    359

    MsOf07 Re: VBA and ADO Connection

    If you place quotation marks round a variable name then it will be a literal text.


    Dim team As String
    team = departmentcombobox.text
  16. Replies
    15
    Views
    320

    Re: framework 4...

    The other way is to download and install the .Net 4 runtimes on the target computer:
    http://www.microsoft.com/en-us/download/details.aspx?id=17851
  17. Replies
    21
    Views
    359

    MsOf07 Re: VBA and ADO Connection

    You should start with adding "Option Explicit" as the first line of the module you are working in.

    This will cause at least an error on


    .CommandText = handlerbydept

    Because...
  18. Replies
    21
    Views
    359

    MsOf07 Re: VBA and ADO Connection

    What is the "&_" doing in the string
    Also objconn seems to be a Connection object.
    You can not just assign a string to it.


    Dim sDBPath As String, sConnection As String
    Dim oConn As...
  19. Replies
    3
    Views
    145

    Re: VB to make VBA module

    Have you tried using the Macro recorder to see what happens before and after the print preview?
  20. Replies
    28
    Views
    808

    Re: Windows 10 and vbNewLine

    There is also no difference when using a variable instead of a predefined constant:


    Option Explicit

    Private Const CRLF As String = "CL" ' pseudo delimiter

    Private Sub Form_Click()
    Dim...
  21. Replies
    5
    Views
    196

    Re: vb error message

    Hello octor, you don't have to introduce yourself in every posting :)

    If you want to check if you have added any items to the Listbox List1, just refer to the .ListCount property of the ListBox....
  22. Replies
    3
    Views
    149

    Re: Russian text is broken in Label.Caption

    Indeed many VB6 controls don't support unicode.
    Look in the Codebank for a Unicode control set by Krool....
  23. Re: [RESOLVED] how to insert table into CDO text body

    It seems you are correct.
    Then you would need to build the normal .Text property yourself, otherwise the content may not be visible for some users.
    Unless you know your audience :)
  24. Re: [RESOLVED] how to insert table into CDO text body

    About the plain text, maybe this can be of any help to you
  25. Re: [RESOLVED] In such situation [select case or elseif] more fast?

    Yup, from the help:
  26. Re: VB-Count the number of occurences in string(Helppp mee)

    strText = val(txtboxword.Text)
    strLetter = val(txtboxLetter.Text)

    What do you think happens in the above 2 lines?
  27. Replies
    20
    Views
    309

    Re: ?????

    But if you want to find 1 of the possibilties then why do you use <> instead of =



    Do While (fullprg(loc + 1) = ">(" & var1name & ");") Or (fullprg(loc + 1) = ">(" & var2name & ");")
  28. Replies
    20
    Views
    309

    Re: ?????

    You are making no sense.

    Just guessing, the "OR" should be an "AND"

    Then just for further information, dim your variables properly.
    So use


    Dim pr As String
  29. Replies
    20
    Views
    309

    Re: ?????

    Or what??

    You should repeat the compare statement:


    Do While (fullprg(loc + 1) <> ">(" & var1name & ");") Or (fullprg(loc + 1) <> ">(" & var2name & ");")
    loc = loc + 1
    Loop
  30. Re: create database in SQL server management studio 2008 R2

    Creating the database, tables, queries etc can all be done using ADO.NET
    https://msdn.microsoft.com/en-us/library/dw70f090%28v=vs.110%29.aspx
  31. Re: create database in SQL server management studio 2008 R2

    A simple Google search reveals a lot of samples.
  32. Re: [RESOLVED] Read A Specific Line From Big Text File

    Very basic sample:



    Dim fID As Integer
    Dim sLine As String
    Dim lLineCnt As Long

    fID = FreeFile
    Open "PathToYourFile" For Input As #fID
  33. Re: How do I copy d codes from codebank into my computer to run the program?

    Did you actually buy Visual Basic 6, a product from 1997, 18 years old?

    If you are new to VB programming why not start Visual Basic Express?


    Visual Basic works with projects, you first create...
  34. Replies
    9
    Views
    206

    Re: vb consult sequential file by date

    In the Input statement the variable "fe" holds the date of current line.
    If you want to add only lines with a specific date then you should compare the date in "fe" with the desired date.

    Like...
  35. Replies
    43
    Views
    902

    Re: String Out Of Space ???

    I think we can't fix your project if we don't see more of it...
  36. Replies
    8
    Views
    334

    4.0 Re: C# show file images .dgn

    In the article the first word is SharpMap, which is a hyperlink to https://sharpmap.codeplex.com/
  37. Replies
    8
    Views
    334

    4.0 Re: C# show file images .dgn

    Somehow I think xuantruongbn is not the creator/programmer of MicroStation SE.
    There must be a hidden question somewhere in his post. :rolleyes:
  38. Replies
    43
    Views
    902

    Re: String Out Of Space ???

    A basic standard string concatenation test, performed in the IDE:


    Private Sub Form_Load()
    Dim MyString As String
    Dim i As Long
    Dim l As Long

    MyString = "Hello"
    For i = 1 To 100
  39. Re: Facing problem in CreateObject("MSXML2.ServerXMLHTTP.6.0")

    I assume the needed library is not available on all target machines.
  40. Replies
    43
    Views
    902

    Re: String Out Of Space ???

    Can you post a basis sample project with some data files in which this problem occurs?
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.