Search:

Type: Posts; User: bolcskei

Page 1 of 4 1 2 3 4

Search: Search took 0.09 seconds.

  1. Replies
    3
    Views
    446

    Re: function in SQL

    error 1004. rountime (left) cannot be resolved.
  2. Replies
    3
    Views
    446

    function in SQL

    Hi guys,


    I would like to add some functions to my SQL. I have the following code, bute I would like to change it to another one. has anybody an idea?
    pls help.

    Boris

    before
  3. Replies
    2
    Views
    504

    mouse over tip text

    Hi gyus,

    I would like to create a small routine, which give (showing the yellow tip text box) me back during mouse over event the chart height and width

    Has anybody idea how to do it?
    ...
  4. Replies
    2
    Views
    292

    Re: problem with copy

    the filename is name of file I have opened. when I work with exported databased, the sheet has equal name as the file.

    for example PH060405
  5. Replies
    2
    Views
    292

    problem with copy [RESOLVED]

    Hi to all,

    can anybody tell me why this code is wrong? Both of files are opened.



    Workbooks(filename).Sheets(filename).Range(Cells(1, 3), Cells(50, 3)).Copy _...
  6. Replies
    4
    Views
    9,578

    Re: msoFileDialogFilePicker problem [RESOLVED]

    Thanks for a tip I will try it. Somethimes I am asking primitive things, because I am not a programmer.
  7. Replies
    4
    Views
    9,578

    Re: msoFileDialogFilePicker problem

    I was checking the problem. I think the problem is, after I open the file I can just use the name of the file, without the filename path.
    thefore I have to from this:
    C:\Documents and...
  8. Replies
    4
    Views
    9,578

    msoFileDialogFilePicker problem [RESOLVED]

    Hi guys,

    I would like to set colors of active workbook equal to a selected xls file. To do this I would like to use msoFileDialogFilePicker. I have the following code:


    Private Sub...
  9. Re: load colors from closed xls file

    I would rather open and hide file and read data from opened file. Thanks.
  10. load colors from closed xls file [RESOLVED]

    Hi guys,


    As a part of an Excel add-ins, I would like to load colors from a selected file. The code described below wrote me back an Error 9. It is because my intention was load colors from...
  11. Thread: Imagelist

    by bolcskei
    Replies
    7
    Views
    677

    Re: Imagelist

    I have only VBA and thefore I was not able to import your example.
  12. Thread: Imagelist

    by bolcskei
    Replies
    7
    Views
    677

    Re: Imagelist

    what kind of picture file I can attach to imagelist?
  13. Thread: Imagelist

    by bolcskei
    Replies
    7
    Views
    677

    Re: Imagelist

    I was already trying do it this way. But after defining imagelist and images I did not see imagelist in toolbar as you described it in step 4. Do you have any idea, where is a mistake?
  14. Thread: Imagelist

    by bolcskei
    Replies
    7
    Views
    677

    Imagelist

    Hi guys,

    Can anybody help me how is it possible to define an imagelist for userform?
    I would like to create userform with toolbar and I would like to define form some buttons icons.

    Thanks.
    ...
  15. Replies
    0
    Views
    750

    coloring pivotfield.item [RESOLVED]

    Hi guys,

    I would like to prepare code which will color pivotfield.pivotitem.labelrange. So far I have prepared the following code:


    Dim pvtfield As PivotField
    Dim pvtitem As PivotItems
    Set...
  16. Re: change spinbutton value after textbox event [RESOLVED]

    I did not know that. I do not like to use linked cell, because I like to prepare macros independent to opened file. Of course the linked cell I use with controls in Excel.
    But, thanks for an idea.
  17. Re: change spinbutton value after textbox event

    I did a mistake. Textbox do not have click event.
  18. Re: change spinbutton value after textbox event

    I have MS Office XP.

    "Showing" spinbutton value in textbox I have done. It works fine. But I would like to do a opposite procedure. To set the value of spinbutton based on the value of textbox....
  19. Re: change spinbutton value after textbox event

    I am sorry. It is in Excel and I have VBA.
  20. change spinbutton value after textbox event [RESOLVED]

    Hi guys,

    I have probably very simple problem. I would like to set spinbutton value equal to textbox. I am using the following code:


    Private Sub TextBox3_Click()
    UserForm1.SpinButton2.Value =...
  21. Replies
    9
    Views
    1,063

    Re: Format color in pivot

    I do not like to use selection too. But the first code was my first try for my problem. Now I have better solution, but I am still not satisfied with it. But it work as I wanted.
  22. Replies
    9
    Views
    1,063

    Re: Format color in pivot

    Thanks for a try. Insteade of my previous code I have start to use this one:
    Set pvtField = ActiveSheet.PivotTables("PivotTable1").PivotFields(j)
    s = pvtField.VisibleItems.Count...
  23. Replies
    9
    Views
    1,063

    Re: Format color in pivot

    Yes I want to do it in Excel. I am using this code. But I do not want to use a selection method

    ActiveSheet.PivotTables("PivotTable1").PivotSelect "" & i & "[All]", xlLabelOnly _
    , True
    ...
  24. Replies
    9
    Views
    1,063

    Format color in pivot

    Hi guys,

    I would like to format interior color of all labels of a certain pivotfield. Has anybody idea?

    Thanks.

    Boris
  25. Replies
    10
    Views
    1,058

    Re: create add-ins for MS Access

    I wrote in my post. Have in an add-ins textbox, where I can copy SQL query code a have possibility to find a selected text and replace it with another.
  26. Replies
    10
    Views
    1,058

    Re: create add-ins for MS Access

    I know, that when I create excel file I can save it as add-ins. But I did not see such a possibility in access. May be it woulb be enough for me have any access file which can be modified. I think I...
  27. Replies
    10
    Views
    1,058

    Re: create add-ins for MS Access

    Where I can do these steps. I have only VBA. Did you meant do it in visual studio?
  28. Replies
    10
    Views
    1,058

    Re: create add-ins for MS Access

    Thanks for a try, but I do not think that add-ins is suitable for my problem, may be I have described my intention in wrong manner. Somethimes I am editing SQL command copied from Access in Word...
  29. Replies
    10
    Views
    1,058

    create add-ins for MS Access

    Hi guys,

    I would like to create add-ins for MS access. I am already long time bored during editing SQL code copying it to MS Word and using find and replace function. I would like to do add-ins...
  30. Replies
    2
    Views
    594

    Re: pivot field combobox event?

    For example you can have
    Private Sub ComboBox1_Click

    and I would like to have something for pivots

    PivotTables("PivotTable3").PivotFields("year")_Click
    or perform some action after changing...
  31. Replies
    2
    Views
    594

    pivot field combobox event?

    Hi guys,

    During my work I am using pivots in reporting in Excel. Can anybody help me how is possible to make pivot field combobox event sensible? For example change event.

    Sincerely

    Boris
  32. Replies
    4
    Views
    484

    Re: formating date

    Hi Hack,

    Sorry, I have understood just the first question. The macro is a part of excel file and the excel file was just copyied to the other machines. everything is done in that file and thefore...
  33. Replies
    4
    Views
    484

    Re: formating date

    yes. but actually machines of my collagues do not know "date", thefore I have tryed to use "now". These machines as I wrote do not know "format" function.

    and I do not know why.
  34. Replies
    4
    Views
    484

    formating date

    Hi guys,

    I have urgent problem. I have finally prepared an excel file where in the modules I am using format function.
    UserForm1.TextBox1.Value = Format(Now, "dd.mm.yy")

    This code is running...
  35. Replies
    3
    Views
    399

    Re: problem with SQL in VB

    Many thanks. I have tryied your suggestion at home and it works. I have shortened the query enough.

    Boris
  36. Replies
    3
    Views
    399

    Re: problem with SQL in VB

    It works, but I have an userform using which I can do almost any combination of query. I can choose to see any column, I have possibility to use up to 5 ordering criteria and combine with 3 where...
  37. Replies
    3
    Views
    399

    [RESOLVED] problem with SQL in VB

    Hi to all

    Happy New Year to everybody.

    Guys I have the following procedure to create query in excel. I have changed the whole command text by a combinations of several strings (select, where...
  38. Replies
    10
    Views
    924

    Re: textbox and mouse_down event

    Thank you
  39. Replies
    10
    Views
    924

    Re: textbox and mouse_down event

    I have Visual Basic Editor as a part of office and thefore I think I have VBA.
  40. Replies
    10
    Views
    924

    Re: textbox and mouse_down event

    That time I have changed it to

    Private Sub Textbox4_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single)
    If Button = 1 Then UserForm2.Show
    End Sub

    But it did not worked. I...
Results 1 to 40 of 154
Page 1 of 4 1 2 3 4



Click Here to Expand Forum to Full Width