Timer?

JvM

Registered User.
Local time
Today, 01:38
Joined
Jan 7, 2003
Messages
68
Good afternoon,

I want a form to open after closing a querie.

How can I do this when I don't want to use a form to start the querie?

Can anybody help me?

Greetings.

Jan
 
How are you running the query?

IMO
 
JvM said:
I don't want to use a form to start the querie?

why not?

Col
 
A user activates it. So its opens and after closing it, I want a form to open..

Jan
 
Well, I'm looking for a way to go around this way.

In an other dbase I have a query start up from a form. When the query is closed after an up date the form isn't shown maximized any more.

I've tried to go around this by Docmd.max... ing every where possible..

Now I want to try something differend..

Jan
 
I want it to activate just by clicking on it..

But maybey you can tell me a way to work around my form troubles..

I tried closing the form and reopening it after open query statement but then the form reopens before you can update the query.

So I would want to put back the reopen command tíll the query is updated/..

Jan
 
How often does this query need to be run? The only thing I can think of is to create a macro called 'autoexec', select the query first in the list and the form to open second in the list, but this will only run when the DB is started. I can't understand why you dont have a button on a form which could do both with a single click.

IMO
 
I don't want the form showing not maximized..

Should the button close the form. Run the query and reopen the form.. Is this possible after each other?

Jan
 
You could have the button just run the query, the form can stay maximized. This is the code for the OnClick event of the button...
Code:
Private Sub YourButton_Click()
On Error GoTo Err_YourButton_Click

    Dim stDocName As String

    stDocName = "YourQuery"
    DoCmd.OpenQuery stDocName, acNormal, acEdit

Exit_YourButton_Click:
    Exit Sub

Err_YourButton_Click:
    MsgBox Err.Description
    Resume Exit_YourButton_Click
    
End Sub

IMO
 
Good morning,

Sorry for the later reply.. Weekend..

If tried it like you suppose but still after closing the query the form is shown smaller and doesn't maximize when I click it. Can it be that because the query isn't openend maximized that the form doesn't resize?

Greetings,

Jan
 

Users who are viewing this thread

Back
Top Bottom