Search Results - VBForums

Search:

Type: Posts; User: gibra

Page 1 of 13 1 2 3 4

Search: Search took 0.04 seconds.

  1. Thread: Runtime Error

    by gibra
    Replies
    7
    Views
    119

    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.
  2. 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.
  3. Re: How to check (user clicked) OR (opened at startup) ?

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

    your query return to me 4four record



    DateOfTrans

    Debit
    creditamnt
    InvoiceNo
  5. Replies
    6
    Views
    175

    Re: autofill combox dinAmiclly

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

    Explain better...
  6. Replies
    5
    Views
    160

    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...
  7. Replies
    5
    Views
    160

    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...
  8. Thread: Index Records

    by gibra
    Replies
    4
    Views
    145

    Re: Index Records

    I agree.

    In table: change field type from STRING to NUMERIC.
  9. Replies
    6
    Views
    196

    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:
    ...
  10. Replies
    6
    Views
    197

    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
    ...
  11. 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 ?
  12. 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.
    ...
  13. Replies
    5
    Views
    143

    Re: A TDBGrid coloring question

    Also, you can use Styles:

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

    Re: Recordset has no data

    ...and CursorLocation is ???
  15. Replies
    46
    Views
    1,209

    Re: Creating printable labels

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

    Re: Recordset has no data

    this is the correct way:



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


    below
  17. 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?
  18. Thread: VB6 and SQL

    by gibra
    Replies
    8
    Views
    345

    Re: VB6 and SQL

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

    by gibra
    Replies
    8
    Views
    345

    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:
  20. Replies
    17
    Views
    416

    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:
  21. 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, ...
  22. 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...
  23. 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
    ...
  24. Thread: Datagrid

    by gibra
    Replies
    11
    Views
    289

    Re: Datagrid

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

    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...
  26. Replies
    20
    Views
    501

    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?
  27. 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
    ...
  28. 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
  29. Replies
    11
    Views
    312

    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:...
  30. Replies
    6
    Views
    390

    Re: Innerjoin on sql

    What's your problem about INNER JOIN ?
  31. Replies
    5
    Views
    301

    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
  32. Replies
    4
    Views
    182

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

    And the query is ????????
  34. Replies
    4
    Views
    255

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

    http://www.connectionstrings.com/oracle/
  36. 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"
  37. Replies
    17
    Views
    567

    Re: Need help taking a screenshot

    In Command1_Click() event, after :


    Picture1.AutoRedraw = True

    add:



    Picture1.Width = Screen.Width
  38. 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...
  39. 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)
    ...
  40. 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
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.