Search Results - VBForums

Search:

Type: Posts; User: gibra

Page 1 of 13 1 2 3 4

Search: Search took 0.03 seconds; generated 12 minute(s) ago.

  1. Thread: VB6 and SQL

    by gibra
    Replies
    1
    Views
    57

    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:
  2. Replies
    14
    Views
    223

    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:
  3. 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, ...
  4. 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...
  5. 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
    ...
  6. Thread: Datagrid

    by gibra
    Replies
    11
    Views
    275

    Re: Datagrid

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

    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...
  8. Replies
    20
    Views
    452

    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?
  9. 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
    ...
  10. 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
  11. Replies
    11
    Views
    287

    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:...
  12. Replies
    6
    Views
    359

    Re: Innerjoin on sql

    What's your problem about INNER JOIN ?
  13. Replies
    5
    Views
    273

    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
  14. Replies
    4
    Views
    174

    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:
  15. Re: Error:Query must have atleast one destination field

    And the query is ????????
  16. Replies
    4
    Views
    241

    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...
  17. Re: Connecting to Oracle Database via Visual Basic 6

    http://www.connectionstrings.com/oracle/
  18. 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"
  19. Replies
    17
    Views
    529

    Re: Need help taking a screenshot

    In Command1_Click() event, after :


    Picture1.AutoRedraw = True

    add:



    Picture1.Width = Screen.Width
  20. Re: Can I copy all properties from one control to another in s single statement?

    In Design Mode you can use MZTools 3.0 (free) or CodeSMART 2013 (not free) add-in.
    Both have the appropriate commands:

    - Copy control with code
    - Paste control with code

    all events are...
  21. Re: [RESOLVED] Changing file (Open with) programmatically

    My code is working good but is the Windows 8.x system that work differently:


    This appear on my Windows 8.1 (Italian language)
    ...
  22. Re: Changing file (Open with) programmatically

    To show the OpenWith system dialog:



    Shell "Rundll32.exe shell32.dll, OpenAs_RunDLL " & sPath, vbNormalFocus


    where sPath contains the complete path of the file you want change
  23. Replies
    2
    Views
    368

    Re: Export Report in PDF from VB 6.0

    What is ReportViewer?
  24. Re: VB4 controls have moved from all but first SSTab control. How do I move then back

    Are you sure to use SSTab control?
    Looks more like the behavior of the TabStrip control...
  25. Re: SQL query to link tables with same structures using vb6 and ADODB connection?

    You may use UNION :



    SELECT field1, field2, ...
    FROM TA

    UNION

    SELECT field1, field2, ...
  26. Replies
    14
    Views
    689

    Re: VB6 Project Not Loading.

    The registration of an ActiveX component 'must' increment a counter (in Registry) that keeps precisely NUMBER applications that use it.
    Then, when you uninstall an application from the system, the...
  27. Replies
    3
    Views
    359

    Re: Mask a TextBox in KeyPress Event

    I suggest to use a Microsoft Masked Edit control (MSMASK32.OCX).
  28. Replies
    14
    Views
    689

    Re: VB6 Project Not Loading.

    I think you made some trouble, compromising the integrity of the components in your system.
    What you did not do it, you should not do. Never .
    Maybe it's better that rerun setup VB6 and choose the...
  29. Re: How To open MDF LDF SQL files AND Convert Them To Access Table

    Maybe you should post this question in Database forum...
  30. Replies
    22
    Views
    641

    Re: Creating pdfs from Word 2010 using vb6

    Then you can use a PDF Printer (like PDF Creator, Adobe PDF, ...)

    1. Set the PDF Printer As Default printer
    2. use ShellExecute using the 'print' verb for lpOperation parameter
    3. ReSet the...
  31. Replies
    6
    Views
    298

    Re: VB6: Error 13 - Type Mismatch

    I tried this:



    Const gFbaSalesRankTier2 = 10000
    Const strSalesRank As String = "17472"

    If CLng(strSalesRank) <= CLng(gFbaSalesRankTier2) Then
    'bFBAQtyExceeded =...
  32. Re: Make .exe error "you don't have permission to save in this location ...

    And the location is ?
  33. Replies
    27
    Views
    754

    Re: Call Query in Access from VB6

    Query or Function?
  34. Re: using CDate dosnt work proper why?

    Use DateAdd() and DateDiff() functions to calculate dates.
    If you use Access database see here:

    MS Access: DateAdd Function
    http://www.techonthenet.com/access/functions/date/dateadd.php
    MS...
  35. Replies
    20
    Views
    2,093

    Re: To disable minimize and close button in VB6

    Yes.


    Sorry for you: I'm not problem, YOUR project has problem:


    Reference=*\G{F3781BA0-FAAA-11D1-8B3E-DCAA556D18B8}#1.0#0#..\..\..\..\VB Etc\VB, Database, & HTML...
  36. Replies
    20
    Views
    2,093

    Re: To disable minimize and close button in VB6

    DLL is missing.
  37. Replies
    25
    Views
    1,179

    Re: VB6: More Textbox Validation

    You can also use the Microsoft Masked Edit Control, that is made for this:

    Using the MaskedEdit Control
    http://msdn.microsoft.com/en-us/library/aa733654(v=vs.60).aspx
  38. Replies
    6
    Views
    463

    Re: Access no longer working in S7 XP mode

    However, in VB6 (and any other language) don't need MSAccess to open a MDB database.

    Show the code you use to open database.
  39. Thread: vb6 error

    by gibra
    Replies
    3
    Views
    223

    Re: vb6 error

    Hi, yuor code:

    If "SELECT * FROM CLIENT WHERE CLIENT_NAME = ('" & txt_Client.Text & "')" Then
    is wrong because SELECT statement is used to open a recordset, or to execute a query i.e.



    Dim...
  40. Re: how to make autocomplete text box search In DB

    More simple:


    rs.Filter = "FullName LIKE '%" & txtDesc.Text & "%'

    But you should think to use a external form to show the results of filter.
    Because a filter may return more records,
    ...
Results 1 to 40 of 495
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.