Slow append query and reports cannot be open

[Guest]

Hi all,

I have an append query that ,when run ,is very slow
Is there a way to make it faster ?

Another question,i have a database that i tarnsferred the database from
computer to another one ,now i cannot open my reports ,not even in design
view ?!!

One more question , iwant to put a condition through VB that closes a
certain form (csq2) if it's open who can i do this ?

 

[Bill Mosca, MS Access MVP]

You will get better responses if you ask only one question per post.

1. Without seeing the SQL for the query and the indices for the table(s)
involved, I can't really give you any advice on how to speed it up.

2. Make sure you have a default printer selected for the machine. If the
reports are set to use a specified printer, be sure that printer is
available to that machine.

3. This code will close the form named csq2
Const conObjStateClosed = 0
Dim strFormName As String

strFormName = "csq2"
'check if form is closed. If it is, go to end of sub
If SysCmd(acSysCmdGetObjectState, acForm, strFormName) =
conObjStateClosed Then
exit sub
Else
DoCmd.Close acForm, strFormName
End If

 

[Guest]

I'd like just to tell you that ,in question 2,I want the form to be closed
only in the following case If [serial of CSQ2]!<>[fORMS]![CSQ]![SERIAL]
How can i do that using the code you have described in question n.2 ?