Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. gloudo

    Form focus problem

    Thanks DHV this helped me partly, but You sent me in the right direction, wich resulted in the solution. By adding acdialog in the docmd.openform line , the text generated in the function didn't came through. But by putting it as the openargs it's working like a charm now. Thanks for your...
  2. gloudo

    Form focus problem

    Hi all, I Have a problem keeping the focus on a form. When my database generates an error I have an Error handler wich opens a form showing the error details. This all works fine, but because the form loads from the line below it takes the focus back after runnung the code and hides the error...
  3. gloudo

    directory indexer over a network

    I'm building an intranet for my company with a couple of limmitations. For one, the documents can't be placed on the webserver. (Policy) The documents are on a file server. Im trying to find a directory indexer wich is capable of indexing a network directory wich is not on the webserver. I...
    • gloudo
    • Thread
    • Replies: 2
    • Forum: PHP
  4. gloudo

    determine which commandbarbutton is pressed

    This is what I have on clicking OK after inserting the password: Private Sub Cmd_OK_Click() Dim Msg, Style, Title, Response, MyString Msg = "Dit formulier is alleen met een Password te openen!" + Chr(10) + "Wilt u doorgaan?" ' Definieert bericht. Style = vbRetryCancel + vbCritical +...
  5. gloudo

    determine which commandbarbutton is pressed

    Hi HarleyQuinn, Yes I tried it but before I insert a password the form goes on to "Frm_Tabel_Archief
  6. gloudo

    determine which commandbarbutton is pressed

    No, still the same error.
  7. gloudo

    determine which commandbarbutton is pressed

    I changed the code into the following: Private Sub Cmd_OK_Click() Dim Msg, Style, Title, Response, MyString Msg = "Dit formulier is alleen met een Password te openen!" + Chr(10) + "Wilt u doorgaan?" ' Definieert bericht. Style = vbRetryCancel + vbCritical + vbDefaultButton2 ' Definieert...
  8. gloudo

    determine which commandbarbutton is pressed

    It gives: Runtime error 91, Object variable not set or with block variable not set. What I want is: When pressing the button "Archive" or "Inspection" in Menu (KRS2005) a popup form (Frm_PW) opens where the user must submit a password before continueing to the form "Archive" or "Inspections".
  9. gloudo

    determine which commandbarbutton is pressed

    I have a bit of code I can't get to work. I have 2 buttons on a custom menu(KRS2005) Button1 "Archive" and Button2 "Inspection". I found this piece of code on the net but I can't get it to work. Private Sub Form_Open(Cancel As Integer) Dim cmdBCtl As CommandBarControl Set cmdBCtl =...
  10. gloudo

    UserForm Focus Problem

    Yeeeha, It worked great. I put the Userform.repaint in the "With" instruction And it workt flawless. Thanks Everyone Greetings Thijs
  11. gloudo

    UserForm Focus Problem

    My Excel Version is 2000 Whith the focus loss The Frame of the UserForm Stay's visible, but the The middle of the form is completely white. The Picture and the message are indeed a label and an image control. Both inserted in design-time. Even When I Remove both the msg and img the Form gets...
  12. gloudo

    UserForm Focus Problem

    Here is my code for displaying the Userform Sub Query() Load UserForm1 UserForm1.Show End Sub The code on activation Sub UserForm_Activate() Call Main End Sub and I made some changes to my main macro. The problem occurs at: Sheets("Amsterdam").Select Sub Main()...
  13. gloudo

    UserForm Focus Problem

    The problem is the macro is not loopable. And the form is Just a standby message with an Image. See below: Sub Main() Application.ScreenUpdating = False With UserForm1 .Caption = "Bezig met opdracht..." End With Sheets("Amsterdam").Select...
  14. gloudo

    UserForm Focus Problem

    I have A userform wich must be shown while running a macro. The userform pops up like it should be, but the form is empty because it lost the focus. My question is: Is there a simple way to keep the focus on the userform while the macro runs? Thanks
  15. gloudo

    Mouse Button?

    Hi There, Is it possible to toggle the right mouse button on and off in excel? Even in the commandbar region. Or how do I lock The commandbars alltogether, except my own menubar? Thanks
  16. gloudo

    Combobox scroll

    How can I make a combobox scroll visible through a list, so when I'm searching a value in the list I don't have to guess where it is. Thanks
  17. gloudo

    Filter Dates in current week

    Hi there, I like to filter all the records in a query of wich the date is in the current week. And when the week changes the dates of that week must be filtered, and so on. Can anybody tell me the expression for this query? thanks :)
  18. gloudo

    Copy first character from textbox

    Thanx compucop.
  19. gloudo

    Copy first character from textbox

    Can anybody help me? How do I select the fist character from a textbox and then put it in a msgbox? Thanx
  20. gloudo

    Insert file

    Hi There, I like to automate a function in my database. I have an Objectbox(Foto) and A Textbox(Titel) When I enter the Objectbox, the first letter in the textbox must be selected, the focus must go to the objectbox, than the file-insert system must be opened in the directory with the same...

Part and Inventory Search

Back
Top