Search:

Type: Posts; User: babbelut

Page 1 of 2 1 2

Search: Search took 0.04 seconds.

  1. Replies
    0
    Views
    844

    MsOf10 Access 2010: Custom image copy/paste

    Hi all,

    I have the following lines in my xml:

    <button idMso="Copy" label="Copy" size="large"/>
    <button idMso="Paste" label="Paste" size="large"/>

    I don't want the normal images but a custom...
  2. Re: Access 2000 VBA: How to change menu item names

    nobody?
    please?
  3. Re: Access 2000 VBA: How to change menu item names

    Hi,

    this is a tutorial how to make a custom menu, but not with vba.
    My menu is fine, I just need to change the text of some menu items on the fly (with vba)

    thanks
  4. Access 2000 VBA: How to change menu item names

    Hi All,

    is it possible to change the menu item names in Access 2000 (with vba)? I can not find how...

    tx!
  5. Access 2000 VBA: How to find out if a text exceeds the textbox/command button-width?

    Hi,

    I want to know how I can find out (in vba) if a text (caption) exceeds the width of a textbox or command button?
    Ofcourse I can see this on my screen, when the text is not fully displayed,...
  6. Replies
    4
    Views
    949

    MsOf10 Re: database version 2010 = 12??

    This gives me the access version of the installed access application.
    I need the access version of the opened database.
  7. Replies
    4
    Views
    949

    MsOf10 database version 2010 = 12??

    Hi all,

    I am writing a vba-function to check in which version an access database was created/saved...

    I use: currentproject.FileFormat


    This is working with all versions except access 2010:...
  8. Replies
    9
    Views
    2,826

    Re: change macro name with vba?

    No, I do not want to change the macro that needs to run.
    I want to change the name that is displayed in the menu
  9. Replies
    9
    Views
    2,826

    Re: change macro name with vba?

    Hi,

    I already found the tutorial for working with commandbars, but i cannot find how to include all the things that are in the macro...

    http://i42.tinypic.com/o8v1ns.jpg

    How do I include...
  10. Replies
    9
    Views
    2,826

    Re: change macro name with vba?

    nobody?
  11. Replies
    9
    Views
    2,826

    Re: change macro name with vba?

    Hi,

    This does work but renames the macro. I need to rename the "macro name" field in the macro (when goïng to edit mode)...
  12. Replies
    9
    Views
    2,826

    Re: change macro name with vba?

    I prefer vba code, because the name depends indeed on the user input...
  13. Replies
    9
    Views
    2,826

    change macro name with vba?

    Hi all,

    I have 3 macro's to create the menu in my access-form.

    MACRO 1:

    DoCmd.AddMenu "&File", "M_File", "File"
    DoCmd.AddMenu "&Edit", "M_Edit", "Edit"

    MACRO "M_FILE":
  14. MsOff2000: How to loop through all forms and reports?

    Hi all,

    i need to loop through all Forms and Reports (opened and closed) but I cannot find how...
    In every Form and report I need to loop through every control.


    Can someone help me please?
    ...
  15. Replies
    2
    Views
    596

    Re: Off2000: Compile error after import data

    The function is written in Form_AfterUpdate() from Preferencessub2 (another subform from Prefs).
  16. Replies
    2
    Views
    596

    Off2000: Compile error after import data

    Hi all,

    I have imported Tables, Forms, Queries and Macro's from a access-2000.mdb to another access-2000..mdb.

    After the import, I get:

    "Compile error: Method or data member not found"

    on...
  17. Re: Off97: Calendar (MSCAL.Calendar.7) needs to show the highest saved date...

    Sorry, it's in access
  18. Re: Off97: Calendar (MSCAL.Calendar.7) needs to show the highest saved date...

    nobody please?
  19. Off97: Calendar (MSCAL.Calendar.7) needs to show the highest saved date...

    I have a form with a calendar-control on it.

    The source of this calendar is the field "DATE", which is in the table "LOGS".
    The default value of field DATE in table LOGS is Date(), so when I add...
  20. MsOf10 Re: Ribbon perfect in office 2007 - showed under "add-ins" in office 2010

    OK, I found how to disable the ribbon items...
    Only "file" is visible now and under file-> Add-ins I can find the items I created in the xml...

    Why are they displayed under add-ins here?
    How can...
  21. MsOf10 Ribbon perfect in office 2007 - showed under "add-ins" in office 2010

    I've created a customized ribbon, which is displayed perfect under office 2007.

    In 2010, the items are also visible, but are under "add-ins"...

    I want to disable "file", "home", "create",...
  22. Replies
    0
    Views
    339

    MsOf07 Ribbon does not work in my form

    In my form_open, I have:

    If Val(SysCmd(acSysCmdAccessVer)) = 12 Then
    Me.Properties("RibbonName") = Me.MenuBar
    End If


    but in office 2007, when I start the form, i get:

    can't run the...
  23. Replies
    2
    Views
    746

    Re: Disable control in other subform

    When I use the code, no error, but also no changes...

    I use this code in a subform to disable a control in another subform. How can I make this possible?


    thanks
  24. Replies
    2
    Views
    746

    Disable control in other subform

    I have a form with several subforms on it.

    When subform A (Continuous Forms) is empty, I want to disable a command button on subform B...

    I already have (in the vba code of subform A):

    ...
  25. Replies
    6
    Views
    602

    Re: Difficult Query

    issue had been solved!
  26. Replies
    3
    Views
    1,342

    Re: VBA: Keep table in variable?

    Function (ID, field, truevalue, falsevalue)

    Set RS = DB.OpenRecordset("SELECT name, " & field & " FROM table WHERE ID = " & ID & ";"

    While NOT RS.EOF
    ' a way to save names and fields(values)...
  27. Replies
    3
    Views
    1,342

    VBA: Keep table in variable?

    In Access I have a table with this structure:

    A : 2
    B : 6
    D : 15
    Z : 2
    ...

    How can I keep this values in a variable in vba? An array seems not to be the way, because myquery("A") does not...
  28. Replies
    6
    Views
    602

    [RESOLVED] Difficult Query

    Hi all,

    i want to build a query but i cannot find the correct one...


    Situation:
    Table one has "ID" and "value"

    example:
    ID= A and value= blue
  29. VBA6.5: How to collapse and expand functions and subs

    Hi all,

    When you have a lot of code, functions and subs in vba6.5, it's very difficult to read the structure and code of the form...

    Is there a possibility (option/add-in/...) to...
  30. Replies
    7
    Views
    829

    Re: Use the same code in several forms

    where in VisualBasic6 can I find the properties of the form (and all the subcomponents)...

    When I would have those properties I could change/replace/resize the form.

    Is there a simple way to do...
  31. Replies
    7
    Views
    829

    Use the same code in several forms

    Hi,

    I have made a tool in vb6 in two versions: a fullscreen and a laptop version.

    Now the problem is, when the code changes, I need to change it two times...
    Is there a solution to this? There...
  32. Replies
    19
    Views
    1,370

    VS 2010 Re: db-timeout when doing refresh

    I tested the connection on another switch and it was very fast... so indeed the reason is a very slow network (So the switch must be checked). I will keep the connectiontimeout-setting offcourse.
    ...
  33. Replies
    19
    Views
    1,370

    VS 2010 Re: db-timeout when doing refresh

    Tool seems to work now, can you explain me what the connection Time does exactly? :s
  34. Replies
    19
    Views
    1,370

    VS 2010 Re: db-timeout when doing refresh

    mySQLconn.ConnectionTimeout = 30


    ConnectionTimeout = 'ReadOnly' ...
  35. Replies
    19
    Views
    1,370

    VS 2010 Re: db-timeout when doing refresh

    Hi,

    I will try your code tomorrow. But the form needs to work 24/24 7/7, so does connectiontime solve this?

    The refresh reloads a listview with (new) information from the SQL-db.
  36. Replies
    19
    Views
    1,370

    VS 2010 Re: db-timeout when doing refresh

    This is the screenshot of the error:

    http://oi53.tinypic.com/2hg8z08.jpg



    And here I call this method:

    Private Sub frmSHF_Load(ByVal sender As System.Object, ByVal e As System.EventArgs)...
  37. Replies
    19
    Views
    1,370

    VS 2010 Re: db-timeout when doing refresh

    I have several msgboxes to check where the error is...


    Private Sub loadSQLConnection()
    mySQLconn = New SqlConnection(mySQLStr)
    Try
    mySQLconn.Open()
    Catch...
  38. Replies
    19
    Views
    1,370

    VS 2010 Re: db-timeout when doing refresh

    No, because in normal debugging I don't have an error. And when installing the tool on all the pc's -> still no error.

    But just one PC is giving this error when running the tool... don't know why,...
  39. Replies
    19
    Views
    1,370

    VS 2010 Re: db-timeout when doing refresh

    No,

    It all goes very fast. When I open the tool everything loads very fast (form is available in a few seconds), but when it wants to reload, this does not work on 1 pc...
  40. Replies
    19
    Views
    1,370

    VS 2010 Re: db-timeout when doing refresh

    Yes, I keep reference to the same connection.

    What do you mean by open all the time by chance?
Results 1 to 40 of 62
Page 1 of 2 1 2



Click Here to Expand Forum to Full Width