Search:

Type: Posts; User: ktab

Page 1 of 2 1 2

Search: Search took 0.03 seconds.

  1. Replies
    4
    Views
    2,072

    Re: Loop controls to addHandler

    tried your idea before your second post.. which is brilliant :)
    Just pass a string instead of eventinfo itself.
  2. Replies
    4
    Views
    2,072

    Re: Loop controls to addHandler

    Job id done, thank you for the help
    Updated code is:

    Private Sub HandleMyControls(ByVal evt As EventInfo, ByVal Proc As EventHandler)

    For Each c As Control In Controls
    ...
  3. Replies
    4
    Views
    2,072

    Loop controls to addHandler

    Hello,

    I have the following code to dynamically add handler to my controls

    Private Sub HandleMyControls(ByVal Proc As EventHandler)

    For Each c As Control In Controls
    ...
  4. Replies
    14
    Views
    1,625

    Re: SQL Join tables and sum columns

    it's mdb (wanted to use a file/mobile db: any other suggestions are more than welcome)
  5. Replies
    14
    Views
    1,625

    Re: SQL Join tables and sum columns

    I will experiment some with your code and tell you the results :)
  6. Replies
    14
    Views
    1,625

    Re: SQL Join tables and sum columns

    number (double)
  7. Replies
    14
    Views
    1,625

    Re: SQL Join tables and sum columns

    It's just the int at invoicetype field. 1 is sales 2 is purchases
  8. Replies
    14
    Views
    1,625

    Re: SQL Join tables and sum columns

    Ok, as it's very difficult to transfer here all tables structures, I will give a sample and if i figure out, i can solve the rest

    Table "Products"

    RecordID int

    Table "Transactions"
    ...
  9. Replies
    14
    Views
    1,625

    Re: SQL Join tables and sum columns

    Almost solved. The above gives me an error at query builder when i enter,

    but when I execute query, i get the desired results... what could be the problem?
  10. Replies
    14
    Views
    1,625

    Re: SQL Join tables and sum columns

    SELECT modProducts.Product_Name, SysProductCategories.Product_Category, SysProductSubCategories.Product_SubCategory, modProducts.ProductDescription,
    ...
  11. Replies
    14
    Views
    1,625

    Re: SQL Join tables and sum columns

    The 2 sums are already in:

    SELECT modProducts.Product_Name, SysProductCategories.Product_Category, SysProductSubCategories.Product_SubCategory, modProducts.ProductDescription,
    ...
  12. Replies
    14
    Views
    1,625

    SQL Join tables and sum columns

    Hello,
    I have the following query to my tableadapter:

    SELECT modProducts.Product_Name, SysProductCategories.Product_Category, SysProductSubCategories.Product_SubCategory,...
  13. Replies
    5
    Views
    66,789

    Re: Analog Clock Control

    Great one, thank you.

    May I suggest an update to users, another solution in order not to set manually UTCoffset...

    Place next function in your solution:


    Public Function GetUTCOffset() As...
  14. Thread: Query datatable

    by ktab
    Replies
    2
    Views
    730

    Re: Query datatable

    nice one, thanx o/
  15. Thread: Query datatable

    by ktab
    Replies
    2
    Views
    730

    Query datatable

    Hello,

    If I would connect to database I would run a query like this:
    "Select distinct Column1, column2 from tablename where somefield=somevalue order by column2"

    How can I run this query to a...
  16. Replies
    3
    Views
    827

    Re: Array from 2 datatable columns

    sorry for taking so long to answer back, but i had a small insident with my pc and had to set it up all over again.
    I got an error (Error:Range variable name can be inferred only from a simple or...
  17. Replies
    3
    Views
    827

    Array from 2 datatable columns

    Hello.
    Since now, I have the following:
    Dim x = ( _
    (From row In _Obj_DataSet.Tables(TableName).Rows() _
    Select row(ID_ColumnName)).ToArray())

    How can I...
  18. Replies
    5
    Views
    929

    Re: Array shorting, numbers as text

    .paul..
    Thank you very much. I love 1 line coding :)
    Nice one.
  19. Replies
    5
    Views
    929

    Re: Array shorting, numbers as text

    done:
    Dim m() As String = Split(frmExcludedColumns, ",")
    Array.Sort(m, AddressOf MyArrayComparer)

    For y As Integer = UBound(m) To 0 Step -1
    ...
  20. Replies
    5
    Views
    929

    Re: Array shorting, numbers as text

    actually, yeap, it's sort :P (a most common mistake I alway make :/ )

    And this is what I had in mind, to recreate an array() as integer by converting the array created by split. I just wanted to...
  21. Replies
    5
    Views
    929

    Array shorting, numbers as text

    While split a textline with numbers (integers), i get an array with numbers as string.
    Is it possible to short them? Array.short does not work as it shorts according the first number of the integer...
  22. Re: Datagrid with joined tables as datasource bindingsource

    Well.. first of all i load my db in a dataset. These are my constants:
    Public _Obj_DataSet As DataSet
    Public _Obj_DataAdapter As OleDbDataAdapter
    Public _Obj_BindingSource As...
  23. Datagrid with joined tables as datasource bindingsource

    When I update a record at table [Product] with the integer that stands for [Supplier Name] from joined table [Suppliers], this does not appear in my datagridview. Instead, I have to reload the table...
  24. Replies
    4
    Views
    3,400

    Re: BindingSource filter: between 2 numbers

    No probs, I trap keys for numeric keys only and also i get math.max and math.min to get the values.
    Like this: (actually a part of my code)


    Dim TempDouble1 As Double, TempDouble2 As Double
    Dim...
  25. Replies
    4
    Views
    3,400

    BindingSource filter: between 2 numbers

    Hello.

    How may I filter a bindingsource between 2 numbers? Obviously "column_name BETWEEN Num1 AND Num2" does not work, since "between" operator is not supported. Any ideas?
  26. Replies
    5
    Views
    566

    Re: Identify a control in container

    To do so, i guess i have to go to "Edit" and edit (?) title? Or is it done otherways?
  27. Replies
    5
    Views
    566

    Re: Identify a control in container

    It works both ways :P
    I had made a mistake at the value of "i" integer, that's why it failed ;)
    Thank you any way
  28. Replies
    5
    Views
    566

    [RESOLVED] Identify a control in container

    Hello all

    I have the following problem. I want to loop a control array that each of them, is not in the same container (frame), to give values.
    What i do, is this (form).(control...
  29. Replies
    1
    Views
    372

    Combo control and list

    Hello,

    When i used to work with MS forms2 and VBA, i used to set the list of a combobox like: cbTest.List=strArray() where strArray is an one dimension array...
    Is there a way to fix the list of...
  30. Replies
    6
    Views
    591

    Re: Recordset.update... how it works?

    I think that i solved it...
    converted the string at procedure that opens recordset from:

    .Open strSQL, mobjConn, adOpenDynamic, adLockBatchOptimistic, adCmdText
    into:

    .Open strSQL, mobjConn,...
  31. Replies
    6
    Views
    591

    Re: Recordset.update... how it works?

    And the connection...

    Public Sub ConnectToDB()

    Dim strConnect As String, strPassword As String

    If Not Ping_Connection Then Exit Sub

    strPassword = "*****" 'masked ;)
    strConnect =...
  32. Replies
    6
    Views
    591

    Re: Recordset.update... how it works?

    Opens recordset:

    Public Sub OpenRecordSet(Optional Table_Name As String)

    If Not ConnectedToDB Or Not Ping_Connection Then Exit Sub

    If MyTable = "" Then MyTable = "Members"

    If Table_Name =...
  33. Replies
    6
    Views
    591

    Re: Recordset.update... how it works?

    ADO.. MS Access
    The connection is already open (not opening/reopening)
  34. Replies
    6
    Views
    591

    [Resolved] Recordset.update... how it works?

    Hello,

    I have tried the following code to update my recordset, but changes are lost as soon as i reopen recordset... What is the problem with that?


    Public Sub Save_Data()
    Dim i As Long
    With...
  35. Re: Problem with combo to display international text

    I'm interested only in greek and english language support.. I've already tested that and it works. So i think i'm covered with .charset
  36. Re: Problem with combo to display international text

    worked like a dream...
    All is needed is add the public const for greek (161) and add a code line like:


    .......
    frmTask.Ctrl(i).FontUnderline = .FontUnderline...
  37. Re: Problem with combo to display international text

    experimenting is evolution. I'll give a try to all your ideas, and i'm sure i'll find the way out. Thank you for all you time and advices
  38. Re: Problem with combo to display international text

    My question, is exactly, how may I modify charset. And how to check it's value before apply?
    When the form loads, combos are by default MS Sans, 8, regular, and are displayed as it should.
    This app...
  39. Re: Problem with combo to display international text

    Standard VB combos.
    An example of how manipulate fonts is as follows:

    Private Sub cmdFont_Click()
    Dim i As Long

    With Me.cmDialog
    .CancelError = True
    On Error Resume Next
    .Min =...
  40. Problem with combo to display international text

    Hello,

    I have the following problem.
    In a form, I have a set of combos, where font is set to MS Sans Serif, size 8, regular. If i change anything of it, it displays greek alphabet from AB...ect ...
Results 1 to 40 of 58
Page 1 of 2 1 2



Click Here to Expand Forum to Full Width