Search Results - VBForums

Search:

Type: Posts; User: gibra

Page 1 of 13 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    3
    Views
    192

    Re: vb6 + vs2103 issue

    Try :
    1. Uninstall vb6/vs6
    2. Remove all vb6/vs6 folders in Program Files
    3. Remove all Registry entry related to vb6/vs6
    4. Restart pc
    5. Re-install vb6/vs6

    You can also use my tool VS6...
  2. Replies
    8
    Views
    438

    Re: Install VB6 in Win 8.1 ,Is possible ?

    @7edm
    of course isn't a problem of my web site, otherwise they would not have 36,953 downloads.
    I use KIS 2015 (Kaspersky) with no problem.
    Try to disable your antivirus, first.
  3. Replies
    8
    Views
    438

    Re: Install VB6 in Win 8.1 ,Is possible ?

    Windows 8.x and Windows 10 too.
    You can try my tool (need original CD's, of course):


    http://nuke.vbcorner.net/Portals/0/download/Tools/VS6Installer/VS6Installer4.gif
  4. Thread: Runtime Error

    by gibra
    Replies
    7
    Views
    228

    Re: Runtime Error

    Do not need to know it, you'll just use the Replace() function.
    See the help file about it.

    But, the best way is: use a Command with Parameters.
  5. Re: How to check (user clicked) OR (opened at startup) ?

    Why? What your need to discovery?
    Explain your goal...



    Nothing to do with your question.
  6. Re: How to check (user clicked) OR (opened at startup) ?

    What? :eek:
  7. Re: Removing Duplicate Rows (Please Help)

    your query return to me 4four record



    DateOfTrans

    Debit
    creditamnt
    InvoiceNo
  8. Replies
    6
    Views
    270

    Re: autofill combox dinAmiclly

    What's your problem?
    What result you want to achieve?

    Explain better...
  9. Replies
    5
    Views
    224

    Re: Method Open of Object_Recordset failed

    CAST is not supported by Access.

    You may use:


    ORDER BY CLng(Student_ID)
    Caution: is there a record wich Student_ID is empty or NULL then you get a error.

    However, keep the Student_ID...
  10. Replies
    5
    Views
    224

    Re: Method Open of Object_Recordset failed

    First of all:

    The correct way to open a recordset is:

    Dim rs As ADODB.Recordset
    Set rs = New ADODB.Recordset

    see
    10 ADO best practices - TechRepublic...
  11. Thread: Index Records

    by gibra
    Replies
    4
    Views
    195

    Re: Index Records

    I agree.

    In table: change field type from STRING to NUMERIC.
  12. Replies
    6
    Views
    245

    Re: Background Image on MDI Form

    VB Helper: HowTo: Give an MDIForm a resizing background picture
    http://www.vb-helper.com/howto_mdi_background_picture.html


    If you want center image, replace this line:
    ...
  13. Replies
    6
    Views
    242

    Re: Disable Tab on TextBox

    You can use the KeyPress events:


    Private Sub Text1_KeyPress(KeyAscii As Integer)
    If KeyAscii = vbKeyReturn Then
    KeyAscii = 0 ' avoid the beep when Enter key is pressed
    ...
  14. Re: compiling on different operating system question

    In your project, are you referenced ADO 6.x or ADO 2.x ?
    Your Windows 7 include SP1 ?
  15. Re: PrintDlgEx failed to return full name of my Network printer

    First of all, the instruction:


    If Printer.DeviceName <> strNewPrinterName Then

    return always True, because strNewPrinterName variable is always on upper case, while Printer.DeviceName not.
    ...
  16. Replies
    5
    Views
    173

    Re: A TDBGrid coloring question

    Also, you can use Styles:

    http://helpcentral.componentone.com/nethelp/truedbgrid8/default.htm#!applyingcellstylesbycontents.htm
  17. Replies
    24
    Views
    584

    Re: Recordset has no data

    ...and CursorLocation is ???
  18. Replies
    53
    Views
    1,696

    Re: Creating printable labels

    Are you sure that Excel and/or Word are availbles for any/all users ?
  19. Replies
    24
    Views
    584

    Re: Recordset has no data

    this is the correct way:



    Public cnOracle As ADODB.Connection
    Set cnOracle = New ADODB.Connection


    below
  20. Re: how to auto conected internet when disconected on windows 7

    Windows already auto connect automatically to internet.
    why do you want to reinvent it?
  21. Thread: VB6 and SQL

    by gibra
    Replies
    8
    Views
    396

    Re: VB6 and SQL

    10 ADO best practices - TechRepublic
    http://www.techrepublic.com/blog/10-things/-10-ado-best-practices/
  22. Thread: VB6 and SQL

    by gibra
    Replies
    8
    Views
    396

    Re: VB6 and SQL

    Check your connection string here:

    SQL Server connection strings - ConnectionStrings.com
    https://www.connectionstrings.com/sql-server/

    also, your declares are worng:
  23. Replies
    17
    Views
    457

    Re: Count and Sum using SQL (MS Access and ADO)

    This help you?


    SELECT Count(*) AS Lot, Sold
    FROM TB
    GROUP BY Sold


    Will return the below result:
  24. Re: How to use ADODB.Recordset.Fields to append a field that can save large string?

    But not so for all ADO DataType constants:
    i.e. doesn't exists a VbVarTypevalue for large fields as: adLongVarChar , adLongVarWChar , adLongVarBinary, ...
  25. Re: How to use ADODB.Recordset.Fields to append a field that can save large string?

    Sorry for you, but vbString is a member of VBA VbVarType enum; isn't a member of ADODB DataType enum, so use it is totally wrong.

    When you use ADODB, you must use a ADODB DataType, as indicates in...
  26. Re: How to use ADODB.Recordset.Fields to append a field that can save large string?

    Append Method (ADO)
    https://msdn.microsoft.com/en-us/library/windows/desktop/ms681564(v=vs.85).aspx

    DataTypeEnum
    https://msdn.microsoft.com/en-us/library/windows/desktop/ms675318(v=vs.85).aspx
    ...
  27. Thread: Datagrid

    by gibra
    Replies
    11
    Views
    311

    Re: Datagrid

    Sorry, but you are not clear (to me at least) ...
  28. Replies
    20
    Views
    567

    Re: AppActivate issue

    Your code is working. ;)

    I've tried with:

    AppWFM = "Google - Internet Explorer"
    and IE will activated correctly.

    How do you see this confirms what I said in my previous post about the...
  29. Replies
    20
    Views
    567

    Re: AppActivate issue

    Not always the window title inlcude Windows Internet Explorer, on my pc shows Internet Explorer only.

    What functions you uses to read and activate the window using the hwnd?
  30. Re: Runtime Error 1004 Sorting in Excel from VB6

    Sort require a Range object, in this line:

    oSheet.Sort.SetRange Range(Temp) ' This is the instruction that causes the 1004 error
    Range object could not be created implicitly.

    Try
    ...
  31. Re: trying to check if a printer name is found i get a error variable not define

    Missing reference?

    Error in vb when using IWshRuntimeLibrary.WshNetwork-VBForums
    http://www.vbforums.com/showthread.php?249255-Error-in-vb-when-using-IWshRuntimeLibrary-WshNetwork
  32. Replies
    11
    Views
    335

    Re: Running a form depending on login

    LOGIN form is better than InputBox

    http://nuke.vbcorner.net/Portals/0/immagini/ProjectLogin/ProjectLogin4_01.png

    source code here:...
  33. Replies
    6
    Views
    447

    Re: Innerjoin on sql

    What's your problem about INNER JOIN ?
  34. Replies
    5
    Views
    358

    Re: mscal.ocx displays with tiny font

    Yuo can use the MonthView, wich is exactly equal the MsCal.ocx

    Simply, from Project -> Components... add the:
    Microsoft Windows Common Controls 2-6.0 (SP6)
    MSCOMCT2.OCX
  35. Replies
    4
    Views
    203

    Re: Question about Multipage

    From Project menu ADD new Form, choose the already Options window template
    This form will help you to understand how TabStrip work. ;)

    :wave:
  36. Re: Error:Query must have atleast one destination field

    And the query is ????????
  37. Replies
    4
    Views
    292

    Re: TabStrip Selection Problem

    You should use Click event (not MouseDown event)

    To understand better how to use TabStrip:

    - create a new project
    - menu Project -> add Form
    - choose Options window

    this create a sample...
  38. Re: Connecting to Oracle Database via Visual Basic 6

    http://www.connectionstrings.com/oracle/
  39. Re: Quickest way to extract a filename and parent folder name from a path string?

    One methods:



    Dim sPath As String
    Dim sFileName As String
    Dim sExtension As String
    Dim sFolder As String

    sPath = "D:\Common\Tools\vb\Unsupprt\MCIWinDx\mciwindx.doc"
  40. Replies
    17
    Views
    674

    Re: Need help taking a screenshot

    In Command1_Click() event, after :


    Picture1.AutoRedraw = True

    add:



    Picture1.Width = Screen.Width
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.