Recent content by gloudo

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...

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...

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...

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 +...

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

No, still the same error.

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...

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".

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 =...

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

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...

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()...

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...

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

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